beautypg.com

Statement statistics: sql statement, Statement statistics: sqlexecute – HP Neoview Release 2.4 Software User Manual

Page 43

background image

Description

Statistic

Total number of SQL SELECT statements sent by the HP ODBC driver to the NDCS
SQL server; does not include internally generated SQL statements.

TotalSelectStmtsExecuted

Total number of SQL Catalog statements sent by the HP ODBC driver to the NDCS
SQL server.

TotalCatalogStmts

Total number of SQLPrepare calls.

TotalPrepares

Total number of SQLExecute calls.

TotalExecutes

Total number of SQLFetch calls.

TotalFetches

Total number of SQLClose calls.

TotalCloses

Total number of SQLExecDirect calls.

TotalExecDirects

Total number of SQL statement execution errors detected by the NDCS SQL server.

TotalErrors

Total number of SQL statement execution warnings detected by the NDCS SQL
server.

TotalWarnings

Statement Statistics: SQL Statement

Statement statistics are written to the alternate EMS collector at the time a PREPARE 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:SQLStatement (the 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

Text of the SQL statement. This field can be distributed in multiple messages.

SQL Text

Statement Statistics: SQLExecute

SQLExecute 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 server at the time the connection is
established.

Session ID

STATEMENT:SQLExecute (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

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

View Event Messages

43