ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-28
SYSCAT REFRESH Statement
creates a mapping entry. If a table with the same name as output-filename
already exists, NOSUTIL returns an error and the SYSCAT REFRESH statement
terminates.
Example
The following statement refreshes the NonStop SQL/MP system catalog:
syscat refresh
Use this statement to verify that all objects registered in the system catalog are listed in
the mapping tables. Objects not listed are added to the mapping tables. For example, if
the ZNUOBJ table is missing, SYSCAT REFRESH re-creates it and repopulates it.
Effects of SYSCAT REFRESH
SYSCAT REFRESH checks whether each table, view, and index in the system catalog
has an entry in the mapping tables. If the object is not entered in the mapping tables,
SYSCAT REFRESH enters it.
If a mapping entry references a nonexistent NonStop SQL/MP object, SYSCAT
REFRESH deletes the entry.
If a mapping table is not found, SYSCAT REFRESH re-creates it and resupplies it with
values. SYSCAT REFRESH can re-create all system tables except ZNSDB and
ZNSUS. If ZNSDB is dropped, you must either restore it from a backup image of the
NonStop SQL/MP system catalog or else purge all Zzzzzs tables and views and then
execute SYSCAT INSTALL. If ZNSUS is dropped, you must also either drop ZNSALT
or remove the DBO entry from ZNSALT and then execute SYSCAT REFRESH again.
SYSCAT REFRESH also does the following:
•
Deletes references in ZNSDB to any database without a NonStop SQL/MP system
catalog.
•
Deletes and reloads all values in the static mapping table ZNUDT.
•
Re-creates mapping entries in ZNUOBJ for objects found in the NonStop SQL/MP
INDEXES, TABLES, and VIEWS catalog tables that are missing from the NonStop
ODBC Server mapping tables.
•
Adds a username mapping entry in ZNSUS for each owner of an object in the
system catalog that is not already a mapped username.
•
Deletes mapping entries in ZNOBJ for objects listed in either ZNOBJ or ZNUIX, but
not found in NonStop SQL/MP catalog tables.
•
Generates an error if you are not a privileged user.
•
Generates an error if the system catalog is not customized for the NonStop ODBC
Server.