ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-50
ZNUMTRX (For Resource Accounting Log Data)
MESSAGES
––
INT (8) Number of messages sent for this
OPEN, including the OPEN
message.
MESSAGE_BYTES
––
INT (8) Number of message bytes sent
and received for this file OPEN.
LOCK_WAITS
––
INT (8) Number of times the executor
waited for a lock request to
complete.
LOCK_
ESCALATIONS
––
INT (8) Number of times a lock was
escalated to a file-level lock.
LAST_GOV_
ATTRIBUTE
––
VARCHAR (60) Indicator that describes whether
this entry was generated when a
governing action was triggered or
by a change of statement status.
An empty string indicates it was
by a change of statement status. If
not empty, the column contains
the reason an accounting record
is created.
LAST_LIMIT_VALUE
––
INT (8) Limit value at accounting entry
time.
LAST_GOV_ACTION
––
VARCHAR (60) Action taken when the limit of the
governing attribute was exceeded.
STMT_TEXT
––
VARCHAR (3000) The SQL statement as prepared.
Table 8-23. Description of ZNUMTRX (page 6 of 6)
Column Name
Primary Key Unique Index
Data Type Description
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