ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-28
ZNSSCFG (For System Configuration Values)
ZNSSCFG (For System Configuration Values)
The table ZNSSCFG stores configuration values and bookkeeping data on changes
made to these values. ZNSSCFG stores only attribute settings defined by the ODBC
server (as opposed to ZNSDEF, which stores attribute settings defined by the NonStop
Kernel), When NOSUTIL installs the NonStop ODBC Server system catalogs, it loads
the system default configuration values into the ZNSSCFG table.
ZNSSCFG resides only in the subvolume of the system catalog.
The ZNSSCFG table stores three values that are not attribute default values:
•
LAST_UPDATE_SYSTEM_CONFIG,
•
CHECK_INTERVAL_SECONDS,
•
QST_LOGTABLE_NAME
LAST_UPDATE_SYSTEM_CONFIG represents the last time the administrator wanted
to make available changes to the system configuration as represented by rows in the
configuration tables. The administrator can cause this value to be automatically
updated by indicating UPDATE_SYSTEM_CONFIG when performing ADD, MODIFY,
or REMOVE statements against the configuration entities, or more explicitly by using
MODIFY on ZNSSCFG to change the LAST_UPDATE_SYSTEM_CONFIG item.
Whenever a row is added to any of these tables or whenever a change in any column
in these tables occurs, these actions are reflected in the ZNSSCFG table as follows:
•
The column name is stored in the ITEM column.
•
The new value is stored in the VALUE column.
•
The LAST_UPDATED column is updated with the date and time of the update or
the addition.
Note that each value in ZNSSCFG is stored in ASCII format. When a value is read
from ZNSSCFG to be used as a default, it is first converted to the target data type.
Values in ZNSSCFG are used only when creating an entity (ADD or CREATE) or when
starting system processes (START SCS).
The database administrator can change the values on the ZNSSCFG table by using
the ADD, MODIFY, or REMOVE statement at any time, without bringing the system
down. The changes affect the default values throughout the system. If you change a
value on the ZNSSCFG table, be aware that changes to the ZNSSCFG table values
are not propagated to the other mapping tables.
Using the SET statement, you can override values in the ZNSSCFG table for the
duration of a session. The SCS, NOS, and NOSUTIL programs use the new default
values. When the session ends, the default values revert to the values in ZNSSCFG.