How do I repair and\or compact the Directory and Resource Administrator Reporting database to improv (NETIQKB33717)

  • 7733717
  • 02-Feb-2007
  • 19-Jun-2007

Resolution

goal
How do I repair and\or compact the Directory and Resource Administrator Reporting database to improve the performance?

fact
Directory and Resource Administrator 7.x

fact
Microsoft Access 2000 or later

fix

After running an Import in the Directory and Resource Administrator Reporting Tool several times, you may experience performance issues.  The performance of Microsoft Access may start being impacted.  In order to improve performance and repair the database, the following steps can be performed to compact the database:

  1. Launch the Command Prompt on the machine on which the Reporting tool is installed.

  2. From the installation directory (typically \Program files\NetIQ\DRA\Reporting) type the following:

    OaRept.exe /Compact

    The above command will compact and repair the OaRept.mdb and the SERVERNAME mdb files.

    Note: The following syntax will allow you to specify an MDB:

    OaRept.exe /Compact OaRept-server_name.mdb



Additional Information

Formerly known as NETIQKB33717