Object documentationCOMMANDMONITOR Locate this document in the navigation structure

 

The system table <DATABASE_SYSTEM_ADMINISTRATOR>.COMMANDMONITOR describes monitoring data for single executions of SQL statements.

Structure

COMMANDMONITOR

COMMANDID

CHAR(8) BYTE

Identification of the SQL statement

EXECUTECOUNT

FIXED(20)

Number of executions of the SQL statement

ROWNUMBER

FIXED(20)

Number of rows of a mass SQL statement

PARENTEXECUTECOUNT

FIXED(20)

Number of executions of the SQL statement

SESSIONID

FIXED(10)

Identification of the database session

CONSTRAINTID

FIXED(10)

Identification of the constraint kept in COMMANDMONITORCONSTRAINTS

EXECUTIONENDDATE

TIMESTAMP

Time the last execution of this SQL statement was finished

RUNTIME

FIXED(20,6)

Kernel execution time for this SQL statement (microseconds)

DATASOURCERUNTIME

FIXED(20,6)

Bridge execution time for this SQL statement

NULL for non-Bridge SQL statement (microseconds)

READROWCOUNT

FIXED(20)

Number of rows read during execution of this SQL statement

QUALIFIEDROWCOUNT

FIXED(20)

Number of rows qualified during execution of this SQL statement

READCOUNT

FIXED(20)

Number of reads during execution of this SQL statement

PHYSICALREADCOUNT

FIXED(20)

Number of physical reads during execution of this SQL statement

VIRTUALREADCOUNT

FIXED(20)

Number of virtual reads during execution of this SQL statement

FETCHCOUNT

FIXED(20)

Number of fetch calls during execution of this SQL statement

FETCHROWCOUNT

FIXED(20)

Number of rows fetched during execution of this SQL statement

SUSPENDCOUNT

FIXED(20)

Number of physical reads during execution of this SQL statement

WAITCOUNT

FIXED(20)

Number of waits during execution of this SQL statement

READPAGECOUNT

FIXED(10)

Number of pages read during execution of this SQL statement

WRITEPAGECOUNT

FIXED(10)

Number of pages written during execution of this SQL statement

READAHEADREQUESTCOUNT

FIXED(20)

Number of read ahead requests during execution of this SQL statement

READAHEADIGNOREDREQUESTCOUNT

FIXED(20)

Number of read ahead requests ignored during execution of this SQL statement

READAHEADPHYSICALREADPAGECOUNT

FIXED(20)

Number of read ahead pages read during execution of this SQL statement