ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-75
Resource Governing Statements
Resource Governing Statements
Use the following statements to configure and manage resource governing policy
entities that control various aspects of SQL statement execution:
•
ADD GOVERNING
•
MODIFY GOVERNING
•
REMOVE GOVERNING
ADD GOVERNING
The ADD GOVERNING statement creates a new governing policy entity or adds one
or more attribute-value pairs to an existing entity. To execute ADD GOVERNING, you
must be a privileged user.
gov-name
specifies the name of the governing policy entity; gov-name is an alphanumeric
string up to 60 characters in length that must begin with an alphabetic character
and can be followed by alphabetic, numeric, and underscore characters.
If gov-name does not already exist, the ADD GOVERNING statement creates a
new governing policy entity. If gov-name already exists in the ZNSGOV table, the
ADD GOVERNING statement appends the new attribute-value pair or pairs you
specify to the existing governing policy entity.
If any limit is reached, the NonStop ODBC Server takes the gov-action you
specify for that gov-attribute and limit-value.
ADD GOVERNING gov-name
GOV_ATTRIBUTE gov-attribute
LIMIT_VALUE limit-value
GOV_ACTION gov-action
[ LOG_QST_ON { N | Y } ]
[ UPDATE_SYSTEM_CONFIG ]