Default language.

I/O summary detail EDM Pool report by DB2 and interval (BIOSUMED)

The following figure shows a sample of the I/O summary detail EDM Pool report by DB2 and interval (BIOSUMED).

Related topic

I-O-activity-reports


Important

The report is based on Db2 performance trace IFCIDs 29 and 30.

1                       BIOSUMED: IO SUMMARY DETAIL: EDM POOL                            11/04/14 08:44:06    PAGE     1

    LOCATION: DGR                                                                                    DATA FROM: 08/22/2013 11:29:37
   D/S GROUP: DSNDGR    MBR: DGR1                     I/O SUMMARY DETAILS: EDM POOL                         TO: 08/22/2013 11:32:40
   SUBSYSTEM: DGR1      VER: 10.1

    INTERVAL BEGIN - END                                                                                   LOADS   ELAPSED  AVERAGE
        PRIME AUTHID                                                                          CT/PT/DBD  (NOT IN      TIME   LENGTH
           PLAN NAME           PACKAGE / DBD / PLAN NAME          TYPE                        REFERENCE    POOL)  PER LOAD  (BYTES)
    -------------------------- ---------------------------------- --------------------------- --------- -------- --------- --------
 +  08/22 11:25  - 08/22 11:30
    RDHJMB2
    DMRSEL01
                               PLAN: DMRSEL01                     CURSOR TABLE - HEADER               1        1 00.000034     0.00
                               PLAN: DMRSEL01                     CURSOR TABLE - DIRECTORY            1        1 00.000033     0.00

                               DBD:  0127                         DATABASE DESCRIPTORS                1        1 00.006501 24218.00

                               DBD:  0149                         DATABASE DESCRIPTORS                1        1 00.000715  8066.00

                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT1
                           PKG CTKN: 196C9F9E052047FD
                                                                  PACKAGE TABLE - HEADER              1        1 00.000065  3744.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000016   528.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000440  9184.00

                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT2
                           PKG CTKN: 196C9FA21D5BEB1D
                                                                  PACKAGE TABLE - HEADER              1        1 00.000039  3744.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000016   528.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000035  6860.00

                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT3
                           PKG CTKN: 196C9FA30EC5BAB9
                                                                  PACKAGE TABLE - HEADER              1        1 00.000041  3744.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000016   528.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000055  7272.00

                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT4
                           PKG CTKN: 1977F4CE102FD0C1
                                                                  PACKAGE TABLE - HEADER              1        1 00.000057  4000.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000019   576.00
                                                                  PACKAGE TABLE - RDS SECTION         2        2 00.000072  8004.00

 +  08/22 11:30  - 08/22 11:35
    RDHJMB2
    DMRSEL01
1                       BIOSUMED: IO SUMMARY DETAIL: EDM POOL                            11/04/14 08:44:06    PAGE     2

    LOCATION: DGR                                                                                    DATA FROM: 08/22/2013 11:29:37
   D/S GROUP: DSNDGR    MBR: DGR1                     I/O SUMMARY DETAILS: EDM POOL                         TO: 08/22/2013 11:32:40
   SUBSYSTEM: DGR1      VER: 10.1

    INTERVAL BEGIN - END                                                                                   LOADS   ELAPSED  AVERAGE
        PRIME AUTHID                                                                          CT/PT/DBD  (NOT IN      TIME   LENGTH
           PLAN NAME           PACKAGE / DBD / PLAN NAME          TYPE                        REFERENCE    POOL)  PER LOAD  (BYTES)
    -------------------------- ---------------------------------- --------------------------- --------- -------- --------- --------
                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT10
                           PKG CTKN: 196C9F9E1D8B14D5
                                                                  PACKAGE TABLE - HEADER              1        1 00.000052  3744.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000016   528.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000032  6860.00

                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT11
                           PKG CTKN: 196C9F9F12112189
                                                                  PACKAGE TABLE - HEADER              1        1 00.000044  3744.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000024   528.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000029  7272.00

                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT12
                           PKG CTKN: 196C9FA008AC499D
                                                                  PACKAGE TABLE - HEADER              1        1 00.000037  3744.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000027   528.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000048  7480.00

                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT13
                           PKG CTKN: 196C9FA0194DDAC5
                                                                  PACKAGE TABLE - HEADER              1        1 00.000060  3744.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000016   528.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000115  9184.00

                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT14
                           PKG CTKN: 196C9FA107F41A75
                                                                  PACKAGE TABLE - HEADER              1        1 00.000049  3744.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000016   528.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000032  6860.00

                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT15
                           PKG CTKN: 196C9FA1175D158D
                                                                  PACKAGE TABLE - HEADER              1        1 00.000053  3744.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000028   528.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000029  7272.00

1                       BIOSUMED: IO SUMMARY DETAIL: EDM POOL                            11/04/14 08:44:06    PAGE     3

    LOCATION: DGR                                                                                    DATA FROM: 08/22/2013 11:29:37
   D/S GROUP: DSNDGR    MBR: DGR1                     I/O SUMMARY DETAILS: EDM POOL                         TO: 08/22/2013 11:32:40
   SUBSYSTEM: DGR1      VER: 10.1

    INTERVAL BEGIN - END                                                                                   LOADS   ELAPSED  AVERAGE
        PRIME AUTHID                                                                          CT/PT/DBD  (NOT IN      TIME   LENGTH
           PLAN NAME           PACKAGE / DBD / PLAN NAME          TYPE                        REFERENCE    POOL)  PER LOAD  (BYTES)
    -------------------------- ---------------------------------- --------------------------- --------- -------- --------- --------
                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT16
                           PKG CTKN: 196C9FE508D1658D
                                                                  PACKAGE TABLE - HEADER              1        1 00.000041  4176.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000043   576.00
                                                                  PACKAGE TABLE - RDS SECTION         2        2 00.000038  4436.00

                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT5
                           PKG CTKN: 196C9FA411630C4D
                                                                  PACKAGE TABLE - HEADER              1        1 00.000078  3744.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000016   528.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000077  6860.00

                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT6
                           PKG CTKN: 196C9FA501903EE1
                                                                  PACKAGE TABLE - HEADER              1        1 00.000045  3744.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000016   528.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000036  9184.00

                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT7
                           PKG CTKN: 196C9FA511FF584D
                                                                  PACKAGE TABLE - HEADER              1        1 00.000125  3744.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000140   528.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000158  7272.00

                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT8
                           PKG CTKN: 196C9FA60262D081
                                                                  PACKAGE TABLE - HEADER              1        1 00.000041  3744.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000016   528.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000033  7480.00

                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DMRCAT9
                           PKG CTKN: 196C9FA611FE7C05
                                                                  PACKAGE TABLE - HEADER              1        1 00.000029  3744.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000016   528.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000032  9184.00

1                       BIOSUMED: IO SUMMARY DETAIL: EDM POOL                            11/04/14 08:44:06    PAGE     4

    LOCATION: DGR                                                                                    DATA FROM: 08/22/2013 11:29:37
   D/S GROUP: DSNDGR    MBR: DGR1                     I/O SUMMARY DETAILS: EDM POOL                         TO: 08/22/2013 11:32:40
   SUBSYSTEM: DGR1      VER: 10.1

    INTERVAL BEGIN - END                                                                                   LOADS   ELAPSED  AVERAGE
        PRIME AUTHID                                                                          CT/PT/DBD  (NOT IN      TIME   LENGTH
           PLAN NAME           PACKAGE / DBD / PLAN NAME          TYPE                        REFERENCE    POOL)  PER LOAD  (BYTES)
    -------------------------- ---------------------------------- --------------------------- --------- -------- --------- --------
                           PKG LOCN:
                           PKG COLL: DMRQA
                           PKG PKID: DWQATRIG
                           PKG CTKN: 1977F37817071081
                                                                  PACKAGE TABLE - HEADER              1        1 00.000049  3800.00
                                                                  PACKAGE TABLE - DIRECTORY           1        1 00.000020   576.00
                                                                  PACKAGE TABLE - RDS SECTION         1        1 00.000051  7384.00

 .  *** GRAND TOTAL - PACKAGE                                                                        53       53 00.000053  4037.74
    *** GRAND TOTAL - PLAN                                                                            2        2 00.000033     0.00
    *** GRAND TOTAL - DBD                                                                             2        2 00.003608 16142.00

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*