Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

LMS 3.2 Syslog DBSpaceReclaimer Tool

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
1 REPLY
Cisco Employee

Hi Ricardo,Note: Be careful

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 ***

 

Thanks- Afroz [Do rate the useful post] ****Ratings Encourages Contributors ****
34
Views
0
Helpful
1
Replies
CreatePlease login to create content