ODBC Server Installation and Management Manual

Managing NonStop ODBC Server Resources
HP NonStop ODBC Server Installation and Management Manual—429395-002
5-2
The Resource Accounting Facility
Another customer might like to be able to have the system set the priority based on the
estimated query cost and to adjust this as needed at run time if the query exceeds a
certain cost.
Many customers might want to be able to stop queries that exceed user-specified
thresholds (for example, CPU time or number of rows fetched) and to have an explicit
interface to stop a given query.
The solution is to implement a resource governing facility in the NonStop ODBC Server
product to monitor and govern the SQL statement execution based on a predefined
policy.
Previously, two functions were available in the NonStop ODBC Server to govern SQL
statements:
•
The ability to define a statement cost limit for a DML statement and prevent
executing of this statement if it exceeds the cost predicted by the SQL/MP
optimizer
•
The ability to define the maximum number of rows to be returned to the client for a
SELECT statement
The resource governing facility adds to those functions the following capabilities:
•
The ability to set priorities for resources
•
The ability to limit I/O resources for a single query
•
The ability to limit the amount of time spent on a single query
•
The ability to display query status
The Resource Accounting Facility
The configuration that enables resource accounting is defined in the user profile table,
ZNSPROF. Resource accounting data is recorded in the ZNUMTRX table. The
configuration data consists of the Resource Accounting Profile and the Resource
Accounting Log Table. Attributes are defined following: