ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-68
PROFILE Statements
ACC_MODE_ON { Y | N }
specifies whether to include query accounting in this profile:
ACC_LOGTABLE_NAME acc-name
specifies the name of the existing accounting log table to use for this profile;
acc-name is an alphanumeric string up to 182 characters in length in the following
format:
database.owner.ZNUMTRX
See CREATE ACC_LOG on page 7-40 for information about creating a new
accounting log table.
The NonStop ODBC Server uses the accounting log table you specify only if you
also specify Y for ACC_MODE_ON. When ACC_MODE_ON is set to Y, if
acc-name is either invalid or NULL, the resource governing environment is not
initialized and governing is not enforced.
ACC_LEVEL { SESSION | SQL_STATEMENT }
specifies the level of detail for accounting log table entries:
GOV_MODE_ON { Y | N }
specifies whether to use an existing governing policy entity for this profile:
GOV_NAME gov-name
specifies the name of the existing governing policy entity to include in this profile;
gov-name is an alphanumeric string up to 60 characters in length. It must begin
with an alphabetic character, followed by alphabetic, numeric, and underscore
characters.
If the governing policy entity you specify for gov-name does not already exist,
governing features are not enabled for this profile. See ADD GOVERNING on
page 7-75 to learn how to create a new governing policy entity.
The NonStop ODBC Server uses the governing policy entity you specify only if you
also specify Y for the GOV_MODE_ON keyword.
Y Perform accounting and use the existing accounting log table you specify
in acc-name.
N Do not perform accounting for this profile.
SESSION A single log table entry, created when the connection
terminates, represents all activity during that session.
SQL_STATEMENT Each executed SQL statement has a corresponding entry in
the accounting log table.
Y Use the governing policy entity you specify in gov-name.
N Do not use a governing policy entity for this profile.