CHECK CATALOGS

>>-CHECK CATALOGS--+---------------+--+-------------------+----><
                   '-database_name-'  +-DISPLAY-----------+
                                      '-SAVE IN--filename-'

Element	Purpose	Restrictions	Syntax
database_name	The name of the database where the system catalog tables reside	The database must exist. You cannot check databases on remote database servers.	See Database Name in the IBM Informix: Guide to SQL Syntax.
DISPLAY	Optional keyword which displays formatted output of the system catalog being checked	None
SAVE IN	Optional keyword which saves the formatted output of the system catalogs being checked to an external file	None
filename	The relative or absolute path and name of the file where the formatted output is stored	None	Use the operating-system rules for the filename.

Use the onutil CHECK CATALOGS command to check the internal integrity of that system catalog tables of a database.

For example, you can check the system catalog tables of a database with this onutil command:

% onutil
1> CHECK CATALOGS sysmaster;
2> CHECK CATALOGS;

CHECK CATALOGS

Syntax

Usage