11-16-2011 01:04 AM
Hi All,
From one day to the next our UPM database (upm.db) has blown up from 4 Gb to 35 Gb.
Data purging didn't reduce the size of the db.
What happened ? And how can I compact the db again ?
Thank you for your suggestions.
Solved! Go to Solution.
11-18-2011 09:27 AM
Hi,
You can reinitialize the database if you do not have a requirement to retain the data.
This will delete the contents of the entire database including all polled data, poller and threshold configurations.
1. Stop the Ciscoworks daemons (ie 'net stop crmdmgtd')
2. Take a backup of LMS and HUM
From a command line,
3. cd $NMSROOT\bin (where $NMSROOT is the location of your installation)
4. perl dbRestoreOrig.pl dsn=upm dmprefix=UPM
5. Restart the daemons (ie 'net start crmdmgtd')
6. Wait 20 minutes before logging back on to LMS
If you want to preserve the data:
1. Verify you have at least 2x the size of the upm.db free on the drive.
2. Set the purge schedule to daily for purging all the old data.
3. Run a purge job & wait for the purge job to complete.
4. Stop the Ciscoworks daemons (ie 'net stop crmdmgtd')
5. Take a backup of LMS and HUM
From a command line,
6. Rebuild the database.
6.1 cd $NMSROOT\databases\upm
6.2 dbunload -c "dbf=upm.db;uid=dba;pwd=
Note: replace
7. Wait. This process is time consuming.
8. Restart the daemons (ie 'net start crmdmgtd')
9. Wait 20 minutes before logging back on to LMS
Thanks
11-18-2011 09:27 AM
Hi,
You can reinitialize the database if you do not have a requirement to retain the data.
This will delete the contents of the entire database including all polled data, poller and threshold configurations.
1. Stop the Ciscoworks daemons (ie 'net stop crmdmgtd')
2. Take a backup of LMS and HUM
From a command line,
3. cd $NMSROOT\bin (where $NMSROOT is the location of your installation)
4. perl dbRestoreOrig.pl dsn=upm dmprefix=UPM
5. Restart the daemons (ie 'net start crmdmgtd')
6. Wait 20 minutes before logging back on to LMS
If you want to preserve the data:
1. Verify you have at least 2x the size of the upm.db free on the drive.
2. Set the purge schedule to daily for purging all the old data.
3. Run a purge job & wait for the purge job to complete.
4. Stop the Ciscoworks daemons (ie 'net stop crmdmgtd')
5. Take a backup of LMS and HUM
From a command line,
6. Rebuild the database.
6.1 cd $NMSROOT\databases\upm
6.2 dbunload -c "dbf=upm.db;uid=dba;pwd=
Note: replace
7. Wait. This process is time consuming.
8. Restart the daemons (ie 'net start crmdmgtd')
9. Wait 20 minutes before logging back on to LMS
Thanks
11-18-2011 09:39 AM
I saw this once where a customer added a poller for all ports on all devices.
Did you add a poller?
Cheers,
Michel
11-21-2011 04:11 AM
Hi Michel,
No poller was added recently.
11-22-2011 03:37 AM
Hi ngoldwat,
The procedure worked fine. I have again a slim upm.db without losing data.
Thanks for your help.
Silvia
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide