ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-16
ZNSGOV (For Governing Policies)
ZNSGOV (For Governing Policies)
The table ZNSGOV describes resource usage limits and server actions that occur
when the limits are exceeded. The limits and actions are called governing profiles. For
information on using the ZNSGOV table to log query status, see the HP NonStop
ODBC Server Installation and Management Manual.
ZNSGOV resides only in the subvolume of the system catalog.
Table 8-9. Description of ZNSGOV (page 1 of 2)
Column Name
Primary Key Unique Index
Data Type Description
GOV_NAME
x–
VARCHAR (60) Unique governing profile name.
GOV_ATTRIBUTE
x–
VARCHAR (60) Process attribute for which the
governing policy applies (see
definitions following the table):
ELAPSED_TIME
ESTIMATED_COST
EXECUTION_TIME
ROWS_ACCESSED
ROWS_USED
LIMIT_VALUE
x–
INT (8) Threshold value that, if exceeded,
causes the governing action to
occur. Valid values are from 0 to
the maximum allowed for the
column’s data type.
x Indicates the column is part of the primary key or is a unique index
– Indicates the column is not part of the primary key or is not a unique index