Solved: LMS 3.2 - how to reset DFM Database

patrick.peuten_2 · ‎01-27-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.

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

David Stanford · ‎01-27-2010

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

David Stanford · ‎01-27-2010

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 · ‎01-28-2010

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