Using the Product in a CICS Environment › Summary Statistics Panels › DB2 Statistics › Possible Tuning Criteria:

Possible Tuning Criteria:

• Reduction in aborts
• Reduction in waits

Panel 1:

 CA MAT ------------ CICS Statistics - DB2 --------------- Row 1 to 16 of 25
 COMMAND ===>                                                  SCROLL ===> CSR
 Collection Time: 2007/07/16 20:06:07   Reset Time: 00:00:00   Profile: CICSA

 ____ __________________ _______________ __________________ _______________
 -------------------------------------------------------------------------------
 DB2  ****************** *************** ****************** ***************
 DB2  Connection name    RCT1$           DB2 sysid          DB8G
 DB2  Release            0810            Groupid            N/A
 DB2  PoolPlan           N/A             PlanExit           DSNCUEXT
 DB2  PoolAuth           N/A             ComdAuth           N/A
 DB2  Conntime GMT       07.198 00:05:03 Conntime Local     07.197 20:05:03
 DB2  Disctime GMT       N/A             Disctime Local     N/A
 DB2  Maximum TCBs       00000012        Current TCBs       00000000
 DB2  HWM TCBs           00000000        Current Free TCBs  00000000
 DB2  Tasks TCB READYQ   00000000        Peak TCB READYQ    00000000
 DB2  Pool calls         00000000        Pool Signons       00000000
 DB2  Pool commits       00000000        Pool aborts        00000000
 DB2  Pool single commts 00000000        Pool thrd reuses   00000000
 DB2  Pool terminates    00000000        Pool thrd waits    00000000
 DB2  Pool thrd limit    00000003        Pool thrds currnt  00000000
 DB2  Peak pool threads  00000000        Pool tsks current  00000000

Panel 2:

 CA MAT ------------ CICS Statistics - DB2 --------------- Row 17 to 25 of 25
 COMMAND ===>                                                  SCROLL ===> CSR
 Collection Time: 2007/07/16 20:06:07   Reset Time: 00:00:00   Profile: CICSA

 ____ __________________ _______________ __________________ _______________
 -------------------------------------------------------------------------------
 DB2  Peak pool tasks    00000000        Total pool tasks   00000000
 DB2  Cur pool RDYQ tsks 00000000        Pk pool RDYQ tasks 00000000
 DB2  Pool part. signons 00000000        Comd calls         00000000
 DB2  Comd signons       00000000        Comd terminates    00000000
 DB2  Comd overflows     00000000        Comd thrd limit    00000001
 DB2  Comd thrd current  00000000        Comd thrd HWM      00000000
 DB2  Comd AuthType      Userid          Pool AuthType      Userid
 DB2  Resync Member      Resync UOWs     Pool AccountRec    Txid
 DB2  Pool ThreadWait    Yes             Pool Priority      N/A
 ********************************* End of Table ********************************