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
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:
- Launch the Command Prompt on the machine on which the Reporting tool is installed.
- 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