List report

The DB2® List report provides a detailed list of all network units-of-work with DB2 activity. This report consolidates CICS® CMF performance class records and DB2 accounting statistics from a single or multiple CICS systems.

The following command produces a List report like that in Figure 1.
CICSPA DB2(LIST(ALL),LISTZERO)
Figure 1. DB2 List report
 V5R3M0                                                 CICS Performance Analyzer
                                                                DB2 - List
                                            __________________________________________________
DB2R0001 Printed at 12:34:56 02/15/2015    Data from 20:14:56  6/22/2007 to 21:14:31  6/22/2007                        Page       1


Tran/ Userid/ Program/                 UOW R               ..DB2 Wait Time..   DB2    User CPU                            Response A
SSID  Authid  Planname  APPLID    Task Seq T Term  LUName   Connect  Thread   ReqCnt    Time     Start Time    Stop Time    Time   B

ILGN 5000853  NWTPXHPS ATPHP20   87302   4 T <B7N ATPWTC1   .000000  .000000      506  .121424  20:14:58.028 20:14:58.731  .703717

IBOA 5000853  NWTPXHPS ATPHP20   87311   3 T <B7N ATPWTC1   .000000  .000000      223  .211792  20:15:00.049 20:15:00.437  .387405

DBCR DB2OPER  AGTPPLAN ATPHP20   87311  Thread Identification   ID=POOLIBOA0019  NETName=DFHEXCIU.3MSE002A  UOWID=C8DE57436768
                                        Begin Time: 20:15:00.051632  6/22/07  End Time: 20:15:00.434859  6/22/07
                                        Class1: Thread Time     Elapsed= .383227  CPU= .188482
                                        Class2: In-DB2 Time     Elapsed= .337977  CPU= .185725
                                        Class3: Suspend Time    Total  = .109145  I/O= .075235  Lock/Latch= .002409  Other= .031501
                                        Buffer Manager Summary  GtPgRq=    3506  SyPgUp=      66
                                        Locking Summary         Suspnd=       0  DeadLk=       0  TmeOut=       0  MxPgLk=      21
                                        SQL DML Query/Update    Sel=      54  Ins=       7  Upd=       5  Del=       0
                                        SQL DML 'Other'         Des=       0  Pre=       0  Ope=      18  Fet=      31  Clo=      18

CSMI 5000853  NWTPPOLL ATPHP20   87312   2 T <B7O ATPWTC1   .000000  .000000       10  .003120  20:15:00.053 20:15:00.078  .025131

DBCR DB2OPER  AGTPPLAN ATPHP20   87312  Thread Identification   ID=POOLPOLL0020  NETName=DFHEXCIU.3MSE002A  UOWID=C8DE57447A46
                                        Begin Time: 20:15:00.054013  6/22/07  End Time: 20:15:00.077526  6/22/07
                                        Class1: Thread Time     Elapsed= .023513  CPU= .001434
                                        Class2: In-DB2 Time     Elapsed= .021482  CPU= .001291
                                        Class3: Suspend Time    Total  = .019722  I/O= .019630  Lock/Latch= .000092  Other= .000000
                                        Buffer Manager Summary  GtPgRq=      28  SyPgUp=       0
                                        Locking Summary         Suspnd=       0  DeadLk=       0  TmeOut=       0  MxPgLk=       0
                                        SQL DML Query/Update    Sel=       5  Ins=       0  Upd=       0  Del=       0
                                        SQL DML 'Other'         Des=       0  Pre=       0  Ope=       1  Fet=       3  Clo=       1
In the DB2 List report, two types of data are presented:
  1. The first is a single data line (in column format) for each CMF performance class record
  2. The second is a block of data lines (in row format) for each associated DB2 accounting record
Records that are part of the same network unit-of-work are printed sequentially in groups separated by blank lines. A network unit-of-work will only be presented if it involved some DB2 activity.

The DB2 List report contains the following information: