RME 4.0.5: Syslog Records - Default purge job

[yjdabear]

Does this indicate a corruption in the db? Maybe that's why my db backup has been getting much bigger after each day.

/var/adm/CSCOpx/files/rme/jobs/syslog/1394.log

[ Tue Jan 08 01:00:01 EST 2008 ],INFO ,[main],Starting purge job 1394

[ Tue Jan 08 01:00:01 EST 2008 ],INFO ,[main], Its a default purge job

[ Tue Jan 08 01:00:11 EST 2008 ],ERROR,[main],Drop table failed:ASA Error -210:

User 'DBA' has the row in 'SYSLOG_20071116' locked 8405 42W18

[ Tue Jan 08 01:00:19 EST 2008 ],ERROR,[main],Drop table failed:ASA Error -210:

User 'DBA' has the row in 'SYSLOG_20071117' locked 8405 42W18

[ Tue Jan 08 01:00:27 EST 2008 ],ERROR,[main],Drop table failed:ASA Error -210:

User 'DBA' has the row in 'SYSLOG_20071118' locked 8405 42W18

[ Tue Jan 08 01:00:34 EST 2008 ],ERROR,[main],Failed to purge syslogs

[ Tue Jan 08 01:00:36 EST 2008 ],ERROR,[main],Purge not successful

[Joe Clarke]

The other thing which takes up a lot of DB space is Change Audit. The Change Audit records can become incredibly verbose, especially inventory chnages. You can reduce the number of Change Audit records created by configuring inventory change filters under RME > Admin > Inventory > Inventory Change Filter. Check the objects you do not care about.

Also note that purging does not reduce the size of the database. The only way to do that is to unload the database, then reload the data into a new DB file. This will "fill in" all the holes created by the various purge processes. This procedure can be dangerous, and is only available by calling the TAC.