Command capturing
Command Capturing is performed in each monitored DB2 /VM database server.
For each running SQL statement, SQL/MF records following items in the
Monitor Shared Segment:
-
the executing DB2 and VM username
-
the name of the originating terminal
-
the DB2 package name and section number
-
the statement start and end time
-
the statement type (prepare, open, fetch ...)
-
the text of the statement (also for compiled statements)
-
the contents of the host variables used by the statement
-
the isolation level and the blocking attribute
-
the name of the DBspace(s) and table(s) being accessed
-
the name of the index used and the index access method (selective or
non-selective index scan)
-
the CPUtime used by the statement
-
the IOwait, pagewait, lockwait and communication wait times during the statement
-
the number of RDS, DBSS and dispatcher calls executed by the statement
-
the number of lock waits, lock escalations and deadlocks during the statement
-
the number of rows processed
-
the number of page buffer lookups
-
the number of data pages read and written
-
the number of directory buffer lookups
-
the number of directory pages read and written
-
the number of log pages read and written
-
the number of dataspace pagefaults
-
the number of pages accessed on internal DBspaces
Using these captured data, the
Running Command
List function of the SQL/MF user interface shows all agents and SQL
statements in progress.
For each entry in the Running Command List, the
Command
Detail function provides all statistics collected for that statement
by SQL/MF.