ODBC Server Installation and Management Manual

Managing NonStop ODBC Server Resources
HP NonStop ODBC Server Installation and Management Manual—429395-002
5-14
Defining Policies
User Profile
Three entries in the user profile associate a user with a resource governing policy. The
relevant user profile attributes and their meanings are as follows:
Governing Policies
The following describes the attributes associated with governing policies:
GOV_MODE_ON Specifies whether governing policy is in effect.
GOV_NAME Name of the governing policy that controls the query execution
(if GOV_MODE_ON is Y (yes)).
QST_LOG_ON Specifies whether to log all statements. If GOV_MODE_ON is
not Y, no status is generated.
GOV_NAME Name of the governing policy that controls a query execution.
GOV_LEVEL Specifies whether governing is done on a per-statement basis
or a per-session basis. In this version of the NonStop ODBC
Server, all governing is done on a per-SQL-statement basis.
GOV_ATTRIBUTE Attribute to which a governing action can be applied or one of
the following:
ELAPSED_TIME
EXECUTION_TIME
ROWS_ACCESSED
ROWS_USED
ESTIMATED_COST
LIMIT_VALUE Threshold (lower bound) to be used to limit the amount of
resources used for a query.