ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-17
ZNSGOV (For Governing Policies)
The following are descriptions of the valid values for GOV_ATTRIBUTE:
The following are descriptions of the valid values for GOV_ACTION:
GOV_ACTION
––
VARCHAR (60) Action to be taken if the process
attribute exceeds the threshold
value (see definitions following
table):
COMMIT
CONTINUE
PRIORITY [ ++ | -- ] n
ROLLBACK
STOP
LOG_QST_ON
––
CHAR (1) Flag indicating whether governing
actions are logged. (Can be
overridden by the value in the
QST_MODE_ON column in the
ZNSPROF table.)
LAST_UPDATED
––
DATETIME YEAR
TO FRACTION (6)
Date and time this row was added
or last modified.
Value Description
ELAPSED_TIME Wall clock time from the beginning to the end of the query
ESTIMATED_COST Estimated cost for the query execution
EXECUTION_TIME CPU usage time for this query
ROWS_ACCESSED Number of rows accessed for this query
ROWS_USED Number of rows fetched for this query
Value Description
COMMIT The query is committed.
CONTINUE The query continues as if nothing happened.
PRIORITY [ ++ | -- ] n The priority of the query is increased or decreased by n., or set to
n
ROLLBACK The query is stopped, all resources associated with the statement
are released, and the query is rolled back.
STOP The query is stopped.
Table 8-9. Description of ZNSGOV (page 2 of 2)
Column Name
Primary Key Unique Index
Data Type Description
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