LMS 3.2 - how to reset DFM Database

Answered Question
Jan 27th, 2010
User Badges:

Hey experts,


I want to reset my DFM database, because there are many entries of (now) unmanaged devices.


So how can I do this correctly on LMS 3.2 without touching the other databases.


I found the following thread in this Forum (https://supportforums.cisco.com/message/694414#694414)


It say´s to do the following steps:


Stop the daemons

cd CSCOpx\bin

perl dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM

perl dbRestoreOrig.pl dsn=dfmInv dmprefix=INV

perl dbRestoreOrig.pl dsn=dfmFh dmprefix=FH

restart the daemons



Can I use this commands in LMS 3.2, too ?

Anything else to do?


Btw. we use the windows version of LMS 3.2.



thx,

Patrick

Correct Answer by David Stanford about 7 years 4 months ago

In addition to these commands, go ahead and delete or rename the following files:


NMSROOT/objects/smarts/local/repos/icf/DFM.rps


NMSROOT/objects/smarts/local/repos/icf/DFM1.rps

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
David Stanford Wed, 01/27/2010 - 07:39
User Badges:
  • Cisco Employee,

In addition to these commands, go ahead and delete or rename the following files:


NMSROOT/objects/smarts/local/repos/icf/DFM.rps


NMSROOT/objects/smarts/local/repos/icf/DFM1.rps

patrick.peuten_2 Thu, 01/28/2010 - 01:02
User Badges:

Hey davistan,


thank you. It worked wonderfully =)

The only thing I had to do after all this steps was to re-install the database access.


The command for this is: \NMSROOT\bin\perl dbaccess.pl install



Summary for all other Users:


net stop crmdmgtd


go to NMSROOT\objects\smarts\local\repos\icf\ and delete the following files ( I even deleted all the other files in this directory )


DFM.rps
DFM1.rps


go to NMSROOT\bin


perl dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM

perl dbRestoreOrig.pl dsn=dfmInv dmprefix=INV

perl dbRestoreOrig.pl dsn=dfmFh dmprefix=FH


net start crmdmgtd


go to NMSROOT\bin


perl dbaccess.pl install



Bye,
Patrick

Actions

This Discussion

Related Content