Verifying the system catalog

This topic includes the following sections:

 

If you've made changes to a system catalog, you may want to verify that the system catalog tables still match the definitions in the repository and the database.

Comparing the system catalog to repository definitions

You can create a verification log that lists table names, file names, the number of columns read and defined for each table, and the number of indexes read for each table. You can create this file from the DBA program or from the command line.

Using DBA to create a verification log

1. Open the system catalog in DBA. Close any open lists or input windows.
2. Select Catalog > Verify.

The Verify System Catalog window opens and prompts you for a name and location.

3. Accept the default or enter a new location and name. Then select OK.

A message displays telling you how many tables were verified and how many errors were found. (But be sure to read the log file for more complete information.)

4. Select OK.

Creating a verification log from the command line

To create a verification log from the command line, use the following syntax at a Windows or UNIX prompt:

dbr SODBC_DBA:xfdba.dbr -c connect_string -v verify_file

or use the following syntax at an OpenVMS prompt:

$ XFDBA -C connect_string -V verify_file

where connect_string has the user_name/password/connect_filename format and verify_file is the full path and filename for the verification log.

The following examples generate a verification log named vrfy.log in a directory named data.

Windows:

dbr SODBC_DBA:xfdba.dbr -c DBADMIN/MANAGER/sodbc_sa -g c:\data\vrfy.log

UNIX:

dbr SODBC_DBA:xfdba.dbr -c DBADMIN/MANAGER/sodbc_sa -g /usr/data/vrfy.log

OpenVMS:

$ XFDBA -C DBADMIN/MANAGER/SODBC_SA -G DKA600:[DATA]VRFY.LOG

For information on DBA command-line options, see Command line options.

Comparing the system catalog to a database

If your system catalog supports level-based users, you can use the DBA program or fcompare to compare the tables in the system catalog to the data definitions in a database. For information on comparing from the command line, see fcompare. (For information on level-based users, see xfODBC security: managing access.)

Using DBA to compare the system catalog to a database

1. Open the system catalog in DBA. Close any open lists or input windows.
2. Select Catalog > Compare to Files.

The Compare System Catalog to Files window opens.

3. Fill in or select from the following:

Connect file

Enter a connect file name or accept the default. The connect file determines which database and system catalog will be compared.

Option

Select All to compare all tables in the system catalog to the database. Select Specific to compare one system catalog table to the database.

Table name

If you selected the Specific option for the Option field, enter the name of the table you want compared to the database. This is available only if Specific is selected for the Option field.

Verify data

Select this option to verify data in the ISAM files. (Data definitions are compared regardless of this setting, but data is verified only if this option is selected.) This option is available only if Specific is selected for the Option field.

Log file

Enter the path and name for the log file. The log file will contain the results of the comparison.

Verbose logging

Select this option if you want to generate additional (verbose) output information.

4. Click OK.