Overview (iSeries)

The Overview screen is the entry screen of the SAP database monitor for DB2 UDB for iSeries. This screen displays the most important indicators of DB2 UDB for iSeries database performance.

To access information on the system you are currently monitoring, call transaction DB4COCKPIT.

The information is divided into the following categories:

Field

Description

SQL Statement

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

Table Scans

Number

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

Number

Total number of indexes created by the query optimizer

Total Time

Total time in seconds required for all indexes to be created

Index Advice

Number

Total number of all index advice given by the query optimizer

Number of Tables

Total number of tables for which the query optimizer advised an index

Sorts

Number

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

To access information on all systems for which an RFC (Remote Function Call) destination is maintained, choose Goto ® All Systems.