LMS 3.2 - how to reset DFM Database

Answered Question
Jan 27th, 2010

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

I have this problem too.
0 votes
Correct Answer by David Stanford about 6 years 11 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

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

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