ADABAS 7 PERFORMANCE CHECKLIST - PowerPoint PPT Presentation

slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
ADABAS 7 PERFORMANCE CHECKLIST PowerPoint Presentation
Download Presentation
ADABAS 7 PERFORMANCE CHECKLIST

play fullscreen
1 / 124
ADABAS 7 PERFORMANCE CHECKLIST
240 Views
Download Presentation
keira
Download Presentation

ADABAS 7 PERFORMANCE CHECKLIST

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. October, 2001 ADABAS 7 PERFORMANCE CHECKLIST Jim Poole

  2. TOPICS • NEW WITH ADABAS 7. • THRUPUT ISSUES • CPU ISSUES • IO ISSUES

  3. NEW WITH ADABAS 7. • WHY FASTER? • LBP ACCESS VIA HASHING • 10:1 REDUCTION IN INSTRUCTIONS • IN THE LAB: ABOUT 16% CPU IMPROVEMENT. • LFIOP ACCESS VIA HASHING. • LFIOP AS A BACKUP LBP. • BETTER IMPORTANCE CHAIN DETERMINATION. • ASYTVS=YES.

  4. V7 ADABAS 7 CPU / CMDTIME DIFFERENCES

  5. NEW WITH ADABAS 7. • FORWARD INDEX COMPRESSION (FIC) 1. SAVE INDEX SPACE: 46 TO 54% 2. SAVEOVERALL DATABASE SPACE:10 TO 13 % 3. SAVE ON NEW DASD FOR GROWTH:10 TO 13 % 4. INCREASE POTENTIAL and EFFICIENCY FOR NI CACHE: CACHE UI AC (eg. 15K 16K BLOCKS) CACHE NI ??? (eg. 1700K BLOCKS) CACHE DS ?? (eg. 400K BLOCKS) 5. REDUCE IO FOR L3/L6, L9, Sx: DATABASE OVERALL BATCH JOBS DOING LONG L3/L6 6. IMPROVED BUFFER EFFICIENCY. 7. FASTER UTILITIES: ADASAV, ADAORD, ETC.

  6. NEW WITH ADABAS 7. (FIC) FIC->

  7. NEW WITH ADABAS 7. (FIC) ? ANY CPU OVERHEAD ON READS ? ? ANY CPU OVERHEAD ON UPDATES? ! NONE ! FIC EVERYTHING.

  8. MTR=NO -> MTR=YES -> • NEW WITH ADABAS 7. ADARES REGENGERATE MTR=YES

  9. NEW WITH ADABAS 7. ONLINE INV, ORD ONLINE INVERT: 1. RUN TIME: SAME AS BATCH (IF NO DATABASE ACTIVITY) 2. USES A TAD MORE NI SPACE THAN BATCH (+2%) 3. DURING ADASAV: WATCH THOSE PLOG IO’S 4. ADARES REGENERATES NICELY. ONLINE ORD: 1. RUN TIME: 5X BATCH (IF NO DATABASE ACTIVITY) 2. RESPECTS PAD MORE THAN BATCH RESPECTS PAD 3. DURING ADASAV: WATCH THOSE PLOG IO’S 4. ADARES REGENERATES DATA NICELY.

  10. USER CQ THREAD USER B.THRUPUT ISSUES. OVERVIEW. TIME 1 TIME 2 TIME 3 TIME 4

  11. B.THRUPUT ISSUES. TOOLS. 1. ADADBS DCQ 2. ADADBS ECBS (OFF CLOG) 3. THREAD COUNT (SHUTDOWN, DTH, etc) 4. ENQ/DUR (ADARUN CL=4/5) 5. SYNS-5B, ADADBS REFRESHSTATS 6. IS THE LOAD IMPACTING PERFORMANCE?

  12. USER CQ THREAD USER TIME 1 TIME 2 TIME 3 TIME 4 X’18’ X’28’ 1. ADADBS DCQ B.THRUPUT ISSUES. TOOLS. USER JOB FLAG IUBL ---------------------------------------- C3C9C3E2C2F1C8E3 (CICSB1HT) CIPRCSBC 28 2927 C3C9C3E2C2F1D2D9 (CICSB1KR) CIPRCSBA 28 2927 C3C9C3E2C2F1C2D8 (CICSB1BQ) CIPRCSBC 28 367 C3C9C3E2C2F1C1F8 (CICSB1A8) CIPRCSBB 18 304 B65C11176BA318C3 (:*..,t.C) P1BXK0AR 28 2530 C3C9C3E2C2F17CD9 (CICSB1@R) CIPRCSBB 18 2927 C3C9C3E2C2F1C2D8 (CICSB1BQ) CIPRCSBC 28 367 C3C9C3F7F1F3F4F4 (CIC71344) CIPRCSBH 18 634 C3C9C3E2C2F15F7B (CICSB1¬#) CIPRCSBA 18 2927 C3C9C3E2C2F1E55E (CICSB1V;) CIPRCSBC 28 380

  13. USER CQ THREAD USER TIME 1 TIME 2 TIME 3 TIME 4 ECB COUNT 2. ADADBS ECBS (OFF CLOG) B.THRUPUT ISSUES. TOOLS. MEAN MEAN MEAN MEAN MEAN MAX CMD ENQTIME DURAT CMD PST TOT PST MAX TIME COUNT SECS SECS TIME ECB IO ECB THD ------ --------- ------- ------- ------- ---- ---- --- --- 165402 291,784 0.00003 0.00063 0.00006 5.8 0.06 24 9 165501 1,578,348 0.00003 0.00047 0.00006 5.3 0.03 21 10 170001 1,949,641 0.00002 0.00051 0.00005 5.1 0.05 43 15 170501 2,171,444 0.00002 0.00038 0.00004 4.3 0.04 20 18 171001 2,018,170 0.00001 0.00033 0.00004 3.7 0.04 21 11 171501 2,178,302 0.00002 0.00036 0.00004 4.7 0.03 34 14 172001 116,406 0.00002 0.00052 0.00005 7.1 0.03 18 8

  14. USER CQ THREAD USER TIME 1 TIME 2 TIME 3 TIME 4 THREAD STATUS USAGE ------------------------ 1 AA 118574503 2 WI 108594864 3 WI 79809114 4 WI 53275850 5 WI 30081855 6 UU 8260981 7 UU 3245993 8 UU 1740369 9 UU 1146354 10 UU 788271 11 UU 523565 12 UU 287192 13 UU 205306 14 UU 159414 15 UU 126467 16 UU 99034 THRD CNT 3. THREAD COUNT (SHUTDOWN, DTH, etc) ? 90 TO 95 % OF COMMANDS ? B.THRUPUT ISSUES. TOOLS.

  15. USER CQ THREAD USER TIME 1 TIME 2 TIME 3 TIME 4 CL=4 ENQ DUR CL=5 ENQ DUR B.THRUPUT ISSUES. TOOLS. 4. ENQ/DUR (ADARUN CL=4/5) MEAN MEAN MEAN MEAN MEAN MAX CMD ENQTIME DURAT CMD PST TOT PST MAX TIME COUNT SECS SECS TIME ECB IO ECB THD ------ --------- ------- ------- ------- ---- ---- --- --- 165402 291,784 0.00003 0.00063 0.00006 5.8 0.06 24 9 165501 1,578,348 0.00003 0.00047 0.00006 5.3 0.03 21 10 170001 1,949,641 0.00002 0.00051 0.00005 5.1 0.05 43 15 170501 2,171,444 0.00002 0.00038 0.00004 4.3 0.04 20 18 171001 2,018,170 0.00001 0.00033 0.00004 3.7 0.04 21 11 171501 2,178,302 0.00002 0.00036 0.00004 4.7 0.03 34 14 172001 116,406 0.00002 0.00052 0.00005 7.1 0.03 18 8

  16. B.THRUPUT ISSUES. TOOLS. 5. SYNS-5B, ADADBS REFRESHSTATS CHECKPOINT CREATED BY: a. NUCLEUS SHUTDOWN (eg. ADAEND) b. ADADBS REFRESHSTATS ALL / CMDUSAGE / COUNTERS / FILEUSAGE POOLUSAGE / THREADUSAGE REPORT ON CHECKPOINT: a. ADAREP CPEXLIST,OFFSET=nn b. DDPRINT OFF NUC (IDENTICAL TO SHUTDOWN STATS)

  17. B.THRUPUT ISSUES. TOOLS. 5. SYNS-5B, REFRESHSTATS EXAMPLE SYNS 5B 2001-09-09 02:35:52 REFRESH STATISTICS THREAD 1: 983037373 COMMANDS THREAD 2: 869948405 COMMANDS THREAD 3: 566715558 COMMANDS : : : : : : REMOTE LOGICAL CALLS 186217341 REMOTE PHYSICAL CALLS 0 LOCAL LOGICAL CALLS 3147407681 LOCAL PHYSICAL CALLS 0 FORMAT TRANSLATIONS 127578298 FORMAT OVERWRITES 42929 AUTORESTARTS 162896 PLOG SWITCHES 145 BUFFER FLUSHES 5353 THROWBACKS ISN PROBS 3536 THROWBACKS SPACE PROBS 0

  18. B.THRUPUT ISSUES. TOOLS. 5. SYNS-5B, REFRESHSTATS EXAMPLE HIGH WATER MARKS: COMMAND QUEUE 31296 HOLD QUEUE 112084 FORMAT POOL 2999916 TBI POOL 4288 TBS POOL 76496 USER QUEUE 196444 WORK POOL 636832 SECURITY POOL 0 UQFLIST POOL 53056 UNIQUE DE POOL 17 XID POOL 0 A1/4 COMMANDS 14749218 BT COMMANDS 164487 : : : : :

  19. SUM OF DURATION ELAPSED TIME B.THRUPUT ISSUES. TOOLS. 6. IS THE LOAD IMPACTING PERFORMANCE? IF > 1, THEN YES, THERE ARE PERFORMANCE IMPACTS. IF < 1, THEN NO, WHO CARES.

  20. B.THRUPUT ISSUES. SOLUTIONS. • 1. WAIT-ON-HOLD. • 2. COMPLEX COMMAND WAIT. • 3. UPDATE COMMAND WAIT. • 4. CLOG IO. • 5. UEX4 AND COMMAND LOG TOOL. • 6. EXCESSIVE COMMAND LOG REPORTING. • 7. BAD UEX1/2. • 8. PATH LENGTH. • 9. SYSTEM PRIORITIES. • 10. EXCESSIVE BATCH JOBS. • 11. EXCESSIVE MULTI/PREFETCH JOBS. • 12. EXCESSIVE BAD SEARCHES. • 13. EXCESSIVE NON-DESCRIPTOR SEARCHES. • 14. EXCESSIVE SX/L3 ON EXPANDED FILES. • 15. USER WORKLOAD IMPROVEMENTS. • 16. NEW DATABASE VS. SMP. • 17. SEE CPU ISSUES. • 18. SEE IO ISSUES.

  21. HOLDERS: SUMMARIZE(SUBTOT=OFF) COUNT MEAN(ENQ-TIME) (PF=N1.5) MEAN(DURATION) (PF=N2.5) MAX(DURATION) MEAN(CMD-TIME) (PF=N1.5) MEAN(TOTAL-IO) (PF=N1.2) MEAN(ECBS) (PF=N2.2) BY CMD *** INTERVAL N HOURS WHERE CMD(1) = 'L' TITLE = ‘HOLD VS NOT HOLD’ INSIGHT-LINES = 100 ** PRINT TO SUMM2 ; APAS INSIGHT B.THRUPUT ISSUES. SOLUTIONS. 1. WAIT-ON-HOLD. L4,L5,L6,S4,HI vs. L1,L2,L3,S1

  22. B.THRUPUT ISSUES. SOLUTIONS. 1. WAIT-ON-HOLD. EXAMPLE ANALYSYS OF HOLD OPTION C MEAN MEAN MAX MEAN MEAN MEAN M CMD ENQTIME DURAT DURAT CMD TOT PST D COUNT SECS SECS SECS TIME IO ECB -- ------- ------- ------- ------- ------- ---- ----- L1 200,659 0.00003 0.00037 0.286 0.00003 0.04 5.07 L4 3,286 0.00003 0.43218 9.456 0.00007 0.03 6.58 L2 204,753 0.00003 0.00022 0.061 0.00003 0.02 4.19 L3 542,935 0.00003 0.00056 0.672 0.00006 0.05 5.31 L6 1,296 0.00003 0.00268 0.138 0.00026 0.21 6.22

  23. B.THRUPUT ISSUES. SOLUTIONS. 1. WAIT-ON-HOLD. LONGHOLD: EXTRACT(ML=500000) TIME * JOBNAME TP-TRANS-NAME (HD='TRAN','NAME') * PROGRAM NATURAL-LOGON NAT-PROGRAM CID (PF=H8) FILE (PF=N3) COMMAND-CODE COPT1 DURATION (PF=N3.3) * ENQ-TIME (PF=N1.5) CMD-TIME (PF=N1.5) ISN (PF=N8) TOTAL-IO (PF=N4) WHERE (CMD = 'L4' OR CMD = 'L6‘) AND DURATION > 5 INSIGHT-LINES = 300 ** PRINT TO ADHOC2; APAS INSIGHT

  24. EXAMPLE NUC SHUTDOWN DDPRINT or SYNS-5B CHECKPOINT THROWBACKS ISN PROBS 3536 MEASURED OVER TIME. B.THRUPUT ISSUES. SOLUTIONS. 1. WAIT-ON-HOLD. EXAMPLE C C TRAN NATURAL FIL M O DURAT CMD TIME NAME PROGRAM CID NUM D 1 SECS TIME 110948 NATP LQNWCTN2 47200201 95 L4 . 9.456 0.00016 TOT ISN IO 1,973,382 0

  25. NOTROPT: SUMMARIZE(SUBTOT=OFF) COUNT MIN(CID) (PF=H8) MAX(CID) (PF=H8) MIN(FILE) (PF=N3) MAX(FILE) (PF=N3) BY NAT-PROGRAM WHERE (CMD = 'L4' OR CMD = 'L6') AND COPT1 NE 'R' AND NAT-PROGRAM > ' ' * AND CID NE H'00000000' INSIGHT-LINES = 100 ** PRINT TO SUMM2; APAS INSIGHT B.THRUPUT ISSUES. SOLUTIONS. 1. WAIT-ON-HOLD. SOLUTIONS: 1. CB COP1=‘R’ RSP CD 145 2. NATURAL WH=OFF (SECURITY), TRAP FOR NON-0 RSP CD.

  26. B.THRUPUT ISSUES. SOLUTIONS. 1. WAIT-ON-HOLD. MIN MAX NATURAL CMD MIN MAX FIL FIL PROGRAM COUNT CID CID NUM NUM -------- ---------- -------- -------- --- --- LQPBKY18 1 43050101 43050101 182 182 LQCCVDN1 36 07500201 10900201 76 78 LQVENKP3 13 07500201 07500201 182 182 LQVXAPP1 23 33450101 34100101 131 169 EXAMPLE ? WHEN IS ‘R’ OPTION NOT GOOD? ? BATCH ? ? BACKGROUND ? ? ?

  27. COMPLEX COMMANDS NOT SELECTED • FROM CQ TO THREAD IF: • LESS THAN 50% WORK-2 AVAILABLE. • LESS THAN LS AVAILABLE IN LWP • AT LEAST ONE COMMAND WAITING • ON LWP SPACE B.THRUPUT ISSUES. SOLUTIONS. 2. COMPLEX COMMAND WAIT. ? USER CQ THREAD • COMPLEX CMD IF : • CMD = S2, S8, S9 • SBL > 9

  28. CMDTYPE: SUMMARIZE (SUBTOT=ON) COUNT MEAN(ENQ-TIME) (PF=N1.5) MEAN(DURATION) (PF=N1.5) MEAN(CMD-TIME) (PF=N1.5) MEAN(ECBS) (PF=N2.1) MEAN(TOTAL-IO) (PF=N1.2) ** BY JOBNAME BY COMMAND-TYPE INTERVAL 15 MINUTES INSIGHT-LINES 100 ** PRINT TO SUMM1 ; APAS INSIGHT B.THRUPUT ISSUES. SOLUTIONS. 2. COMPLEX COMMAND WAIT.

  29. T MEAN MEAN MEAN MEAN MEAN Y CMD ENQTIME DURAT CMD PST TOT P COUNT SECS SECS TIME ECB IO C 435 0.00002 0.00139 0.00013 7.8 0.04 S 335,188 0.00002 0.00106 0.00005 5.4 0.08 U 28,500 0.00002 0.00643 0.00050 8.6 0.44 1. CL=5 T MEAN MEAN MEAN MEAN MEAN Y CMD ENQTIME DURAT CMD PST TOT P COUNT SECS SECS TIME ECB IO C 435 0.00002 0.54339 0.00013 7.8 0.04 S 335,188 0.00002 0.00106 0.00005 5.4 0.08 U 28,500 0.00002 0.00643 0.00050 8.6 0.44 2. CL=5 T MEAN MEAN MEAN MEAN MEAN Y CMD ENQTIME DURAT CMD PST TOT P COUNT SECS SECS TIME ECB IO C 435 0.54307 0.00131 0.00013 7.8 0.04 S 335,188 0.00008 0.00100 0.00005 5.4 0.08 U 28,500 0.00009 0.00636 0.00050 8.6 0.44 3. CL=4 B.THRUPUT ISSUES. SOLUTIONS. 2. COMPLEX COMMAND WAIT. EXAMPLES

  30. B.THRUPUT ISSUES. SOLUTIONS. 2. COMPLEX COMMAND WAIT. EXAMPLE NUC SHUTDOWN DDPRINT or SYNS-5B CHECKPOINT THROWBACKS SPACE PROBS 190

  31. LWKP2 = ( S x 2 x TOPISN ) / ( ( WB – 16) / 4 ) B.THRUPUT ISSUES. SOLUTIONS. 2. COMPLEX COMMAND WAIT. a. WORK-2 SOLUTION ADARUN LWKP2= ! USE ! MIN (<16M REC FILES): 24,000 (3390) 10,000 (8391) • WB = 5724 or 13682 • = BLOCK HEADER • 4 = 4b PER ISN • TOPISN = OF LARGEST FILE FOR SX CMDS • = ALWAYS ENSURE 50% AVAILABLE • S = PEAK NO. OF CONCURRENT COMPLEX COMMANDS. • %Sx TIMES USED THREADS (?TIMES 2?)

  32. B.THRUPUT ISSUES. SOLUTIONS. 2. COMPLEX COMMAND WAIT b. WORK-POOL SOLUTION ADARUN LWP/LS= LWP = LS * 3 = LS + (HI-WATER BYTES FROM DDPRINT) = LS * S (WHERE S = 2 * (%Sx) * NT) = LS * NT

  33. UPDATE COMMANDS NOT SELECTED • FROM CQ TO THREAD IF: • LFIOP=0 AND BUFFER FLUSH, • WORK WRITE, OR PLOG WRITE. • ET-SYNC: ADAEND • ADASAV SYN2 • OP CMD SYNCC B.THRUPUT ISSUES. SOLUTIONS. 3. UPDATE COMMAND WAIT. ? USER CQ THREAD UPDATE CMD IF : CMD = A1,A4,E1,E4, N1,N2, ET,BT,OP,CL

  34. T MEAN MEAN MEAN MEAN MEAN Y CMD ENQTIME DURAT CMD PST TOT P COUNT SECS SECS TIME ECB IO C 435 0.00002 0.00139 0.00013 7.8 0.04 S 335,188 0.00002 0.00106 0.00005 5.4 0.08 U 28,500 0.00002 8.12643 0.00050 8.6 0.44 T MEAN MEAN MEAN MEAN MEAN Y CMD ENQTIME DURAT CMD PST TOT P COUNT SECS SECS TIME ECB IO C 435 0.00009 0.00130 0.00013 7.8 0.04 S 335,188 0.00008 0.00098 0.00005 5.4 0.08 U 28,500 8.11002 0.00643 0.00050 8.6 0.44 1. CL=5 2. CL=4 B.THRUPUT ISSUES. SOLUTIONS. 3. UPDATE COMMAND WAIT. EXAMPLES

  35. ! USE ! B.THRUPUT ISSUES. SOLUTIONS. 3. UPDATE COMMAND WAIT. a. LFIOP SOLUTION ADARUN LFIOP= 1 or n b. ADASAV SOLUTION NOTE UPDATE LOAD VERSUS ADASAV TIME ADASAV TTSYN=120 ?

  36. B.THRUPUT ISSUES. SOLUTIONS. 3. UPDATE COMMAND WAIT. * USE ADARUN CL=4 MCISYN2: SUMMARIZE COUNT MEAN(ENQ-TIME) **** MIN(ENQ-TIME) **** MAX(ENQ-TIME) MIN(TIME) MAX(TIME) BY ENQ-TIME (BY 5) WHERE JOBNAME2(2) = 'CI' AND TIME GE '204500‘ AND TIME LE '235959' AND ENQ-TIME LE 240 INTERVAL 15 MINUTE TITLE='TIME TO SYN2 TO ET-SYNC' PRINT TO ADHOC1; APAS INSIGHT

  37. ! ELIMINATE OR REDUCE ! EACH CLOG IO IS A WAIT IO ! EXAMPLE EXAMPLE DATABASE XYZ FULL COMMAND LOGGING 200 COMMANDS PER SEC MEAN ECBS = 11.3 NOLOGGING MEAN ECBS = 7.0 1400 CMDS PER SEC FULL CLOGGING CLOG BLKSIZE = 5064 Cloglayout = 5 LRECL = 172 RECS PER BLK = 29 IO’S PER SEC = 48.3 MEAN IO TIME = .004 48.3 X .004 = .19 SEC .19 / 1 = 19% WAITTIME B.THRUPUT ISSUES. SOLUTIONS. 4. CLOG IO.

  38. B.THRUPUT ISSUES. SOLUTIONS. 5. UEX4 AND COMMAND LOG TOOL. HOMEGROWN TRIM: PART OF NUC REVIEW: SUBTASK OR HUB APAS/INSIGHT: SUBTASK

  39. EXAMPLE ??? EVERY HOUR, DB EXPERIENCING SLOWDOWN ??? SOLUTION SUMMARY REPORT: COUNT, DURATION,ETC. BY JOBNAME BY NAT-PROGRAM BY FILE BY CMD INTERVAL 1 HOUR B.THRUPUT ISSUES. SOLUTIONS. 6. EXCESSIVE COMMAND LOG REPORTING.

  40. B.THRUPUT ISSUES. SOLUTIONS. 7. BAD UEX1/2. DATABASE IS SINGLE-THREADED AT THIS TIME.

  41. EXAMPLE MEAN MEAN MEAN MEAN MEAN CMD ENQTIME DURAT CMD PST TOT JOB NAME COUNT SECS SECS TIME ECB IO -------- ------ ------- ------- ------- ---- ---- CICSPROD 1,416 0.00002 0.00152 0.00027 2.0 0.89 DB00SAME 1,002 0.00003 0.00006 0.00001 1.9 0.02 DB00LPAR 1,002 0.00081 0.00009 0.00002 1.9 0.02 DB00VTAM 1,002 0.18632 0.00014 0.00002 2.4 0.05 B.THRUPUT ISSUES. SOLUTIONS. 8. PATH LENGTH. SAME LPAR, DIFFERENT LPAR, REMOTE

  42. PRE - WLM WLM • ADABAS • TP • BATCH • VELOCITY • HIGH • 2. SYSSTC B.THRUPUT ISSUES. SOLUTIONS. 9. SYSTEM PRIORITIES. EXAMPLE ? CPU WAIT ? ? ENQ-TIME ? ? CMD-TIME ?

  43. B.THRUPUT ISSUES. SOLUTIONS. 10. EXCESSIVE BATCH JOBS. • EACH BATCH JOB TENDS TO DOMINATE ONE MORE • THREAD 11. EXCESSIVE MULTI/PREFETCH JOBS. a. SHOULD RUN NON-PEAK TIMES. b. SHOULD RUN FEWER THAN 2-3 CONCURRENTLY.

  44. B.THRUPUT ISSUES. SOLUTIONS. 10,11. EXCESSIVE JOBS. ECBS BATCH JOBS

  45. B.THRUPUT ISSUES. SOLUTIONS. 10,11. EXCESSIVE JOBS. DECLARE FETCH (A3) VALOF IF COPT1 = 'M' RESULTIS 'YES' ELSEIF COPT1 = 'P' RESULTIS 'YES' ELSEIF COPT1 = 'O' RESULTIS 'YES' ELSE RESULTIS ' ' IFEND; DBUSE: SUMMARIZE(GTT=YES) COUNT MEAN(ENQ-TIME) (PF=N1.5) MEAN(DURATION) (PF=N1.5) MEAN(CMD-TIME) (PF=N1.5) MEAN(ECBS) (PF=N2.1) MEAN(TOTAL-IO) (PF=N1.2) MAX(FETCH) (HD='FTCH') BY JOBNAME INTERVAL 15 MINUTES INSIGHT-LINES=300; APAS INSIGHT

  46. B.THRUPUT ISSUES. SOLUTIONS. 10,11. EXCESSIVE JOBS. EXAMPLE MEAN MEAN MEAN MEAN MEAN CMD ENQTIME DURAT CMD PST TOT JOB NAME COUNT SECS SECS TIME ECB IO FTCH CICSPRDA 39 0.00002 0.00045 0.00012 10.4 0.18 CICSPRDB 2,217 0.00003 0.00037 0.00007 9.3 0.04 CICSPRDC 10,231 0.00002 0.00093 0.00006 9.2 0.14 CICSPRDD 524 0.00003 0.00029 0.00006 9.3 0.04 CICSPRDE 1,055 0.00003 0.00070 0.00009 9.7 0.10 CICSPRDF 274 0.00002 0.00041 0.00005 9.7 0.02 CICSPRDG 2,246 0.00002 0.00172 0.00021 8.9 0.34 CICSPRDH 311 0.00003 0.00059 0.00005 8.9 0.05 CICSPRDU 12 0.00118 0.00060 0.00007 10.8 0.17 JOB00001 6,660 0.00000 0.00104 0.00005 8.5 0.18 JOB00002 5,815 0.00000 0.00118 0.00004 8.4 0.07 JOB00003 5,497 0.00000 0.00130 0.00004 8.4 0.09 JOB00004 3,892 0.00000 0.00032 0.00003 9.4 0.02 JOB00005 3,127 0.00000 0.00031 0.00002 9.5 0.02 JOB00006 15,833 0.00000 0.00027 0.00002 8.5 0.03 ======== 57,733 0.00001 0.00074 0.00005 8.8 0.09

  47. B.THRUPUT ISSUES. SOLUTIONS. 10,11. EXCESSIVE JOBS. EXAMPLE MEAN MEAN MEAN MEAN MEAN CMD ENQTIME DURAT CMD PST TOT JOB NAME COUNT SECS SECS TIME ECB IO FTCH -------- ------- ------- ------- ------- ---- ---- ---- CICSPRD1 5,261 0.00003 0.00073 0.00008 3.7 0.13 CICSPRD2 494 0.00003 0.00030 0.00011 4.2 0.03 CICSPRD3 267 0.00003 0.00095 0.00009 3.1 0.21 CICSPRD4 233 0.00003 0.00212 0.00009 4.5 0.22 DDBTCHA1 5,158 0.00002 0.00109 0.00016 4.6 0.09 DDBTCHB6 8 0.00002 0.00020 0.00006 5.5 0.00 DDBTCHHQ 4,407 0.00003 0.00200 0.00015 3.6 1.11 DDBTCHXY 226 0.00003 0.06774 0.00113 7.7 5.65 YES

  48. B.THRUPUT ISSUES. SOLUTIONS. 12. EXCESSIVE BAD SEARCHES. EXAMPLE FIND CLIENTS WITH CITY=‘NEW YORK’ AND NAME=‘SMITH’ AND AGE>21 AND WEIGHT=321

  49. B.THRUPUT ISSUES. SOLUTIONS. 12. BAD SEARCHES. APAS INSIGHT HIGHIO:SUMMARIZE(SUBTOT=OFF) COUNT MEAN(TOTAL-IO) MEAN(DATA-IO) MEAN(ISNQ) MEAN(DURATION) BY JOBNAME BY NAT-PROGRAM BY CID (PF=H8) BY CMD WHERE TOTAL-IO GT 100 OR DURATION GT 1.0 * PRINT TO SUMBAD INSIGHT-LINES 300; HIGHIOE: EXTRACT(ML=1000000) DATE-TIME COMMAND-CODE FILE JOBNAME CID (PF=H8) TP-TRANS-NAME NAT-LOGON NAT-PROGRAM PROGRAM CICS-TERMID ISNQ TOTAL-IO DURATION WHERE . . . .

  50. B.THRUPUT ISSUES. SOLUTIONS. 12. BAD SEARCHES. EXAMPLE C MEAN MEAN JOB/ M CMD TOT DATA TRANS PROGRAM CID D COUNT IO IO -------- -------- -------- -- ----- ------------- NATO XYVADDP1 01300101 S1 3 178.3 0.0 MEAN MEAN ISN DURAT QUANT SECS -------- ------- 29,527.0 0.4050