purging Ciscoworks databases

Unanswered Question
Mar 15th, 2007
User Badges:


i have a customer that has a CW LMS 2.6 managing more than 1000 equipments.

He has enormous databases and the service level is very degraded.

Is there any thing to do with the database to purge them or to depurate them????

Thank you on advanced.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 3.5 (2 ratings)
dsweeny Wed, 03/21/2007 - 08:09
User Badges:

Try this:

You can rotate a log files using logrot.pl , this script availableNMSROOT/bin logrot.pl

David Stanford Wed, 03/21/2007 - 09:09
User Badges:
  • Cisco Employee,

You won't want to use logrot.pl for databases, this is meant for the log files only. To completely clear your databases you should do the following:

dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM

dbRestoreOrig.pl dsn=dfmInv dmprefix=INV

dbRestoreOrig.pl dsn=dfmFh dmprefix=FH

dbRestoreOrig.pl dsn=rmeng dmprefix=RME

dbRestoreOrig.pl dsn=ani dmprefix=ANI

dbRestoreOrig.pl dsn=cmf dmprefix=Cmf

OLOF SAMUELSSON Mon, 04/02/2007 - 05:31
User Badges:

More than 1000 devices can be managed with CiscoWorks as long as you have the right server hardware and are careful with the server configuration.

The big question is what is filling the databases, if you don't change that they will just get huge again, right?


This Discussion