ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-57
ZNUQST (For Query Status Data)
ZNUQST (For Query Status Data)
The table ZNUQST is the simple file name used for logging current activity. It is the log
table name in the ZNSPROF record of the current user profile.
The NonStop ODBC server process enters the values on this table.
The ZNUQST table is created as an unaudited table so that concurrency is maximized
among multiple users. Log entry rows only append 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.
ZNUQST resides in both the subvolume of the system catalog and a customized user
catalog.
Table 8-27. Description of ZNUQST (page 1 of 2)
Column Name
Primary Key Unique Index
Data Type Description
CLIENT_ID
––
VARCHAR (60) A unique identifier used to link this
accounting status entry to a client
session.
SESSION _ID
––
INT (4) A unique identifier generated by
the NonStop ODBC Server.
START_TIME
––
TIMESTAMP Time (in milliseconds) the query
started the current status.
LOGON_USERNAME
––
VARCHAR (60) Value provided in the logon record
by the user. It is used to determine
the current user session
environment settings.
G_USERNAME
––
CHAR (17) Guardian username determined
from the LOGON_USERNAME at
the start of the session.
PROFILE_NAME
––
VARCHAR (60) Profile name determined for the
current session.
SER_NAME
––
VARCHAR (32) Server class name for the current
session.
NODE_NAME
––
CHAR (8) Node name for reported statistic.
CPU_PIN
––
CHAR (7) CPU and program identification
numbers 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