ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-27
Maintaining Catalogs
Maintaining Catalogs
The following statements are used to maintain catalogs:
•
SYSCAT REFRESH—ensures that objects in the system catalog and
corresponding entries in the mapping tables balance.
•
USERCAT REFRESH—ensures that objects in user catalogs and corresponding
entries in the mapping tables balance.
•
SYSCAT VALIDATE—reports inconsistencies in references between the system
catalog and the mapping tables.
•
USERCAT VALIDATE—reports inconsistencies in references between the
specified user catalog and the mapping tables.
•
CLEANUP—drops temporary objects from catalogs.
•
SYSCAT UPGRADE—upgrades the system catalog to the current version.
•
USERCAT UPGRADE—upgrades a user catalog to the current version.
SYSCAT REFRESH Statement
Use the SYSCAT REFRESH statement to add objects registered in the system catalog
to the configuration tables, system mapping tables, and user mapping tables. When
you run SYSCAT REFRESH, all objects registered in the system catalog that are not
mapped become mapped and therefore are available through the NonStop ODBC
Server.
You must run SYSCAT REFRESH if objects registered in the catalog are not listed in
the mapping tables. An object does not appear in the mapping tables if any of the
following are true:
•
You create the object in pass-through mode.
•
You create the object using NonStop SQL/MP when the catalog is already
customized.
•
You delete a row from the NonStop ODBC Server mapping table ZNUOBJ.
You must be a privileged user to use SYSCAT REFRESH.
SYSCAT REFRESH has the following syntax:
output-filename
specifies the NonStop SQL/MP table name of the log table where command
response messages are written. The log table is an unaudited, entry sequenced
table that NOSUTIL creates in the NonStop ODBC master catalog subvolume.
NOSUTIL also registers the log table in the NonStop ODBC master catalog and
SYSCAT REFRESH [ LOG output-filename ]