Usage

A prerequisite for this report is activation of the DB2+ option during the measurement. This option records exact SQL call counts, total SQL service time and total SQL processing CPU time by embedded SQL statement. When measuring a distributed data facility (DDF) address space, SQL Enclave and SQL zIIP CPU times are also recorded. This report shows quantification by DB2® Plan. You can further expand each DB2 Plan line to see a further breakdown and quantification by individual embedded SQL statement.