How to reinit ANI db? Solaris 9 LMS 2.5

[pcuervo123]

I need advise on how to reinit ani db. I have found in the forum 2 different commands but I'm unsure about the syntaxis. Are both the same?

/opt/CSCOpx/campus/bin/reinitdb.pl

/opt/CSCOpx/bin/dbRestoreOrig.pl dsn=ani dmprefix=ANI

In case i only want to reinit UT db, does the following line do the trick?

/opt/CSCOpx/campus/bin/reinitdb.pl -ut

Is there some CCO reference where I could come accross this kind of troubleshooting information?

[Joe Clarke]

Only use he dbRestoreOrig.pl command to reininitialize the ANI database. Do not use reintdb.pl -ut as this can cause data synchronization issues between Data Collection and UT.

[pcuervo123]

May you confirm the below systaxis is right for solaris and whether I need to previously stop LMS?

opt/CSCOpx/bin/dbRestoreOrig.pl dsn=ani dmprefix=ANI

Is there some CCO reference where I could come accross this kind of troubleshooting information?

[Joe Clarke]

Daemon Management needs to be down before using this command. The syntax is:

/opt/CSCOpx/bin/dbRestoreOrig.pl dsn=ani dmprefix=ANI

The user guide for Campus does talk about reinitializing the ANI database, but it still refers to reinitdb.pl. While using this command with the -restore flag is fine, using it with other arguments can be problematic. I prefer customers use dbRestoreOrig.pl to avoid future ANI problems.