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.
CICSPA DB2(LIST(ALL),LISTZERO)
V5R1M0 CICS Performance Analyzer
DB2 - List
__________________________________________________
DB2R0001 Printed at 12:03:45 10/15/2012 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
The DB2 List report contains the following information: