ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-4
Default Values for NonStop ODBC Server Attributes
Default Values for NonStop ODBC Server Attributes
Each column in the master and user catalog tables is an attribute that has a single
definition. That is, a column that appears in more than one table has the same format,
referential integrity, and range of possible values in each table.
Default values for attributes are dynamic and are stored in the ZNSSCFG (System
Configuration) table. These values are set or accessed at four times:
•
During system installation
•
When the system requires a change to a default
•
When a NOS (the NonStop ODBC Server object program), NOSUTIL, or SCS
process begins
•
During session initialization
During System Installation
At system installation, the NOSUTIL utility process creates all tables and sets the initial
default values. This process adds one row to the ZNSSCFG table for every column or
named attribute that it tracks. See Appendix D, Summary of System Installation
Defaults, for a list of system configuration default attributes stored in the ZNSSCFG
table at installation time.
When the System Requires a Change
As a privileged user, you can change the default values at any time, without taking the
system down. This feature allows you to customize the default values when and as
your system requirements change. The result can be improved performance. For
example, if the system is using too many processors, all at high priorities, you can limit
the number of processors and reduce the priorities.
Table 8-2. Naming Conventions for the Mapping Table Columns
Prefix Column Value
ACC_ Relates to the resource accounting description.
G_ Relates to the HP NonStop Kernel operating system.
GOV_ Relates to the resource governing description.
N_ Relates to NonStop SQL/MP.
NOS_ Relates to the NonStop ODBC Server.
SCS_ Relates to or references an SQL Communication Subsystem (SCS) process.
SER_ Relates to or references a server class specification that is the NOS process
configured with a specific set of process and environment attributes.
SQL_ Relates to the SQL environment of a running process.
T_ Relates to ODBC or SQL Server.