How do I repair and\or compactÂ the Directory and Resource Administrator Reporting database to improve the performance?
Directory and Resource Administrator 7.x
Microsoft Access 2000 or later
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:
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