ODBC Server Installation and Management Manual

Managing NonStop ODBC Server Resources
HP NonStop ODBC Server Installation and Management Manual—429395-002
5-7
Collecting Resource Accounting Data
The following is an example of two rows from an accounting log table, the first
recorded on a per-statement basis and the second recorded on a per-session basis:
CLIENT_ID SESSION_ID START_TIME END_TIME
LOGON_USERNAME APPLICATION G_USERNAME PROFILE_NAME
USER_NAME NODE_NAME CPU_PIN START_PRIORITY
ACC_LEVEL IN_MESSAGES IN_MESSAGE_B OUT_MESSAGES
OUT-MESSAGE_B SCS_EXECUTION_TIME NSODBC_EXECUTION_TIME NSSQL_EXECUTION_TIME
NSODBC_ELAPSED_TIME NSSQL_ELAPSED_TIME STMT_TYPE STMT_STATUS
STMT_ORIGIN ESTIMATED_COST STMT_CACHED RECORDS_ACCESSED
RECORDS_USED DISC_READS MESSAGES MESSAGE_BYTES
LOCK_WAITS LOCK_ESCALATIONS LAST_GOV_ATTRIBUTE LAST_LIMIT_VALUE
LAST_GOV_ACTION STMT_TEXT
130.252.135.92 47 21665866216443676 21665866234013070
codbc MSACCESS SQL.ODBC coreprof
class2 \TESS 007,180 155
SQL_STATEMENT 1 27 3
505 0 44724 16271
686406 159398 S C
U2Y 9
944 708
00
SELECT ALL * FROM \TESS.$SQL.NTDB.TP2 FOR STABLE ACCESS
130.252.135.92 48 21665866181258587 21665866257208422
codbc MSACCESS SQL.ODBC coreprof
class2 \TESS 007,180 155
SESSION 5 621 7
810 0 59508 49511
1135178 299412 135 25
13 11 3904 0
0
Collecting Resource Accounting Data
If resource accounting is on, collection of metrics begins when the client connects to
the NonStop ODBC Server. All subsequent compilation and execution of SQL
statements is recorded.
If the recording is on a per-statement basis, every statement is recorded; at the end of
the user session, a summarized set of statistics is recorded as the session metrics.
If the recording is on a per-session basis, only the summarized session metrics are
recorded.
The complete metrics include the process time of the NonStop ODBC Server, the
process time in SQL/MP, the I/O cost (run-time statistics) from SQL/MP execution, and
the number of messages and message bytes between SCS and the NonStop ODBC
Server, as follows:
•
NonStop ODBC Server process time includes the following:
•
NonStop ODBC parses and translates a SQL statement.
•
It reads the NonStop ODBC catalog to map the logical table name.
•
NonStop ODBC issues a PREPARE statement to invoke SQLCOMP to compile
the query. The estimated cost and compiled time are collected separately.
•
NonStop ODBC converts the data according to client data types and returns
the results.