ODBC Server Installation and Management Manual

Managing NonStop ODBC Server Resources
HP NonStop ODBC Server Installation and Management Manual—429395-002
5-5
Resource Accounting Log Table
STMT_TYPE Type of statement being processed, as follows:
S SELECT statement
D DELETE statement
U UPDATE statement
I INSERT statement
L DDL statement
C Control statements
O Others
STMT_STATUS Status of statement execution, as follows:
C Statement execution completed
P Statement prepared
X Statement canceled by user
Q Statement encountered a SQL/MP
error
STMT_ORIGIN Indicates whether the statement was issued by
the client, as follows:
C Statement issued by the client
I Statement was generated internally by the
NonStop ODBC Server
ESTIMATED_COST Estimated cost for the statement, returned by the
SQL/MP optimizer.
STMT_CACHED Indicates whether the statement is being cached,
as follows:
N Not cached
YCached
R Cache is being used (cache hit)
RECORDS_ACCESSED Number of records accessed (SQL/MP).
RECORDS_USED Number of records returned or altered
(NonStop SQL/MP).
DISK_READS Number of disk reads and writes
(NonStop SQL/MP).
MESSAGES Number of messages sent to the disk process
(SQL/MP).
MESSAGE_BYTES Number of bytes in all messages sent to the disk
process.
LOCK_WAITS Number of times the executor waited for a lock
request to finish (SQL/MP).
LOCK_ESCALATIONS Number of times a record lock was escalated to a
file lock.