Lots of Unaccounted For time in DB2 and no zIIP? If DB2_Version >= 10 might be a quick win to add one. Though not, of course, free.
But Unaccounted For time in DB2 can be many things: Waiting on CPU is one but another fave is paging. Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: Gary Snider <gsni...@central-insurance.com> To: IBM-MAIN@LISTSERV.UA.EDU Date: 30/09/2014 14:43 Subject: Re: zOS 1.13 – CPU latent demand Sent by: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> Thanks for the reply Scott. You are correct, we only have 1 CPU. We have many DB2 threads with high "unaccounted for time". One of the possible reasons for this could be that zOS/DB2 is waiting on CPU. I was hoping to use the CPU Activity report to determine if this is contributing to "unaccounted for time". I have added another snapshot below of a different LPAR during a busy time. Please help me undstand the diffence between LPAR BUSY and MVS BUSY. Does the difference indicate this LPAR was waiting for the CPU? How can I quantify this? The differnect between the two values? Any insight you can give me to understand how to interpret this report would be appreciated. Or if you can suggest a different report/method. C P U A C T I V I T Y PAGE 1 z/OS V1R13 SYSTEM ID DEVL START 09/29/2014-13.45.00 INTERVAL 000.14.59 RPT VERSION V1R13 RMF END 09/29/2014-14.00.00 CYCLE 2.000 SECONDS CPU 2818 CPC CAPACITY 53 SEQUENCE CODE 00000000000437E7 MODEL V01 CHANGE REASON=N/A HIPERDISPATCH=NO H/W MODEL M05 ---CPU--- ---------------- TIME % ---------------- LOG PROC --I/O INTERRUPTS-- NUM TYPE ONLINE LPAR BUSY MVS BUSY PARKED SHARE % RATE % VIA TPI 0 CP 100.00 21.95 80.01 ------ 14.0 962.6 16.14 TOTAL/AVERAGE 21.95 80.01 14.0 962.6 16.14 SYSTEM ADDRESS SPACE AND WORK UNIT ANALYSIS ---------NUMBER OF ADDRESS SPACES--------- -----------------------DISTRIBUTION OF IN-READY WORK UNIT QUEUE-------------- QUEUE TYPES MIN MAX AVG NUMBER OF 0 10 20 30 40 50 60 70 80 90 100 WORK UNITS (%) |....|....|....|....|....|....|....|....|....|....| IN 80 100 89.2 IN READY 0 58 6.7 <= N 9.9 >>>>> = N + 1 10.6 >>>>>> OUT READY 0 12 0.2 = N + 2 6.2 >>>> OUT WAIT 0 0 0.0 = N + 3 4.3 >>> <= N + 5 9.0 >>>>> LOGICAL OUT RDY 0 0 0.0 <= N + 10 22.1 >>>>>>>>>>>> LOGICAL OUT WAIT 57 80 68.5 <= N + 15 15.2 >>>>>>>> <= N + 20 7.8 >>>> ADDRESS SPACE TYPES <= N + 30 8.9 >>>>> <= N + 40 3.3 >> BATCH 1 4 2.4 <= N + 60 1.8 > STC 117 124 119.5 <= N + 80 0.4 > TSO 33 35 34.0 <= N + 100 0.0 ASCH 0 0 0.0 <= N + 120 0.0 OMVS 2 4 2.0 <= N + 150 0.0 > N + 150 0.0 ---------NUMBER OF WORK UNITS------------- CPU TYPES MIN MAX AVG N = NUMBER OF PROCESSORS ONLINE (1.0 ON AVG) CP 0 119 11.5 BLOCKED WORKLOAD ANALYSIS OPT PARAMETERS: BLWLTRPCT (%) 1.0 PROMOTE RATE: DEFINED 2 WAITERS FOR PROMOTE: AVG 0.007 BLWLINTHD 20 USED (%) 1 PEAK 1 P A R T I T I O N D A T A R E P O R T PAGE 2 z/OS V1R13 SYSTEM ID DEVL START 09/29/2014-13.45.00 INTERVAL 000.14.59 RPT VERSION V1R13 RMF END 09/29/2014-14.00.00 CYCLE 2.000 SECONDS MVS PARTITION NAME DEVL NUMBER OF PHYSICAL PROCESSORS 1 GROUP NAME CMIGRP IMAGE CAPACITY 12 CP 1 LIMIT 50 NUMBER OF CONFIGURED PARTITIONS 4 AVAILABLE 3 WAIT COMPLETION NO DISPATCH INTERVAL DYNAMIC --------- PARTITION DATA ----------------- -- LOGICAL PARTITION PROCESSOR DATA -- -- AVERAGE PROCESSOR UTILIZATION PERCENTAGES -- ----MSU---- -CAPPING-- PROCESSOR- ----DISPATCH TIME DATA---- LOGICAL PROCESSORS --- PHYSICAL PROCESSORS --- NAME S WGT DEF ACT DEF WLM% NUM TYPE EFFECTIVE TOTAL EFFECTIVE TOTAL LPAR MGMT EFFECTIVE TOTAL DEVL A 140 12 12 NO 0.0 1 CP 00.03.16.886 00.03.17.473 21.88 21.95 0.07 21.88 21.95 PROD A 730 0 33 NO 0.0 1 CP 00.09.14.419 00.09.15.138 61.61 61.69 0.08 61.61 61.69 TECH A 55 2 2 NO 0.0 1 CP 00.00.26.133 00.00.26.748 2.90 2.97 0.07 2.90 2.97 TEST A 74 8 4 NO 0.0 1 CP 00.01.11.317 00.01.11.726 7.93 7.97 0.05 7.93 7.97 *PHYSICAL* 00.00.05.265 0.59 0.59 ------------ ------------ ----- ----- ----- TOTAL 00.14.08.757 00.14.16.351 0.84 94.32 95.17 G R O U P C A P A C I T Y R E P O R T PAGE 3 z/OS V1R13 SYSTEM ID DEVL START 09/29/2014-13.45.00 INTERVAL 000.14.59 RPT VERSION V1R13 RMF END 09/29/2014-14.00.00 CYCLE 2.000 SECONDS GROUP-CAPACITY PARTITION SYSTEM -- MSU -- WGT ---- CAPPING ---- - ENTITLEMENT - NAME LIMIT DEF ACT DEF WLM% ACT% MINIMUM MAXIMUM CMIGRP 50 DEVL DEVL 12 12 140 NO 0.0 0.0 7 12 PROD PROD 0 33 730 NO 0.0 0.0 36 50 TECH TECH 2 2 55 NO 0.0 0.0 2 2 TEST TEST 8 4 74 NO 0.0 0.0 3 8 ----------------------------------- ------------------------------------------------------ TOTAL 51 999 ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN