EDM pool detail report

The EDM pool report provides information about the number of cursor table, package table, or database directory requests, loads from the DASD, their average elapsed times, and the average section lengths of the loaded data items.

Note: The OMEGAMON for DB2® Performance Expert Statistics reports and traces include EDM pool statistics. Refer to Statistics report set for more information.

The following command produces the EDM pool report shown in I/O Activity EDM Pool Report. 

 
IOACTIVITY
     REPORT
        LEVEL (EDM)

I/O Activity EDM Pool Report

This is an example of an EDM pool report.

   LOCATION: LOCATION1              OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)                       PAGE: 1-1
      GROUP: GROUP1                           I/O ACTIVITY REPORT - EDM POOL                    REQUESTED FROM: NOT SPECIFIED
     MEMBER: MEMBER1                                                                                        TO: NOT SPECIFIED
  SUBSYSTEM: DB2A                            ORDER: INTERVAL-PRIMAUTH-PLANNAME                   INTERVAL FROM: 01/30/15 01:00:00.00
DB2 VERSION: V10                                                                                            TO: 01/30/15 20:50:00.00

INTERVAL                                                                                                                     AVERAGE
 PRIMAUTH                                                                                                        ELAPSED     SECTION
  PLANNAME                                                                               CT/PT/DBD     NOT IN       TIME      LENGTH
                          PACKAGE / DBD / PLAN NAME          TYPE                        REFERENCE   EDM POOL   PER LOAD     (BYTES)
------------------------- ---------------------------------- --------------------------- ---------  ---------  --------- -----------

01/30 01:00 - 06/01 01:05
 AUTH_10
  PLAN_10
                          DBD: 10                            DATABASE DESCRIPTOR                 1        101   0.110000      100.00

01/30 01:20 - 06/01 01:25
 AUTH_10
  PLAN_10
                          PLAN: PLAN_00                      CURSOR TABLE - HEADER               1        201   0.120000      200.00

01/30 01:40 - 06/01 01:45
 AUTH_10
  PLAN_10
                          PLAN: PLAN_01                      CURSOR TABLE - DIRECTORY            1        301   0.130000      300.00

01/30 02:00 - 06/01 02:05
 AUTH_10
  PLAN_10
                          PLAN: PLAN_02                      CURSOR TABLE - RDS SECTION          1        401   0.140000      400.00

01/30 02:20 - 06/01 02:25
 AUTH_10
  PLAN_10
                          PACKAGE: LOCN- LOCATION_DB2A       PACKAGE TABLE - HEADER              1        501   0.150000      500.00
                                   COLL- COLLECTION_DB2A
                                   PKID- PACKAGE_DB2A
                                   CTKN- X'C3E3D56DC4C2F2C1'

01/30 02:40 - 06/01 02:45
 AUTH_10
  PLAN_10
                          PACKAGE: LOCN- LOCATION_SYD2
                                   COLL- COLLECTION_SYD2     PACKAGE TABLE - DIRECTORY           1        601   0.160000      600.00
                                   PKID- PACKAGE_SYD2
                                   CTKN- X'C3E3D56DE2E8C4F2'

01/30 03:00 - 01/30 03:05
 AUTH_10
  PLAN_10
                          PACKAGE: LOCN- LOCATION_LOCATION1
                                   COLL- COLLECTION_SYD1
                                   PKID- PACKAGE_LOCATION1   PACKAGE TABLE - RDS SECTION         1        701   0.170000      700.00
                                   CTKN- X'C3E3D56DE2E8C4F1'
   LOCATION: LOCATION1                OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)                     PAGE: 1-2
      GROUP: GROUP1                           I/O ACTIVITY REPORT - EDM POOL                    REQUESTED FROM: NOT SPECIFIED
     MEMBER: MEMBER1                                                                                        TO: NOT SPECIFIED
  SUBSYSTEM: DB2A                            ORDER: INTERVAL-PRIMAUTH-PLANNAME                   INTERVAL FROM: 01/30/15 01:00:00.00
DB2 VERSION: V10                                                                                            TO: 01/30/15 20:50:00.00

INTERVAL                                                                                                                     AVERAGE
 PRIMAUTH                                                                                                        ELAPSED     SECTION
  PLANNAME                                                                               CT/PT/DBD     NOT IN       TIME      LENGTH
                          PACKAGE / DBD / PLAN NAME          TYPE                        REFERENCE   EDM POOL   PER LOAD     (BYTES)
------------------------- ---------------------------------- --------------------------- ---------  ---------  --------- -----------
*** GRAND TOTAL - PACKAGE                                                                        3       1803   0.160000      600.00
*** GRAND TOTAL - PLAN                                                                           3        903   0.130000      300.00
*** GRAND TOTAL - DBD                                                                            1        101   0.110000      100.00

I/O ACTIVITY REPORT COMPLETE

Column description

The following is a description of each column printed in the EDM pool report:
OMEGAMON for Db2 Performance Expert Identifiers
The EDM pool report presents data summarized by OMEGAMON for Db2 Performance Expert identifiers. The report can be ordered by up to three OMEGAMON for Db2 Performance Expert identifiers. The identifiers used to sort the report are printed in the leftmost column. They are printed whenever they change. The second and third identifiers are indented to appear under the relevant column subheading.
Note: Blank or null OMEGAMON for Db2 Performance Expert identifiers are denoted by the word 'BLANK'.
PACKAGE / DBD / PLAN NAME
The name of the cursor table, package table, or database directory. The package name is printed on four lines, and consists of the following fields:
LOCN
Location name
COLL
Collection identifier
PKID
Package identifier
CTKN
Consistency token
TYPE
The type of data being accessed.
CT/PT/DBD REFERENCE
The number of cursor table, package table, or database directory requests performed by the data type specified in the TYPE column.
NOT IN EDM POOL
The number of times cursor table, package table, or database directory was not found in the EDM pool. If it is not found in the EDM pool, the request can be satisfied from the buffer pool or the DASD.
ELAPSED TIME PER LOAD
The average elapsed time of loads from the buffer pool or DASD.
AVERAGE SECTION LENGTH (BYTES)
The average section length of a loaded data item identified in the TYPE column.
TYPE TOTAL
When the data contains two or more EDM records with the same data type and the same OMEGAMON for Db2 Performance Expert identifiers, a type total line is printed with the following heading:
  • DBD TOTAL for type DBD
  • PLANNAME TOTAL for type CT
  • PACKAGE TOTAL for type PT
SUBTOTAL
When a report is ordered by three identifiers and there is more than one third-level identifier reported under it, a subtotal is printed each time the second-level identifier changes.
TOTAL
When a report is ordered by two or three identifiers and there is more than one second-level identifier reported under it, a total is printed each time the first-level identifier changes.
GRAND TOTAL
A grand total is printed at the end of each location if there is more than one first-level identifier reported.