dbvalid command

Unanswered Question
Feb 26th, 2009

I know you can use the dbvalid command to verify the integrity of the databases. Is it recommended that you bring down the daemon before running the dbvalid command on the databases. Also, if it find any errors, will it repair them automatically?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Joe Clarke Thu, 02/26/2009 - 15:29

You should not use dbvalid directly. Instead, use the configureDb.pl wrapper. For example, to validate the integrity of the ANI database:

NMSROOT/bin/perl NMSROOT/objects/db/conf/configureDb.pl action=validate dsn=ani

You must have Daemon Manager shutdown to use this tool. This tool does not repair errors. True errors in the database cannot be fixed. If you encounter any, you will need to either reinitialize the database or restore from a known good backup.

Actions

This Discussion