ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-79
Resource Governing Statements
For a description of the MODIFY GOVERNING statement parameters, see ADD
GOVERNING on page 7-75.
Considerations – MODIFY GOVERNING
The MODIFY GOVERNING statement:
•
Modifies the corresponding entry in the ZNSGOV system table
•
Generates an error if gov-name is not a valid NonStop ODBC Server governing
policy entity
•
Generates an error if you are not a privileged user
Example
The following example shows how to use MODIFY GOVERNING to change
limit-value from 90 to 100 minutes for the gov-attribute EXECUTION_TIME
and gov-action COMMIT in the existing governing policy entity q3:
MODIFY GOVERNING q3 GOV_ATTRIBUTE EXECUTION_TIME &
LIMIT_VALUE 100 GOV_ACTION COMMIT
REMOVE GOVERNING
The REMOVE GOVERNING statement removes one or more existing governing policy
entities or a single attribute-value pair in an existing governing policy entity. To execute
REMOVE GOVERNING, you must be a privileged user.
gov-name
is an alphanumeric string up to 60 characters in length that specifies the name of
the governing policy entity. If you specify only gov-name, all governing policy
entities with this name are removed.
GOV_ATTRIBUTE gov-attribute
specifies one of the following aspects of query execution: ELAPSED_TIME,
ESTIMATED_COST, ROWS_ACCESSED, ROWS_USED, and
EXECUTION_TIME. For a description of these parameters, see the ADD
GOVERNING statement.
LIMIT_VALUE limit-value
specifies the value for the attribute-value pair you want to remove.
REMOVE GOVERNING gov-name
[ GOV_ATTRIBUTE gov-attribute ]
[ LIMIT_VALUE limit-value ]
[ UPDATE_SYSTEM_CONFIG ]