LMS 3.2 Syslog DBSpaceReclaimer Tool

[RICARDO SANCHEZ]

Hello Does anybody knows what can be done after run the DBSpaceReclaimer tool?, I only can delete the SyslogSecond.db The SyslogFirst, and SyslogThird cannot be deleted, I do not why. Is another thing more that I can do?, the LMS version is 3.2 Thanks for your help Regards

[AFROJ AHMAD]

Hi Ricardo,

Note: Be careful while you access the DBREADER. if you have any doubt , you can open TAC case to follow the below steps..

You need to go to the dbreader(database) to delete the syslogs tables and put the following in the AD-hoc page:

http://<hostname/ip address>:1741/dbreader/dbreader.html
or
https://<hostname/ip address>:443/dbreader/dbreader.html

User Id: DBA

Password: rmeng db password (default is C2kY2k)

Database Name: rmeng

And click the get tables button.

In the tables look for the SYSLOG_* type of tables and note their names.

 example:   
SYSLOG_20090631          
SYSLOG_20090701
 

Then go back to the Ad-hoc page and issue the following sql statement:

 
DROP TABLE SYSLOG_20090701

 
Delete all the SYSLOG_ files and then issue the below command on the ciscoworks server:

then you need to re-run the DBSPACERECLAIMER script.

Thanks-

Afroz

***Ratings Encourages Contributors ***