ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-22
Installation Steps
•
After you have run NOSINST, check that the following NonStop ODBC Server
system catalog tables (SQL/MP tables and views) now exist on SQL-System-
Catalog. All are registered in the SQL/MP system catalog.
The names of all the NonStop ODBC Server catalog objects begin with the
following letters:
All objects in a user catalog also exist in the system catalog.
If you have access to SQLCI, you can check all tables and views in the NonStop
ODBC Server system catalog by running the following query:
>> SELECT TABLENAME,TABLETYPE,CONVERTTIMESTAMP(CREATETIME)
+> FROM SQL-System-Catalog.TABLES
+> WHERE TABLENAME LIKE "%.ZN%" OR
+> TABLENAME LIKE "%.ZV%";
You can check all the indexes in the NonStop ODBC Server system catalog by
running the following query:
>>SELECT INDEXNAME,CONVERTTIMESTAMP(CREATETIME)
+>FROM $SYSTEM.SQL.INDEXES
+>WHERE INDEXNAME LIKE "%.ZN%"
+> AND TABLENAME <> INDEXNAME;
Shown following is a sample output of the SQL/MP SELECT statement on TABLES
listing all the tables and views in the NonStop ODBC Server system catalog (see
“NonStop ODBC Server Mapping Tables,” in the NonStop ODBC Server Reference
Manual for definitions of the objects and their use).
TABLENAME TABLETYPE (EXPR)
--------------------------------- --------- --------------------------
\TESS.$SYSTEM.SQL.ZNSALT TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSCON TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSDB TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSDEF TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSDUMMY TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSGOV TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSMSG TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSNET TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSPROF TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSPROT TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSSCFG TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSSCS TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSSER TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSSMAP TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSTRA TA 1996-10-01:11:01:01.123456
ZNS NonStop ODBC Server tables and indexes in the NonStop ODBC
Server system catalog
ZNU NonStop ODBC Server tables and indexes in NonStop ODBC Server
user catalogs
ZVS NonStop ODBC Server views in the NonStop ODBC Server system
catalog
ZVU NonStop ODBC Server views in NonStop ODBC Server user catalogs