Smarts SAM SDI Adapter: How and why are DMP ("dump") files used? Where does the SDI Archive utility put DMP files in Windows environments?

Products

• VMware Smart Assurance

Issue/Introduction

Symptoms:


How and why are DMP ("dump") files used by the Smarts Service Assurance Manager (Smarts SAM) SDI Adapter?
Where does the SDI archive utility place the DMP files from the Smarts SAM SDI adapter in Windows environments?

What is the location of the DMP files from the Smarts SAM SDI Archive utility in Windows environments?


Smarts SAM SDI Adapter DMP files found in the C:\Windows\SysWOW64 directory

Environment

VMware Smart Assurance - SMARTS

Resolution

To maintain the database, the sdi-archive utility exports data from the database to *.dmp files (along with supporting SDI export and archive log files), and then deletes the data from the database tables, cleaning out the database and reducing its size. In a Windows 32-bit environment, these files are placed in the script directory. In a Windows 64-bit environment, these files are placed in the SysWOW64 directory because the SDI adapter is a 32-bit application.

To manage this process, the sdi-archive utility calls the external utilities exp and sqlpus, and produces the following files (where xxxxxx-xxxxxx is the timestamp string):

• sdi-exportxxxxxx_xxxxxx.log
• sdi-archivexxxxxx_xxxxxx.log
• notifdatxxxxxx_xxxxxx.dmp
• attrsdatxxxxxx_xxxxxx.dmp
• devicedatxxxxxx_xxxxxx.dmp
• summarydatxxxxxx_xxxxxx.dmp

See the SDI adapter user guide section called "Maintaining the database" for more details about these dump files.