Statement statistics: sql statement, Statement statistics: sqlexecute – HP Neoview Release 2.5 Software User Manual
Page 59
Description
Statistic
Total number of SQL INSERT statements sent by the HP ODBC driver to the NDCS
SQL server; does not include internally generated SQL statements.
TotalInsertStmtsExecuted
Total number of SQL DELETE statements sent by the HP ODBC driver to the NDCS
SQL server; does not include internally generated SQL statements.
TotalDeleteStmtsExecuted
Total number of SQL UPDATE statements sent by the HP ODBC driver to the NDCS
SQL server; does not include internally generated SQL statements.
TotalUpdateStmtsExecuted
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
View Event Messages
59