Statement statistics: sqlexecdirect – HP Neoview Release 2.5 Software User Manual

Page 60

Description

Statistic

Total NDCS SQL server real time, in microseconds, from the time the execute started
to the time the results are sent back.

ODBCElapsedTime

Total NDCS SQL server CPU process time, in microseconds, from the time the
execute started to the time the response is sent back to the client with the results
error code.

ODBCExecutionTime

(ins/upd/del) Number of rows that were inserted, updated, or deleted.

NumberOfRows

Execute error code, if any. A zero (0) indicates that the execute was successful.

ErrorCode

Cumulative number of rows accessed.

RowsAccessed

Cumulative number of rows retrieved.

RowsRetrieved

Cumulative number of disk reads.

DiscReads

Number of messages sent to the disk process.

MsgsToDisc

Size, in bytes, of the total number of messages sent to the disk process.

MsgsBytesToDisc

Number of lock waits (this is the concurrency cost).

LockWaits

Cumulative number of times record locks are escalated to file locks.

LockEscalation

Statement Statistics: SQLExecDirect

SQLExecDirect statistics are written to the alternate EMS collector at the time an EXECUTE
statement is received (listed in the order written in the event message):

Description

Statistic

Unique session ID generated by the NDCS SQL server at the time the connection is
established.

Session ID

STATEMENT:SQLExecDirect (Statistics option that was selected.)

Message Attribute

Message sequence number generated by NDCS. The number begins with zero (0) and
is incremented by 1 with each new record.

Sequence Number

Unique statement ID generated by the NDCS SQL server at the time the PREPARE
statement is received.

StatementID

Estimated query cost returned by the SQL compiler.

EstimatedCost

Valid types are: Insert, Delete, Update, Select.

StatementType

Total NDCS SQL server real time, in microseconds, from the time the execdirect started
to the time the results are sent back.