ODBC Server Installation and Management Manual

Managing NonStop ODBC Server Resources
HP NonStop ODBC Server Installation and Management Manual—429395-002
5-18
Query Status Records
The table entries and their meanings are as follows:
Timing of Query Status Records
A query status record is written to the ZNUQST table when a statement is executed.
This status is logged if the user profile is configured to log all statements or if there is a
governing policy configured to log statements of a particular cost range. If for any
reason a status record cannot be written, a warning message is sent to EMS $0 log
and also to the user; execution of the query continues, however.
CLIENT_ID A unique identifier, such as an IP address, to identify a
client
SESSION_ID A unique identifier associated with a session; same as
SESSION_ID in ZNUMTRX
LOGON_USERNAME Client logon name
G_USERNAME Guardian user name
PROFILE_NAME User profile name
SER_NAME Server class name
NODE_NAME Node name
CPU_PIN CPU and PIN for the NonStop ODBC Server
START_PRIORITY NonStop ODBC Server’s original priority
CURRENT_PRIORITY Priority at which the query is running
TRANSACTION_ID TMF transaction ID; absence of a transaction ID means
no active transaction is associated with this statement
STMT_TYPE Indicates the type of the statement by using same codes
as in ZNUMTRX table
ESTIMATED_COST Estimated cost for this statement
STMT_TEXT Partial statement text, up to 500 bytes