Overview (IBM DB2 for i) 
The Overview screen is the entry screen of the SAP database monitor for IBM DB2 for i. This screen displays the most important indicators of DB2 for i database performance.
To access information on the system you are currently monitoring, call transaction DBACOCKPIT.
The information is divided into the following categories:
Field |
Description |
|---|---|
SQL Statements |
|
Number of Calls |
Total number of all executed SQL statements |
<NAME> Statement |
Name of statement function |
Time per Call |
Average time in milliseconds per executed call |
File Activity |
|
Reads |
Total number of read requests since last IPL of the database server |
Physical Reads |
Total number of read requests that resulted in actual I/O request since last IPL of the database server |
Quality |
Indicates the frequency as a percentage of requests that did not result in physical reads. This is calculated using the following formula: Quality = Reads - Physical Reads x 100 Reads |
Reads/User Calls |
Average number of read requests per executed SQL statement |
Access Methods |
|
Table Scans |
Total number of performed table scans |
Total Rows Read |
Total number of rows read during all table scans that have been performed |
Total Time |
Total time in seconds required for all table scans |
Index Creates |
Total number of indexes created by the query optimizer |
Total Time |
Total time in seconds required for all indexes to be created |
Index Advised |
Total number of all index advice given by the query optimizer |
No. of Tables |
Total number of tables for which the query optimizer advised an index |
Sorts |
Total number of sort processes |
Total Rows Sorted |
Total number of rows sorted |
Total Time |
Total time in seconds required for all sort processes |
Temporary Files |
|
Number |
Total number of temporary result files created by the query optimizer |
Total Time |
Total time in seconds required for creation of all temporary files |