ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-45
ZNUMTRX (For Resource Accounting Log Data)
ZNUMTRX (For Resource Accounting Log Data)
The ZNUMTRX table is the default simple file name used as the log for resource
accounting. It is the log table name ACC_LOGTABLE_NAME found in the ZNSPROF
record, pointed to by the current user profile. When creating the resource accounting
log, you can specify any other simple file name, however the definition of the table is
fixed.
ZNUMTRX resides in both the subvolume of the system catalog and a customized user
catalog.
The NOS process enters all values into this table.
The ZNUMTRX table is created as an unaudited table so that concurrency among
multiple users is maximized. A log entry row only appends to the table during the time
the log is active. For information on activating the log, see the HP NonStop ODBC
Server Installation and Management Manual.
The result sets referred to in some of the descriptions in the ZNUMTRX table are the
output that results from execution of a SELECT statement.
Table 8-23. Description of ZNUMTRX (page 1 of 6)
Column Name
Primary Key Unique Index
Data Type Description
CLIENT_ID
––
VARCHAR (60) A unique identifier that links this
accounting log sequence to a
client session.
SESSION_ID
––
INT (8) UNSIGNED A unique identifier that associates
log entries within an accounting
activity.
START_TIME
––
TIMESTAMP Time the accounting activity
started (milliseconds).
END_TIME
––
TIMESTAMP Time the accounting activity
stopped (milliseconds).
LOGON_USERNAME
––
VARCHAR (60) Username provided by the user,
stored in the login record; used to
determine the environment
settings for the current session.
x Indicates the column is part of the primary key or is a unique index
– Indicates the column is not part of the primary key or is not a unique index