ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-48
ZNUMTRX (For Resource Accounting Log Data)
NSSQL_EXECUTION_
TIME
––
INT (8) Amount of NonStop SQL/MP
execution time, in microseconds,
between the accounting start time
and end time. This value can be
greater than
NSODBC_ELAPSED_TIME due
to parallelism in the processing.
Includes:
•
Total CPU time used by the
SQL Executor and all
Guardian System Library calls
made by the SQL Executor
•
Total CPU time used by all
supporting ESP processes
•
Total CPU time used by all
supporting SORTPROG
processes
NSODBC_ELAPSED_
TIME
––
INT (8) Time in microseconds elapsed
under NonStop ODBC server
process control between the
accounting start time and end
time. It reflects cumulative wall
clock time as measured each time
control is given to the NonStop
ODBC Server, NOS, until it
responds with a message. This
includes any wait time between
multipacket return streams.
NSSQL_ELAPSED_
TIME
––
INT (8) Time in microseconds elapsed
while under NonStop SQL/MP
executor control between the
accounting start time and end
time. It reflects the cumulative wall
clock time as measured each time
control is given to the SQL master
executor until it releases back to
the application.
Table 8-23. Description of ZNUMTRX (page 4 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