Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Webcast-Catalyst9k
New Member

LMS 3.2 - how to reset DFM Database

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

Everyone's tags (3)
1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: LMS 3.2 - how to reset DFM Database

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

2 REPLIES
Cisco Employee

Re: LMS 3.2 - how to reset DFM Database

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

New Member

Re: LMS 3.2 - how to reset DFM Database

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

1130
Views
0
Helpful
2
Replies
CreatePlease to create content