ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-77
Resource Governing Statements
GOV_ACTION gov-action
specifies the action you want the NonStop ODBC Server to take when a query
exceeds the limit-value. gov-action can be only one of the following:
LOG_QST_ON { Y | N }
indicates whether to log the query status for each statement executed:
UPDATE_SYSTEM_CONFIG
resets the time to update system configuration values to the current time. This
option causes running system components to reread their configuration values on
the next polling cycle.
Considerations – ADD GOVERNING
The ADD GOVERNING statement:
•
Creates a new entry for the governing policy entity in the ZNSGOV system table or
adds the new set of attribute value-pairs to an existing entity
•
Generates an error if you are not a privileged user
After you add a governing policy, you must also set the GOV_MODE_ON and
GOV_NAME options using the ADD PROFILE or MODIFY PROFILE statement to
update the respective profile to enable resource governing for the policy. For more
information about these options, see ADD PROFILE on page 7-66.
COMMIT Stop and commit the transaction.
CONTINUE Continue without any changes.
PRIORITY Change the query priority as follows:
"PRIORITY ++n" raises the priority by n
"PRIORITY --n" lowers the priority by n
"PRIORITY n" changes the priority to n
To specify a value for PRIORITY that includes blank spaces,
enclose both the keyword and value in quotation marks.
ROLLBACK Stop and roll back the transaction.
STOP Return an error indicating the statement cannot be executed
due to policies on exceeding resources (applies only to the
ESTIMATED_COST option).
Y Log the query status.
N Do not log the query status. N is the default.