ODBC Server Installation and Management Manual

Managing NonStop ODBC Server Resources
HP NonStop ODBC Server Installation and Management Manual—429395-002
5-3
Resource Accounting Profile
Resource Accounting Profile
The resource accounting profile is defined in the following three attributes of the user
profile table:
Resource Accounting Log Table
Resource data is recorded in the resource accounting log table specified by the
ACC_LOGTABLE_NAME entry in the user profile. The following describes the columns
in an accounting log table and their meanings:
ACC_MOD_ON Turns resource accounting on or off.
Y Accounting is on for this user
N Accounting is off for this user (default).
ACC_LOGTABLE_NAME A name of the form database.owner.ZNUMTRX. The
accounting log table is created using the CREATE
ACC_LOG statement.
ACC_LEVEL Specifies whether data is to be recorded on a per-
session or per-statement basis:
SESSION Data is recorded for one
session.
SQL_STATEMENT Data is recorded for each
statement.
CLIENT_ID A unique identifier, such as an IP address, to
identify the client connection.
SESSION_ID A unique identifier for this user session.
START_TIME Julian timestamp when statement execution
began.
END_TIME Julian timestamp when statement execution
ended.
LOGON_USERNAME Client logon name—can be a username or alias.
APPLICATION Application ID, used to determine session
environment.
G_USERNAME Guardian group and user name.
PROFILE_NAME User profile used for this session.
SER_NAME Server class name for this session.
NODE_NAME Node name in which the NonStop ODBC Server
is running.
CPU_PIN Process ID for the NonStop ODBC Server.