Previous Topic

Next Topic

Updating Catalog Information Using verifydb

The verifydb command is an Ingres utility to provide database management, supportability, and disaster recovery services.

This section discusses the use of the refresh_ldbs operation of verifydb to notify Ingres Star of remote database upgrades to which a distributed database already has registered objects. For a full explanation of verifydb and all its flags, see the Command Reference Guide.

The refresh_ldbs operation of verifydb allows you to update distributed database Ingres Star catalog information dealing with the version level of remote non-distributed databases that are upgraded after the remote non-distributed databases have been registered with the distributed database. You want the remote non-distributed database to reflect its latest upgrade version so that Ingres Star will accept all upgraded features available to the remote non-distributed database.

The refresh operation is performed by specifying the verifydb command with the -orefresh_ldbs parameter. This operation reads the standard catalogs of each remote database processed and makes sure that the Ingres Star catalog correctly reflects the iidbcapabilities levels of the various remote non-distributed databases that contain objects registered to the distributed database. It does so without changing the contents or semantics of the standard catalog interface.

It is recommended that you run this operation on a distributed database after you run upgradedb on any of the remote databases accessed by the distributed database. For details on running upgradedb, see the appendix "Release Compatibility."

Previous Topic

Next Topic

Examples: verifydb

Run verifydb with the refresh_ldbs option on the mystar database to check whether or not the iiddb_ldb_dbcaps catalog correctly reflects the level of its registered databases. Log output is to the default verify log file.

verifydb -mreport -sdbname mystar -orefresh_ldbs

Run verifydb with the refresh_ldbs option on the mystar database, correcting any iiddb_ldb_dbcaps catalog entries that incorrectly reflect the level of its registered databases. Log output is to the alternate refreshldb.log log file.

verifydb -mrun -sdbname mystar -orefresh_ldbs -lfrefreshdb.log

Run verifydb with the refresh_ldbs option on all databases that you own, correcting any iiddb_ldb_dbcaps catalog entries that incorrectly reflect the level of its registered databases. Log output is to the alternate refreshldb.log log file.

verifydb -mrun -sdba -orefresh_ldbs -lfrefreshdb.log

Run verifydb with the refresh_ldbs option on all databases that user sue owns, correcting any iiddb_ldb_dbcaps catalog entries that incorrectly reflect the level of its registered databases. Log output is to the default verify log file.

verifydb -mrun -sdba -orefresh_ldbs -usue


© 2007 Ingres Corporation. All rights reserved.