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)

Kernel execution time for this SQL statement (microseconds)

DATASOURCERUNTIME

FIXED(20)

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

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

DISPATCHCOUNT

FIXED(20)

Number of assignments of the CPU during executions of this SQL statement

TASKSELFSUSPENDCOUNT

FIXED(20)

Number of voluntary releases of the CPU during execution of this SQL statement

REGIONACCESSCOUNT

FIXED(20)

Number of region accesses during execution of this SQL statement

SELFIOREADCOUNT

FIXED(20)

Number of read calls done during execution of this SQL statement (no request to I/O threads)

SELFIOREADPAGECOUNT

FIXED(20)

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

AVGSELFIOREADABSOLUTETIME

FIXED(38)

Average time needed for each read operation during execution of this SQL statement (microseconds)

SELFIOREADABSOLUTETIME

FIXED(20)

Total time needed for each read operation during execution of this SQL statement (microseconds)

SELFIOWRITECOUNT

FIXED(20)

Number of write calls during execution of this SQL statement (no request to I/O threads)

SELFIOWRITEPAGECOUNT

FIXED(20)

Number of pages written during SELFIOWRITECOUNT during execution of this SQL statement

AVGSELFIOWRITEABSOLUTETIME

FIXED(38)

Average time needed for each write operation during execution of this SQL statement

SELFIOWRITEABSOLUTETIME

FIXED(20)

Total time needed for each write operation during execution of this SQL statement (microseconds)

IOREADCOUNT

FIXED(20)

Number of read calls requested during execution of this SQL statement and done by I/O thread

IOREADPAGECOUNT

FIXED(20)

Number of pages read by a I/O thread during execution of this SQL statement

AVGIOREADRELATIVETIME

FIXED(38)

Average time needed for each read operation during execution of this SQL statement (microseconds)

IOREADRELATIVETIME

FIXED(20)

Total time needed for each read operation done by a I/O thread during execution of this SQL statement (microseconds)

AVGIOREADABSOLUTETIME

FIXED(38)

Average waiting time between read request and getting the replay during execution of this SQL statement (microseconds)

IOREADABSOLUTETIME

FIXED(20)

Total waiting time between read request and getting the replay during execution of this SQL statement (microseconds)

IOWRITECOUNT

FIXED(20)

Number of write calls during execution of this SQL statement and done by an I/O thread

IOWRITEPAGECOUNT

FIXED(20)

Number of pages written by an I/O thread during execution of this SQL statement

AVGIOWRITERELATIVETIME

FIXED(38)

Average time needed for each write operation done by an I/O thread during execution of this SQL statement (microseconds)

IOWRITERELATIVETIME

FIXED(20)

Total time needed for each write operation done by an I/O thread during execution of this SQL statement (microseconds)

AVGIOWRITEABSOLUTETIME

FIXED(38)

Average waiting time between write request and getting the replay during execution of this SQL statement (microseconds)

IOWRITEABSOLUTETIME

FIXED(20)

Total waiting time between write request and getting the replay during execution of this SQL statement (microseconds)

AVGSUSPENDRELATIVETIME

FIXED(38)

Average time for each suspend during execution of this SQL statement (microseconds)

SUSPENDRELATIVETIME

FIXED(20)

Total time for each suspend during execution of this SQL statement (microseconds)

AVGSUSPENDABSOLUTETIME

FIXED(38)

Average waiting time between suspending itself and getting the resume during execution of this SQL statement (microseconds)

SUSPENDABSOLUTETIME

FIXED(20)

Total waiting time between suspending itself and getting the resume during execution of this SQL statement (microseconds)

AVGWAITRELATIVETIME

FIXED(38)

Average waiting time for a lock during execution of this SQL statement (microseconds)

WAITRELATIVETIME

FIXED(20)

Total waiting time for a lock during execution of this SQL statement (microseconds)

AVGWAITABSOLUTETIME

FIXED(38)

Average waiting time between suspending itself and getting the lock during execution of this SQL statement (microseconds)

WAITABSOLUTETIME

FIXED(20)

Total waiting time between suspending itself and getting the lock during execution of this SQL statement (microseconds)

SLEEPCOUNT

FIXED(20)

Number of sleep requests during execution of this SQL statement

AVGSLEEPRELATIVETIME

FIXED(38)

Average sleeping time during execution of this SQL statement (microseconds)

SLEEPRELATIVETIME

FIXED(20)

Total sleeping time during execution of this SQL statement (microseconds)

AVGSLEEPABSOLUTETIME

FIXED(38)

Average time between starting of sleep and being awakened during execution of this SQL statement (microseconds)

SLEEPABSOLUTETIME

FIXED(20)

Total time between starting of sleep and being awakened during execution of this SQL statement (microseconds)

DATASOURCEWAITCOUNT

FIXED(20)

Number of waits for external data source during execution of this SQL statement

AVGDATASOURCEWAITABSOLUTETIME

FIXED(38)

Average waiting time for external data source during execution of this SQL statement (microseconds)

DATASOURCEWAITABSOLUTETIME

FIXED(20)

Total waiting time for external data source during execution of this SQL statement (microseconds)

RUNNINGCOUNT

FIXED(20)

Number of changes to state running during execution of this SQL statement

AVGRUNNINGABSOLUTETIME

FIXED(38)

Average time needed at state running during execution of this SQL statement (microseconds)

RUNNINGABSOLUTETIME

FIXED(20)

Total time needed at state running during execution of this SQL statement (microseconds)

SCHEDULINGCOUNT

FIXED(20)

Number of scheduler calls during execution of this SQL statement

AVGSCHEDULINGABSOLUTETIME

FIXED(38)

Average time needed for scheduling during execution of this SQL statement (microseconds)

SCHEDULINGABSOLUTETIME

FIXED(20)

Totaltime needed for scheduling during execution of this SQL statement (microseconds)

PARTITIONID

FIXED(5)

Identification of the partition

APPLICATIONPROCESS

FIXED(10)

Identification of the client hardware

APPLICATIONNODE

CHAR(64)

Identification of the client hardware