checksyscat - utility to check if the system catalog is structurally consistent ------------------------------------------------------------------------------- Revision: 2012-05-23 usage: checksyscat [options] [database] options: -help - show usage (this list) -c cfg - server configuration file -b size - Buffer cache size (MB) -v - verbose output -t catid - check specified catalog table The checksyscat utility provides diagnostics on the structural consistency of the database server global system catalog or a database catalog. Usage instructions: 1) Download the checksyscat archive according to your platform. On Windows, the contained checksyscat executable must be unpacked into the Eloquence B.08.20 bin directory, otherwise it will not work. On HP-UX or Linux, unpack the contained checksyscat executable into a directory of your choice. You could, for example, unpack it into the Eloquence bin directory to integrate it into your Eloquence environment. 2) Invoke checksyscat on the global system catalog or a database catalog. /path/to/checksyscat Or: /path/to/checksyscat DATABASE The global system catalog of the database server is checked if no database is specified. To check a database catalog a database must be specified. This proforms the check on the default database server instance. To check another instance you are required to specify the database server configuration file with the -c command line option, such as: /path/to/checksyscat -c /path/to/eloqdb.cfg /path/to/checksyscat -c /path/to/eloqdb.cfg DATABASE If you invoke checksyscat this way, all tables in the catalog are checked and only errors are output. If the catalog is ok, there is nothing output. In case you want progress information (about which catalog tables are processed) specify the -v command line option, such as: /path/to/checksyscat -v /path/to/checksyscat DATABASE /path/to/checksyscat -v -c /path/to/eloqdb.cfg /path/to/checksyscat -v -c /path/to/eloqdb.cfg DATABASE The -t command line option may be used to check a specific catalog table. For example, to check the global sysobjects table (table id #20): /path/to/checksyscat -t20 Please note that in case the database server is active, checksyscat requires that the database server is in on-line backup mode. This is because it directly accesses the database server data volume files, which must not change while checksyscat is processing. The on-line backup mode makes sure that the data volumes do not change. To put the database server into on-line backup mode, a sequence like below may be used: /opt/eloquence6/bin/dbctl -u dba backup start ... invoke the checksyscat utility ... /opt/eloquence6/bin/dbctl -u dba backup stop 3) In case you find any errors and you want to create a log file, please invoke checksyscat as below: /path/to/checksyscat -v | tee checksyscat.log This copies the checksyscat output to the "checksyscat.log" file in the current directory. 4) To check all database catalogs in a database server instance, use a shell script like below on HP-UX or Linux: dbdumpcat -nt31 | cut -d' ' -f2 | while read db ; do /path/to/checksyscat $db | tee $db.checksyscat.log done This creates a "DATABASE.checksyscat.log" file for each DATABASE in the addressed database server environment. Please note that if you have multiple database server instances, dbdumpcat must address the correct instance (possibly using the -h command line option or using the EQ_DBSERVER environment variable) and checksyscat must address the corresponding eloqdb6.cfg file (possibly using the -c command line option). If you have questions or feedback, please contact: support@marxmeier.com Your Eloquence team at Marxmeier Software AG