1 / 114

ADABAS Performance Thruput, CPU, IO checklist

ADABAS Performance Thruput, CPU, IO checklist. Jim Poole. TOPICS (skip) THRUPUT ISSUES CPU ISSUES IO ISSUES. USER. CQ. THREAD. USER. B.THRUPUT ISSUES. OVERVIEW. TIME 1. TIME 2. TIME 3. TIME 4. B.THRUPUT ISSUES. TOOLS. 1. ADADBS DCQ 2. ADADBS ECBS (OFF CLOG)

josekwilliams
Télécharger la présentation

ADABAS Performance Thruput, CPU, IO checklist

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ADABAS Performance Thruput, CPU, IO checklist Jim Poole

  2. TOPICS • (skip) • THRUPUT ISSUES • CPU ISSUES • IO ISSUES

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

  4. 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?

  5. 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

  6. 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

  7. 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.

  8. 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

  9. 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)

  10. 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

  11. 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 : : : : :

  12. 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.

  13. B.THRUPUT ISSUES. SOLUTIONS. 0. THREADS 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.

  14. B.THRUPUT ISSUES. SOLUTIONS. 0. THREADS. ? COST OF THREADS WITH 0 CALLS ? NONE TEST: • VARY NT = 5 , 10 , 20 , 50 • NUC UP, • RUN 3 JOBS, • NUC DOWN • THREE ACTIVE THREADS: • : 50 – 64% • : 28 – 37% • : 8 - 18% RESULTS:

  15. B.THRUPUT ISSUES. SOLUTIONS. 0. THREADS. ADABAS CPU TIME vs NT= ( ONLY 3 ACTIVE THREADS ) NT= 5 NT= 10 NT= 20 NT= 50

  16. B.THRUPUT ISSUES. SOLUTIONS. 0. THREADS. ? WHAT PERCENT IN LAST THREAD ? THREADS: SUMMARIZE(SUBTOT=ON) COUNT MEAN(DURATION) (PF=N2.5) MEAN(CMD-TIME) (PF=N1.5) MEAN(TOTAL-IO) (PF=N1.2) BY THREAD *** INTERVAL N HOURS WATCH DURATION AS THREAD INCREASES

  17. PERCENT CMDS MEAN DURATION MEAN IO MEAN CMDTIME B.THRUPUT ISSUES. SOLUTIONS. 0. THREADS. ? WHAT PERCENT IN LAST THREAD ? Example 1. THRD.1 = 1,170K, THRD.20 = 2K CMDS

  18. PERCENT CMDS MEAN DURATION MEAN IO MEAN CMDTIME B.THRUPUT ISSUES. SOLUTIONS. 0. THREADS. ? WHAT PERCENT IN LAST THREAD ? Example 2. THRD.1 = 951K, THRD.20 = .1K CMDS

  19. PERCENT CMDS MEAN DURATION MEAN IO = 0 MEAN CMDTIME B.THRUPUT ISSUES. SOLUTIONS. 0. THREADS. ? WHAT PERCENT IN LAST THREAD ? Example 3. CMDS WITH NO IO

  20. B.THRUPUT ISSUES. SOLUTIONS. 1. WAIT-ON-HOLD. L4,L5,L6,S4,HI vs. L1,L2,L3,S1

  21. 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

  22. EXAMPLE NUC SHUTDOWN DDPRINT or SYNS-5B CHCKPNT 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..

  23. 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. 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'

  24. B.THRUPUT ISSUES. SOLUTIONS. 1. WAIT-ON-HOLD. Example 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 ? WHEN IS ‘R’ OPTION NOT GOOD? ? BATCH ? ? BACKGROUND ? ? ?

  25. 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

  26. 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 B.THRUPUT ISSUES. SOLUTIONS. 2. COMPLEX CMD WAIT. EXAMPLES

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

  28. 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?)

  29. 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

  30. 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

  31. 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 1. CL=5 B.THRUPUT ISSUES. SOLUTIONS. 3. UPDATE CMD WAIT. EXAMPLES

  32. ! 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 ?

  33. 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.

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

  35. 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

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

  37. 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.

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

  39. 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 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

  40. 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

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

  42. B.THRUPUT ISSUES. SOLUTIONS. 12. BAD SEARCHES. 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 -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 . . . .

  43. 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

  44. B.THRUPUT ISSUES. SOLUTIONS. 13. EXCESSIVE NON-DESCRIPTOR SEARCHES. a. REPORT ON VIA: WHERE CMD(1) = ‘S’ AND DATA-IO>1 b. STOP VIA: ADARUN NONDES=NO

  45. B.THRUPUT ISSUES. SOLUTIONS. 14. EXCESSIVE SX/L3 ON EXPANDED FILES. EXPANDED FILE vs. 4-BYTE ISN FILE MANAGEABILITY vs PERFORMANCE SPACE SAVINGS vs SPACE SAVINGS (3B vs 4B ISN IN ASSO) (NO DUPE DE-VALUE ACROSS FILES) ! UNLESS MANAGEABILITY IS AN ISSUE, USE 4-BYTE ISN FILES ! (vs EXPANDED FILES)

  46. 1,5,8,9,10,11 R.I.L. (Resultant Isn List) B.THRUPUT ISSUES. SOLUTIONS. 14. EXCESS SX/L3, EXP.FILES Sx : Eg. NAME=BOB NON-EXP. FILE FILE-X NI : BOB 1,5,8 EACH NI BLOCK: MADE UP OF NI ELEMENTS. EACH NI ELEMENT: DE-VALUE / COUNT / ISN LIST

  47. 1,5,8,9,10,11 R.I.L. (Resultant Isn List) B.THRUPUT ISSUES. SOLUTIONS. 14. EXCESS SX/L3, EXP.FILES Sx : Eg. NAME=BOB EXP. FILE (4 COMPONENTS) FILE-W NI : BOB 1 FILE-X NI : BOB 5,8 FILE-Y NI : BOB 9 FILE-Z NI : BOB 10,11

  48. L3’S: 1 2 3 4 5 6 B.THRUPUT ISSUES. SOLUTIONS. 14. EXCESS SX/L3, EXP.FILES L3/6 THRU FILE NON-EXP. FILE FILE-X NI : BART BEA,BETH BILL BOB,BRAD NOTE: 1 TBQ(LQ=) ELEMENT CREATED AND USED.

  49. FILE-Z NI : FILE-W NI : BART BEA BETH BOB BOB BRAD . . . BUD B.THRUPUT ISSUES. SOLUTIONS. 14. EXCESS SX/L3, EXP.FILES L3/6 THRU FILE EXP. FILE (4 COMPONENTS) 1 5 9 13 2 3 6 FILE-X NI : BART BEA BETH . . . 7 FILE-Y NI : BETH BILL 8 BOB 10 . . . 4 12 11 L3’S: FOLLOW THE NUMBERS NOTE: 4 TBQ(LQ=) ELEMENTS CREATED AND USED.

  50. B.THRUPUT ISSUES. SOLUTIONS. 14. EXCESS SX/L3, EXP.FILES EXAMPLE CUSTOMER EXPERIENCE (SAG-L) BEFORE: 29 COMPONENT FILES, 3B ISN, 16M RECS @ AFTER: 10 COMPONENT FILES, 4B ISN, 50M RECS @ BEFORE: L3’S DOING UP TO 60 IO’S AFTER: L3’S DOING UNDER 10 IO’S BEFORE: BATCH JOB RUNS IN 11 HOURS AFTER: BATCH JOB RUNS IN 3 HOURS

More Related