ADABAS 7 PERFORMANCE

1
ADABAS 7 PERFORMANCE CHECKLIST (SPUG)
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
• 101 REDUCTION IN INSTRUCTIONS
• IN THE LAB ABOUT 16 CPU IMPROVEMENT.
• LFIOP ACCESS VIA HASHING.
• LFIOP AS A BACKUP LBP.
• BETTER IMPORTANCE CHAIN DETERMINATION.
• ASYTVSYES.

4
ADABAS 7 CPU / CMDTIME DIFFERENCES
5

• NEW WITH ADABAS 7.
• FORWARD INDEX COMPRESSION (FIC)

1. SAVE INDEX SPACE
46 TO 54
2. SAVE OVERALL 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-gt
7

• NEW WITH ADABAS 7. (FIC)

? ANY CPU OVERHEAD ON READS ? ? ANY CPU OVERHEAD
ON UPDATES?
! NONE !
FIC EVERYTHING.
8

• NEW WITH ADABAS 7. ADARES REGENGERATE MTRYES

9
B.THRUPUT ISSUES. OVERVIEW.
TIME 4
TIME 3
TIME 2
TIME 1
10
B.THRUPUT ISSUES. TOOLS.
1. ADADBS DCQ (AOS) 2. ADADBS ECBS (OFF CLOG) 3.
ENQ/DUR (ADARUN CL4/5) 4. SYNS-5B, ADADBS
REFRESHSTATS
11
B.THRUPUT ISSUES. TOOLS.
USER JOB FLAG IUBL
---------------------------------------- C3C9C3E2C
2F1C8E3 (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_at_R) CIPRCSBB 18
2927 C3C9C3E2C2F1C2D8 (CICSB1BQ) CIPRCSBC 28
367 C3C9C3F7F1F3F4F4 (CIC71344) CIPRCSBH 18
634 C3C9C3E2C2F15F7B (CICSB1) CIPRCSBA 18
2927 C3C9C3E2C2F1E55E (CICSB1V) CIPRCSBC 28
380
12
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
13
B.THRUPUT ISSUES. TOOLS.
3. ENQ/DUR (ADARUN CL4/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
14
B.THRUPUT ISSUES. TOOLS.
4. 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,OFFSETnn b. DDPRINT OFF NUC
(IDENTICAL TO SHUTDOWN STATS)
15
B.THRUPUT ISSUES. TOOLS. 4. SYNS-5B, REFRESHSTATS
EXAMPLE
SYNS 5B 2001-09-09 023552 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
16
B.THRUPUT ISSUES. TOOLS. 4. 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
17
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.
18
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
19
B.THRUPUT ISSUES. SOLUTIONS.
0. THREADS.
ADABAS CPU TIME vs NT ( ONLY 3 ACTIVE THREADS )
NT 5
NT 10
NT 20
NT 50
20
B.THRUPUT ISSUES. SOLUTIONS.
0. THREADS.
? WHAT PERCENT IN LAST THREAD ?
THREADS SUMMARIZE(SUBTOTON) COUNT
MEAN(DURATION) (PFN2.5)
MEAN(CMD-TIME) (PFN1.5) MEAN(TOTAL-IO)
(PFN1.2) BY THREAD INTERVAL N
HOURS TITLE THREAD USAGE
INSIGHT-LINES 100 PRINT TO SUMM2

APAS INSIGHT
WATCH DURATION AS THREAD INCREASES
21
B.THRUPUT ISSUES. SOLUTIONS.
0. THREADS.
? WHAT PERCENT IN LAST THREAD ?
Example 1. THRD.1 1,170K, THRD.20 2K CMDS

22
B.THRUPUT ISSUES. SOLUTIONS.
0. THREADS.
? WHAT PERCENT IN LAST THREAD ?
Example 2. THRD.1 951K, THRD.20 .1K CMDS
23
B.THRUPUT ISSUES. SOLUTIONS.
0. THREADS.
? WHAT PERCENT IN LAST THREAD ?
Example 3. CMDS WITH NO IO
24
B.THRUPUT ISSUES. SOLUTIONS.
1. WAIT-ON-HOLD.
L4,L5,L6,S4,HI vs. L1,L2,L3,S1
25
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
26
B.THRUPUT ISSUES. SOLUTIONS. 1. WAIT-ON-HOLD.
LONGHOLD EXTRACT(ML500000) TIME
JOBNAME TP-TRANS-NAME (HD'TRAN','NAME')
PROGRAM NATURAL-LOGON NAT-PROGRAM
CID (PFH8) FILE
(PFN3) COMMAND-CODE COPT1
DURATION (PFN3.3) ENQ-TIME
(PFN1.5) CMD-TIME (PFN1.5)
ISN (PFN8) TOTAL-IO
(PFN4) WHERE (CMD 'L4' OR CMD
'L6) AND DURATION gt 5
INSIGHT-LINES 300 PRINT TO ADHOC2
APAS INSIGHT
27
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..
28
B.THRUPUT ISSUES. SOLUTIONS. 1. WAIT-ON-HOLD.
SOLUTIONS 1. CB COP1R
RSP CD 145 2. NATURAL WHOFF
(SECURITY), TRAP FOR NON-0 RSP CD.
29
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 ? ? ?
30
B.THRUPUT ISSUES. SOLUTIONS.
2. COMPLEX COMMAND WAIT.
?
USER
CQ
THREAD

• COMPLEX CMD IF
• CMD S2, S8, S9
• SBL gt 9

31
B.THRUPUT ISSUES. SOLUTIONS. 2. COMPLEX COMMAND
WAIT.
CMDTYPE SUMMARIZE (SUBTOTON) COUNT
MEAN(ENQ-TIME) (PFN1.5) MEAN(DURATION)
(PFN1.5) MEAN(CMD-TIME) (PFN1.5)
MEAN(ECBS) (PFN2.1) MEAN(TOTAL-IO)
(PFN1.2) BY JOBNAME BY
COMMAND-TYPE INTERVAL 15 MINUTES
INSIGHT-LINES 100 PRINT TO SUMM1
APAS INSIGHT
32
B.THRUPUT ISSUES. SOLUTIONS. 2. COMPLEX CMD
WAIT.
EXAMPLES
33
B.THRUPUT ISSUES. SOLUTIONS. 2. COMPLEX COMMAND
WAIT.
Example
NUC SHUTDOWN DDPRINT or SYNS-5B CHECKPOINT
THROWBACKS SPACE PROBS 190
34
B.THRUPUT ISSUES. SOLUTIONS. 2. COMPLEX COMMAND
WAIT.
a. WORK-2 SOLUTION
ADARUN LWKP2
! USE !
MIN (lt16M 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?)
  

35
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
36
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
37
B.THRUPUT ISSUES. SOLUTIONS. 3. UPDATE CMD
WAIT.
EXAMPLES
38
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 TTSYN120 ?
39
B.THRUPUT ISSUES. SOLUTIONS.
4. CLOG IO.
40
B.THRUPUT ISSUES. SOLUTIONS.
5. UEX4 AND COMMAND LOG TOOL.
HOMEGROWN
TRIM PART OF NUC
REVIEW SUBTASK OR HUB
APAS/INSIGHT SUBTASK
41
B.THRUPUT ISSUES. SOLUTIONS.
6. EXCESSIVE COMMAND LOG REPORTING.
42
B.THRUPUT ISSUES. SOLUTIONS.
7. BAD UEX1/2.
DATABASE IS SINGLE-THREADED AT THIS TIME.
43
B.THRUPUT ISSUES. SOLUTIONS.
8. PATH LENGTH. SAME LPAR, DIFFERENT LPAR,
REMOTE
44
B.THRUPUT ISSUES. SOLUTIONS.
9. SYSTEM PRIORITIES.
EXAMPLE
? CPU WAIT ? ? ENQ-TIME ? ? CMD-TIME ?
45
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.
46
B.THRUPUT ISSUES. SOLUTIONS. 10,11. EXCESSIVE
JOBS.
ECBS BATCH JOBS
47
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(GTTYES) COUNT
MEAN(ENQ-TIME) (PFN1.5)
MEAN(DURATION) (PFN1.5) MEAN(CMD-TIME)
(PFN1.5) MEAN(ECBS) (PFN2.1)
MEAN(TOTAL-IO) (PFN1.2) MAX(FETCH)
(HD'FTCH') BY JOBNAME INTERVAL
15 MINUTES INSIGHT-LINES300
APAS INSIGHT
48
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
49
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
50
B.THRUPUT ISSUES. SOLUTIONS.
12. EXCESSIVE BAD SEARCHES.
EXAMPLE
FIND CLIENTS WITH CITYNEW YORK
AND NAMESMITH AND
AGEgt21 AND WEIGHT321

51
B.THRUPUT ISSUES. SOLUTIONS. 12. BAD SEARCHES.
APAS INSIGHT
HIGHIOSUMMARIZE(SUBTOTOFF) COUNT
MEAN(TOTAL-IO) MEAN(DATA-IO)
MEAN(ISNQ) MEAN(DURATION) BY
JOBNAME BY NAT-PROGRAM BY CID
(PFH8) BY CMD WHERE
TOTAL-IO GT 100 OR DURATION GT 1.0
PRINT TO SUMBAD INSIGHT-LINES 300
HIGHIOE EXTRACT(ML1000000) DATE-TIME
COMMAND-CODE FILE JOBNAME
CID (PFH8) TP-TRANS-NAME
NAT-LOGON NAT-PROGRAM
PROGRAM CICS-TERMID ISNQ
TOTAL-IO DURATION WHERE . . . .
52
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
53
B.THRUPUT ISSUES. SOLUTIONS.
13. EXCESSIVE NON-DESCRIPTOR SEARCHES.
a. REPORT ON VIA WHERE
CMD(1)
S
AND DATA-IOgt1 b. STOP VIA ADARUN
NONDESNO
54
B.THRUPUT ISSUES. SOLUTIONS.
14. EXCESSIVE SX/L3 ON EXPANDED FILES.
EXPANDED FILE
4-BYTE ISN FILE
vs.
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)
55
B.THRUPUT ISSUES. SOLUTIONS. 14. EXCESS SX/L3,
EXP.FILES
Sx Eg. NAMEBOB
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
56
B.THRUPUT ISSUES. SOLUTIONS. 14. EXCESS SX/L3,
EXP.FILES
Sx Eg. NAMEBOB
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
57
B.THRUPUT ISSUES. SOLUTIONS. 14. EXCESS SX/L3,
EXP.FILES
L3/6 THRU FILE
NON-EXP. FILE
FILE-X NI
BART
BOB,BRAD
BILL
BEA,BETH
NOTE 1 TBQ(LQ) ELEMENT CREATED AND USED.
58
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
. . .
BETH
BEA
7
FILE-Y NI
BETH
. . .
BOB
BILL
8
10
4
12
11
L3S FOLLOW THE NUMBERS
NOTE 4 TBQ(LQ) ELEMENTS CREATED AND USED.
59
B.THRUPUT ISSUES. SOLUTIONS. 14. EXCESS SX/L3,
EXP.FILES
EXAMPLE
CUSTOMER EXPERIENCE (SAG-L)
BEFORE 29 COMPONENT FILES, 3B ISN, 16M RECS _at_
AFTER 10 COMPONENT FILES, 4B ISN, 50M RECS _at_
BEFORE L3S DOING UP TO 60 IOS
AFTER L3S DOING UNDER 10 IOS
BEFORE BATCH JOB RUNS IN 11 HOURS
AFTER BATCH JOB RUNS IN 3 HOURS
60
B.THRUPUT ISSUES. SOLUTIONS.
15. USER WORKLOAD IMPROVEMENTS. a.
HISTORICAL PERIODIC REVIEW OF THE TOP 10
b. ONLINE
61
B.THRUPUT ISSUES. SOLUTIONS. 15. USER WORKLOAD.
a. HISTORICAL PERIODIC REVIEW OF THE TOP 10
Example
PROGRAM COUNT DURATION TOTALIO
CMDTIME LQNSCTNH 33,455,949 5,888.379
786 826.723 LQ2DCTN1 25,876,640 7,441.052
396,146 1,228.789 LQLWNTN1 23,581,968
10,270.808 880,891 791.377 GGLGNUP2
9,548,540 2,392.155 26,559
498.448 LQLGLCA1 7,254,208 9,371.013
1,248,313 495.574 GGLCNEP1 6,529,145
1,902.695 49,985 352.686 LQ24C2N3
6,420,988 1,472.643 15,476
291.566 LQNWDGF2 5,486,722 2,103.440
57,322 382.099 LQLCNTP1 5,270,677
1,802.396 46,019 412.284 SECUPTER
4,956,576 1,227.651 1,473 351.807
REVIEW USER BY (CID), FILE, CMD
62
B.THRUPUT ISSUES. SOLUTIONS. 15. USER WORKLOAD.
b. ONLINE
QUICK SUMMARIZE COUNT
MEAN(ENQ-TIME) MEAN(DURATION)
MEAN(CMD-TIME) MEAN(ECBS)
MEAN(TOTAL-IO) INTERVAL 10 SECONDS
BY JOBNAME BY TP-TRANS-NAME
WHERE JOBNAME 'CICSPRDA' BY
GLOBAL-USER WHERE JOBNAME 'CICSPRDA'
AND TP-TRANS-NAME 'NATP'
INSIGHT-LINES300
APAS INSIGHT
1
2
3
63
B.THRUPUT ISSUES. SOLUTIONS. 15. USER WORKLOAD.
b. ONLINE
BY JOBNAME
EXAMPLE
MEAN MEAN MEAN MEAN
MEAN CMD ENQTIME DURATION CMD
PST TOT JOB NAME COUNT SECS SECONDS
TIME ECB IO -------- ------ -------- --------
------- ---- ---- CICSPRDA 31,069 0.000021
0.00025 0.00005 3.15 0.01 CICSPRDB 19,533
0.000023 0.00021 0.00005 3.24 0.00 CICSPRDC
3,639 0.000022 0.00046 0.00005 3.79
0.03 CICSPRDD 520 0.000023 0.00089 0.00007
3.63 0.09 CICSPRDE 41 0.000016 0.00107
0.00013 4.68 0.12 CICSPRDF 5,224 0.000020
0.00055 0.00009 3.51 0.05 JOBWXYZ 1,201
0.000033 0.00049 0.00005 4.00 0.02 JOBZYXW
52 0.000880 0.00022 0.00012 3.50 0.50
------ -------- -------- ------- ----
---- 61,341 0.000022 0.00029 0.00005
3.27 0.02
64
B.THRUPUT ISSUES. SOLUTIONS. 15. USER WORKLOAD.
b. ONLINE
EXAMPLE
BY TP-TRANS-NAME
TP MEAN MEAN MEAN MEAN
MEAN TRANS CMD ENQTIME DURATION CMD PST
TOT NAME COUNT SECS SECONDS TIME
ECB IO ----- ------ -------- -------- -------
----- ----- NATP 14,411 0.000022 0.00024
0.00006 2.06 0.03 NATX 123 0.000024
0.00018 0.00007 1.41 0.02 COB1 963 0.000023
0.00045 0.00004 2.54 0.04 COB2 4,072
0.000023 0.00020 0.00009 2.39 0.00

65
B.THRUPUT ISSUES. SOLUTIONS. 15. USER WORKLOAD.
b. ONLINE
EXAMPLE
BY GLOBAL-USER
MEAN MEAN MEAN MEAN
MEAN TERM OR CMD ENQTIME DURATION CMD
PST TOT TRAN ID COUNT SECS SECONDS
TIME ECB IO ------- ----- ---------
--------- -------- ----- ---- CICSD2.K 1407
0.000006 0.00002 0.00002 6.14 0.00 CIC92111
7 0.000011 0.00019 0.00005 3.43
0.00 CICSD1 7 0.000011 0.00018 0.00005
2.86 0.00 CICSD2.K 5 0.000012 0.00079
0.00008 2.60 0.20
66
B.THRUPUT ISSUES. SOLUTIONS. 15. USER WORKLOAD.
b. ONLINE
WHODID EXTRACT TIME JOBNAME
TP-TRANS-NAME NAT-LOGON NAT-PROGRAM
(HD'PROGRAM') CID (PFH8)
CMD FILE (PFN3) ISN (PFN8)
RESPONSE-CODE (HD'RSP','CD ') DURATION
TOTAL-IO (PFN2) L3-SEQUENCE
(PFA2) COPT1 COPT2 ISNQ (PFN4)
SUB-CODE (HD'RSP','SUB') WHERE
GLOBAL-USER ' ' INSIGHT-LINES 300
APAS INSIGHT
67
B.THRUPUT ISSUES. SOLUTIONS. 15. USER WORKLOAD.
b. ONLINE
EXAMPLE
C
C C M FIL
RSP DURAT TOT L3 O O TIME PROGRAM CID
D NUM ISN CD SECS IO SEQ 1 2 ------
-------- -------- -- --- ------- --- ----- ---
--- - - 175059 NATPXTNB 07500301 L3 21 114,512
0 0.000 0 TS . V 175059 NATPXTNB 07500301 RC
0 0 0 0.000 0 .. S I 175059 NATPXTNB
07500301 L3 21 114,512 0 0.000 0 TS .
V 175059 NATPXTNB 07500301 RC 0 0 0
0.000 0 .. S I 175059 NATPXTNB 07500301 L3 21
114,512 0 0.000 0 TS . V 175059 NATPXTNB
07500301 RC 0 0 0 0.000 0 .. S
I 175059 NATPXTNB 07500301 L3 21 114,512 0
0.000 0 TS . V 175059 NATPXTNB 07500301 RC 0
0 0 0.000 0 .. S I 175059 NATPXTNB
07500301 L3 21 114,512 0 0.000 0 TS .
V 175059 NATPXTNB 07500301 RC 0 0 0
0.000 0 .. S I 175059 NATPXTNB 07500301 L3 21
114,512 0 0.000 0 TS . V 175059 NATPXTNB
07500301 RC 0 0 0 0.000 0 .. S I

68
B.THRUPUT ISSUES. SOLUTIONS.
16. NEW DATABASE VS. SMP.
WHAT SMP SOLVES
WHAT SMP DOES NOT SOLVE
THRUPUT
1. CPU (10-15 INCREASE)?

2. IO (LOSS OF CACHING
200 INCREASE)
3. SVC DEPENDENCY
(CONVERSIONS)
69
B.THRUPUT ISSUES. SOLUTIONS.
16. NEW DATABASE VS. SMP.
POINTS TO CONSIDER BEFORE SMP -
OTHER ADABAS TUNING (THIS DOC) -
CURRENT / PLANNED CPU UPGRADES -
MAX OF CURRENT ARCHITECTURE

CMDS / SEC vs. CMDS / SEC OF CPU
70
B.THRUPUT ISSUES. SOLUTIONS. 16. NEW DATABASE
VS.SMP. WHEN TO UN-SMP
71
B.THRUPUT ISSUES. SOLUTIONS. 16. NEW DATABASE
VS.SMP. WHEN TO UN-SMP
72
B.THRUPUT ISSUES. SOLUTIONS. 16. NEW DATABASE
VS.SMP. WHEN TO UN-SMP
SMP QTR HR CPU SECS USED
100
900
73
B.THRUPUT ISSUES. SOLUTIONS. 16. NEW DATABASE
VS.SMP. WHEN TO UN-SMP BEFORE / AFTER
DB QTR HR CPU SECS USED
NON-SMP
74
(No Transcript)
75
B.THRUPUT ISSUES. SOLUTIONS. 16. NEW DATABASE
VS.SMP. WHEN TO UN-SMP ADARUN CHANGES
76
B.THRUPUT ISSUES. SOLUTIONS.
17. SEE CPU ISSUES. 18. SEE IO ISSUES.