01-01-2008 03:21 AM
Hi,
Does DFM has a separate database. can I do a reinitialize of DFM database like CM and RME.
with thanks
sathappan
01-01-2008 11:15 AM
Depending on the version of DFM, it has up to five separate databases. DFM 2.0 has three Sybase (ASA) databases, dfmInv, dfmEpm, and dfmFh. Then there is an EMC repository file under NMSROOT/objects/smarts/local/repos/icf/DFM.rps. DFM 3.0 has all four of these databases, plus an additional DFM1.rps repository file for the second instance of DfmServer.
The three ASA databases can be reinitialized using dbRestoreOrig.pl. The rps files can simply be deleted when dmgtd is shutdown, and they will be recreated once the DfmServers start.
01-02-2008 04:38 AM
If you want to know the exact commands for the three DFM databases:
1) Stop daemon
Solaris: /etc/init.d/dmgtd stop
Windows: net stop crmdmgtd
2) Reinit databases:
for DFM databases:
==========================
Solaris:
/opt/CSCOpx/bin/perl /opt/CSCOpx/bin/dbRestoreOrig.pl dsn=dfmInv dmprefix=INV
/opt/CSCOpx/bin/perl /opt/CSCOpx/bin/dbRestoreOrig.pl dsn=dfmFh dmprefix=FH
/opt/CSCOpx/bin/perl /opt/CSCOpx/bin/dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM
Windows:
C:\Progra~1\CSCOpx\bin\perl C:\Progra~1\CSCOpx\bin\dbRestoreOrig.pl dsn=dfmInv dmprefix=INV
C:\Progra~1\CSCOpx\bin\perl C:\Progra~1\CSCOpx\bin\dbRestoreOrig.pl dsn=dfmFh dmprefix=FH
C:\Progra~1\CSCOpx\bin\perl C:\Progra~1\CSCOpx\bin\dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM
3) Start daemon
Solaris: /etc/init.d/dmgtd start
Windows: net start crmdmgtd
Hth!
01-02-2008 09:02 AM
This is incomplete. Without deleting the DFM.rps (and DFM1.rps file in DFM 3.0) the reinitialization will not be successful.
01-02-2008 09:13 PM
Thanks for helping
04-15-2008 10:05 AM
I have been instructed, by TAC support, to re-init DFM 2.0.10 a few times already in an effort to resolve inconsisent and or incorrect email alerting. Both times deleting the .rps file was NOT one of the steps.
Is this something I should be concerned with?
My email alerts broke again and since I couldn't get reliably inconsistent behavior from DFM, I had to close a TAC case yesterday. Today, its broken again.
04-15-2008 10:08 AM
If you reinitialize the Sybase databases, you should also delete the .rps file. I have filed a bug against DFM about missing notifications. The bug is CSCso28593, and a patch is available from the TAC.
04-15-2008 10:33 AM
I'm asking my rep on the last TAC to re-open the case and see if I can get that patch, thanks JC.
04-15-2008 10:53 AM
Is there a way to look this bug up anywhere or is it for TAC reps only?
04-15-2008 11:03 AM
You can try looking in Bug Toolkit on Cisco.com. It is an external bug.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide