ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-23
Installation Steps
\TESS.$SYSTEM.SQL.ZNSUMAP TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSUS TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNSVALUE TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNUDT TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNUIX TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNUOBJ TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNUPCOL TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZNUPROC TA 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZVSDB VI 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZVSMSG VI 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZVUCOL VI 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZVUDT VI 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZVUIX VI 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZVUOBJ VI 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZVUOCOL VI 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZVUPCOL VI 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZVUPROT VI 1996-10-01:11:01:01.123456
\TESS.$SYSTEM.SQL.ZVUUS VI 1996-10-01:11:01:01.123456
Shown following is a sample output of the SELECT statement showing all the
indexes in the NonStop ODBC Server system catalog.
INDEXNAME (EXPR)
--------------------------------- --------------------------
\TESS.$SYSTEM.SQL.ZNSALTI1 1996-10-01:21:08:34.074567
\TESS.$SYSTEM.SQL.ZNSDBI1 1996-10-01:21:08:27.931886
\TESS.$SYSTEM.SQL.ZNSDBI2 1996-10-01:00:34:28.456680
\TESS.$SYSTEM.SQL.ZNSUSI1 1996-10-01:21:08:49.972288
\TESS.$SYSTEM.SQL.ZNSUSI2 1996-10-01:21:08:52.273462
\TESS.$SYSTEM.SQL.ZNUIXI1 1996-10-01:21:09:20.028462
\TESS.$SYSTEM.SQL.ZNUOBJI1 1996-10-01:21:08:59.787055
\TESS.$SYSTEM.SQL.ZNUOBJI2 1996-10-01:21:09:02.035261
\TESS.$SYSTEM.SQL.ZNUOBJI3 1996-10-01:21:09:07.657557
\TESS.$SYSTEM.SQL.ZNUPCLI1 1996-10-01:00:35:42.386361
•
As the final part of verification, run NOSCOM with the SYSCAT VALIDATE option
to check values in the rows of the catalog tables:
RUN NOS-Target-Disk.ZNOS.NOSCOM SYSCAT VALIDATE
At this point, the system catalog is customized, and at least one logical username,
“DBO” is created. DBO is configured to use the Guardian user name super ID, the
DEFAULT server class, and the DEFAULT profile. An additional alias exists if the
default administration configuration, “NSOADMIN,” was loaded. This configuration is
sufficient to bring up SCS and have a client connect. The Windows-based application
configuration tool installed subsequently is the recommended interface for completing
your configuration.
Because you install the NonStop ODBC Server while logged on as a super-group user,
the SQL/MP tables created for you are owned by that super-group user. The security of
the catalog tables is set to “NNNO” for the tables that can be updated and “NOOO” for
the tables that do not change.
When installation is complete, you might want to alter ownership and security settings
for some NonStop ODBC Server objects. You might also alter ownership and security
settings for SQL/MP objects that the NonStop ODBC Server uses, such as SQL/MP