ࡱ> `!OBCnJ\l3V"@v @Sx3xUk`ѴUu Ðl-(ZiC* Mpl"8e^/* _ xMvW&i6ż<ɓ_7 He  bYRa7n8S I~YHs7)a;*30)LLZ.C@j}ղYZgƪ/XpsoLghˉ;ُU L܀M5ų;?tWW׭ĺIj*%zLS50-^R3g9Y6f.-Y9˖ฎVWB 949ixv4::%*ۯD=Ӱ}>by2y2Q/'dbgl(zA V0͘#h ,(.^ UşbWER5 ؕztӛusqE՞bwBAHSIdR XLU۱lxlI!R-j.qi|=,kpwkxq %K2q}K|tFNXGsGb"9^q,nǑ,Gxv#Y~5]Ƙh) xM&Dz,wNGm~?ޠ1fgN?V:5G#+d`㺅G#*[(q;b?GGxLDu}۠&ɛ]$mpВpZf"iy+ w4iV\w//_uDdgYk)"ƽ\B`= M${1EP <\gyE|r#y-ЕzRXZk$(?dxcL{ĝ1Eq~Y.[`Qֻ+>uEԴEu]wZw[_* ^-!K'u]kMB^rMf.&PR.a,6b&ߧ5xh2I~:},zL >. E=qDˢ3Y%biq d}Tc t$Q'CёF,f"IVQw`_#!#Ӕ(By߬icUjMܧq<2koA]8r$~gZZT6pSh~m#,K ie}*"IzsW-ݮ }F4Af﹠_ ]7iEeLjd{&[kEɿ_pfkmfI$BU8pqd6@c 8WӛPC#83|&%p8 @,HƘyk[D#B2H$I蠀+#TDH%'HJBeY闀#,aP=tdAIk.ΑEq$7LR/`gdBȽn8UMœVnq#O\&`zVeYO Ol݊N$Hgn,'*lжqゾ@ߒW5!zuBlc !q!+x0+7qo Yqd5G 5_q4ra+*G*4Gdth3E#|]#M.őgKSq,FJ5G"B!8B@;q,@j :*"DYaPh# $qA&=A&7DA"+_ ]Gx pBקZB#㗧}oIENDB``!]n̖HB$ (ř(D9xXnF^d)Fe7jJPk2LRCi¶ 赂Ld)躾   rY@CТ(z. wwIKR-'rC۝of)<(ea,q'01^olۭ~owXtKIW+y(K]I?&H!3P^HT Es }فGGae˞T"n)QJURY"wfg5q]gwkuݲl m7YI$0Jr`_Kyu sk_I2&D25xíl7]&|vo|R[!EpDz0. 0JahbVat{c_WdI67!{%)Ʋ}%5?ls~E݂4&?'7cxF:}oٺ8vk|?u,a]&8swq7g9v$8cقsm?U7"52c  ߁cg{D>-N|kTM߽Cl 4؂gRo_Vg#ٞaW%)籓7(ґ[O7jKܿ^SQ_EA5RrOFLG:\.r@hhoWJ +PۯS"[])rEK&}[G$]o*\)28fnQHdQdC{qntԿ`L9,M5¿yhd@3*"a\Ž=hErm|!nGwUgzM_!ɑ JETMvv!>ϾMƣƙE.j4'DC; 4 p4yIhat)Z=kWiKMk4aB]+ksф> QgcȐgH ,h]t<#{F}@IBE UnuȐ{]'(vDWR#D*ʂsɐ/WGƉyR0)SǼ):{'<ŵ};w4gBVn΂w+ )H$PNG  IHDRPO5|gAMAPLTEech-0/`OآSpQ΄* U-i.ucKuA|reI⹑ˏװ϶Ъm'! pHYs.>NIDATxZqAEEI oIl{2=*e}~y 0_O-_s/TNCk5`.u5U&bŻq8`l@$5cc06͹8B"0?s4ZKenp\RXjO O+z*^J /{bK썍t5^|m拡 4dc#t'-;?zŋ.(v/vpHGB0kLrK7"DqT5Wk]Vmv)odᙡR4jaa[h}<- : *jUx@*&5nEf;DR@0:0J3hʻ0 o:lXڵ x2Ř p`z{gixzġ JPHD1?/*+ORfNj\"TXY'`8ć9×85^_P@D4 WmpxB&!^Ҕg%V7c"/EI2^W=4=JRdyKpEr &%coJ`pV早[J:|l)MW;](v4tn= F9s0߀Fޕ mz H9wDV#/߻9,\/E11` QKiCrpdR;(e=b$&3Z2{a{bzW?]֞1$"DN3o 0iц-wr/u0FB&;̗9 ;f<L]jQfzuQP";EWʅ6Su ~dqwy'^PW^\ 0bk0WI/<`KU\vXdl9fZY]x :aLxP(5O2e9Ym)ʅ23dAa-:,[@fe8štS'm$("W%W\99kow9X |Gtlw#Z9yϫ>m}IUbRsYQ\vI|Y,{z xW#\%2K@+I`*s"y+8|d`;M)Ћy:VΔС=oEi]ٛ#eS]Sߞf+6 ځ!j)W@oz^LIK<%s;G^u0XJ75\k&NDQz~Ytm.Y-;+X0a@N6As_P [T:BLݾEv#~ӷ`ݮ0V=8w\ʚ:凳С4A~6Ă擥טFdƒ4&[Ij: =g/:ԋ  !`"Cһ]re7Of, qqYD:Hע-ٮӟ;F.L kh9kaUPPUJ̝tZ`\:k(L!ȭ3^r!vՔD-jiP87z/9-<7eTr4`$hG$x|q)#x 4]](*o@ aeWLHw@ N޻Q5|/H8ͽBtXӵ)@sCDo~spf%p( 1)ih:/j_]aNRTiz^$J=ƺ|'+{N݆[ xD:~*$&=z`5cn+Jj4ڝIkg`$ Q]nL'TI6Eކ~P#MR!WLD_ù@Άi6ZN2B8ڄ_6>dm>!q 1C*mzBNʷTR#X{nށ'?D>;}m?AM'L[Ȳ(&G&k{#ڟ5_ q؃ C4$1(~,.äJLN;2j{QvբUx9ѿ:i%ML*__ q٣oU}v\;4El[i@ŧp~^?eܙn2#`9D0Sg }.H5;R䣝ׯ̀9nn+1]mˋw<-~=@ʎӘMe):(PMG52 8ryrQ\1mOY\NJ7\u_uxo>\ Bôx-Ūh?`dgG ${gH3Z ws.V[X_P--ljرVhbC=}g0vGAbM4 Fj{Uiy̞G[+#^ZϏBen,h;Ye1LVIENDB``!-V҈.\\x (ř(D9xXoF? ]dFCm0AT&&%Ci3Q,ԇ>lJ*q >q}˦{wg ivwο}Cq" ZR~}DcR;\Bf 0/U>A[/W3  +)|?0BD?q%i ľYH]حn=25G~]P!m+@A_c: ̅>mԇ=њ-xuo MhYMde||&2랗=υ{flXAÿ-FOОзKԖ,ͯO΀,8$L@prfs~wGYG90JE^6AEDYD4gk>6>baO!z?grA,d_d~>!Y>=q\zicE#m&LٱE6wABY'$9~uX6Հ:h"* ~80l gfh5MwOg>z{CmggHox /p厘zzl]Ȅ:Sg4IXPcjkrM^=r=x^"i_e Ђ rH0Ȯ})Yg&Z3h|W,=t?2 qrX{ؕ YH .xîLG0ozN58ԉ1T4xxlb+@> 'F}dc' Ec~FC9dSzi11y^.qIc',WѼyw r.YFpA>D}l2=0/~ljX6y9Ioiq9CNK)BEL{"Iq]8Slqeڅf{@{!GjfRsxk{=i"0qIQDfqhб6ck[:(OX_uY(0L=^ϖ0Sf S3m`s-8Cs9Cs33h![@shshK=K=Bhh< h![@s4 <[hбc[h^@b{ 4?5p/WGW%vf8Z G_{j"]E4%EɖPQ Bsts4.{{%B[q(K[.e-dKhn99:nBKBhix4"4niskFk%]dԸBXFl^]B8`p%Cgl#dl~xk},,qfE+:2!+<Ezޗ];e3' R~Mϯd=]YZnFGTG &UGgN;zꭙߺó'ߝ9})2@*Hv~/67 +GU\K]X_Q,[ dđ#6ydmOgZO1@X[ѯl4LlRDqd|g ^<>!\-coLJ,LVR1# !R1}!R̈́n@dŁݵz)e1LNզFpݩN&2LO}~C벂-GLeD^@&߽TWLWcZ[yUf(fFg/gglVќ2Pa# %>g{KffSveT#8\"Dk"X u]H7@ sVjG+w0<)\2Gs+=# ;408.XŒNb { Ft N;UމxGVJ.[CN.QjQWaHt߂ o+֒P @&ˠR|X$r| 9|p+QΙV1U6;!d5 %ϖ,]R(K8"<+_S_WЂFy]z3~gG+dcx2~|.*2cIL)5׭ՃqYaݧxUW}|%dDh00Dw'{z#l;`:+agr 7C~㘿|J,frdݝ W~F0[~ú*U;Ù\Azj[ و^W/^F}.4W|3nY[TO&SwRWA-CɗQ3yEE[Ù\e]$sv4AV1k~G:EXH9c5sk{̜Iz

aӲm1m1-ۦq=(Ebb/!l k[UAEoݚcx@,:[|-u9#[(:[S 82`$ S[ 8lh$z'xV!bpd~ u]w*w}rkkwZ(}"v$ɽjNajU SkU=~JS#Q@Bglouߎ}[սߤaIl/YfQ1|rNK&eUoPˏ&ˏںGv/B5rI`G0{PP$31V{+)iS+`x`D|Yaڹg|/F=fH{Z2>w:'iŐ`Di:h!oHΎd3,ӎޣY;4bOo䝦wwQ Mcif44|)a A X{T[4 jz!؈>?U>i:_ U[lv\uٌfk\ĈM#7cb s#cȝ\SS^i: #mKA2cmgvn:zdӀg݃=hz:t4V}S;R Udm,F ppL ƙEl_!K`!W|zl'K_VF)xKQǟ׳)"YJi F/AAD]" .G!_daW^Ώw͝wyjA"u pH//kw b/F3`vG::!IBŬ dئz%HȢ Qp BTv ֟Y*ח{K_q}dqR]%N羚XibZyg6흛eSUgVثثؖS&M['m2*#X" 5̄tG3!eofDUQ==sLS370s 1M&œ I\ 50#c!a*zόwyR|< _0rzf2IdR2޸e^+ɤaLj׊ibZEPNJZLGbp"mTӒ iUZ69,0~~V]qb:s Wi;|4 qL:|8Ӕsit6LSXwcrG N(349s#t9GSi=:u)ku1RNiOL6U)T6U)V%yDP4~f1Ǡsiʙ0"czO7;w=~SgG0+fŶ*K$k<ا_Êx69X#YGam)(Tل0<%=GsfE1x+pGĠa׊ :u > H;]yЗחu*-7V+^=ȏnT$~Fkuk;f.Axe_^3t 6]ǭxMۏHfls+<%v+^={nӵ}x]k= ~(z   | w 0JbDocument Word.Document.80.Microsoft Word Document0KbDocument Word.Document.80.Microsoft Word Document0bDocument Word.Document.80.Microsoft Word Document0bDocument Word.Document.80.Microsoft Word Document00bDocument Word.Document.80.Microsoft Word Document/0(  0;[0 0 000$([\{b00 000000000  0=] 0 0 0000 2 3 !A0C0E0G0I0c00000000000000000!%),.:;?]}acdeghijklmnop`DTimes New Roman8b8bDb0hbhb~0DArialNew Roman8b8bDb0hbhb~0" DWingdingsRoman8b8bDb0hbhb~00DCourier Newman8b8bDb0hbhb~01@DArial Blackman8b8bDb0hbhb~0"PDTimesNewRomanPS8b8bDb0hbhb~0`DHelvNewRomanPS8b8bDb0hbhb~0pDSymbolwRomanPS8b8bDb0hbhb~0@  @@`` @n?" dd@  @@`` ` Ic6G   !C Z /) C$ G%< 21~,D?#F+%//))  f !ff" 67?F>!< 5 # (T  CBTABT J'U z,{T }~YWN+ + O    "T WW"PR%O@ L EL8`D.\U [//]0^ 'F"K)J GJ H#<=  *I7 842gC38]5gVs_E68#EaKC)W*2NZ/2$BCnJ\l3V"@W9b$9)wߪ˺W92$]n̖HB$)9b$΂w+ )H$(92$-V҈.\\x*9$9$9$9$9$9$9$9$9$9$9$92$~9Y̖ 092$W|zl'K_ <9c $_ж_ж     A@  A1 8c8c     ?1 d0u0@Ty2 NP'p<'pA)BCD|E|| M dx<@8  g4KdKdtb~0lbf$ dpp<4ddddY8bL9g4ddddtb~0lb ^p p<4!d!dY8b :2___PPT9/ 0? -O =Rm2+Adabas Performance with Adabas v71 Features,+( , .Pacific Southwestern User Group March 19, 2002/. /  Introduction" (5  Old New Borrowed Bluex  M ADABAS v7.1" (5  KPerformance the old fashioned way Reduce I/O Reduce/Eliminate ADABAS CallsL"x*x!<" L + ADABAS v7.1" (5  Data Base Basics Associator - contains indices and control info Data Storage - contains compressed records Work - contains protection info and miscellaneous8xx  ( ADABAS v7.1" (5  7Back to the Basics ADABAS Calls Control Block 5 Buffers8x%x% 8 5ADABAS Architecture Overview  9ADABAS Architecture Overview  HAssociator Control Blocks for the DB/Files Inverted Lists of Descriptors$ > > !  % ;@:ADABAS Architecture Overview   Data Storage  6ADABAS Architecture Overview  2Data Storage (continued) Records Files ISNs Fields$ 3 ,ADABAS 7.1 - OVERHEAD  )ADABAS v7.1 - OVERHEAD"(5  ]Overhead per ADABAS call Systems Communication Buffer Movement Nucleus Processing Perhaps I/O8xExE ^ 8' ADABAS v7.1" (5  -So - First Way to Reduce Overhead Reduce I/OD"x x! < . R ADABAS v7.1" (5  BPerformance Forward Index Compression AND IT IS FREE ! ! !D x7x < C L%Adabas v71: Forward Index Compression6    M&Adabas v71: Forward Index Compression& KAnother example: Superdescriptor consisting of make, model and year (DL,  %  Y&Adabas v71: Forward Index Compression& hFile Level ONLY! May reduce # Index levels FIC within single block only 1st value always stored in full &i Y i N &Adabas v71: Forward Index Compression& O &Adabas v71: Forward Index Compression& SSignificant space reduction Depends on descriptor specifics. Sample results below..87 7 P &Adabas v71: Forward Index Compression& Q &Adabas v71: Forward Index Compression& R 'Adabas v71: Forward Index Compression ' YDO IT! any reasons not to??? No measurable CPU Set at file level Cannot be set with ONLINE REORDER Average space savings is 40-50% How to tell how much is saved? Run ADAORD 2x Use DDFILEA stats and ADAREP Fewer ASSO Reads/Writes Better buffer efficiency ADACSH; NI/UI blocks better candidates L3/L9/S1 commands are faster Fewer Index levels $" !+ Mu#! !*u    X&Adabas v71: Forward Index Compression& Run usual ADAORD to eliminate the Unused-Rabn Chain and repack the blocks with padding factor Track the used NI/UI RABNS Run ADAORD again with Indexcompression on Note the new used NI/UI RABNS 2 runs of ADAORD - ugh!!!6*  b  <    \&Adabas v71: Forward Index Compression&    ~Index compression is done when the NI elements are being written FROM DDFILEA (and NOT to DDFILEA) So, look at the bytes used on DDFILEA and the resultant blocks written DDFILEA bytes = LRECL * ((EXCPBCKT - 1) /2)) After FIC completes, run ADAREP & add all used UI/NI blocks New bytes = Used-Asso-Rabns * Asso-Blocksize Savings percentage = (New bytes) / (DDFILEA bytes) Geeky way! Jx$         3   S'Adabas v71: Forward Index Compression ' xCustomer results: University of Arkansas Production w/v712 In cyl. Before After Savings Percentage ADAPROD 3,200 1,400 1,800 56% ADASIS1 11,000 4,234 6,766 61% Cartridges required to backup the data base Before After ADAPROD 16 14 ADASIS1 45 37 ),d)-d ?  7 T'Adabas v71: Forward Index Compression ' Customer results: University of Arkansas Production w/v712 ADADB1 Before After Commands 128,171,534 140,703,793 Asso Reads 1,777,290 1,539,641 Asso Writes 112,301 108,051 Buffer Eff. 48.0 52.0 ADADB2 Before After Commands 280,018,872 361,005,811 Asso Reads 11,173,438 6,503,484 Asso Writes 236,117 153,317 Buffer Eff. 54.0 70.0 T))  '      k  '  ,   W'Adabas v71: Forward Index Compression ' Customer results: Commonwealth of Mass: recovered 11,099 cylinders (58%) of Associator space due to the reorganization which implemented Forward Index Compression. Curtis Circulation: Normal and Upper Indices have been reduced typically by 50 to 80%. Files that were too large to cache before are now cacheable. University of Texas: w/ FIC Buffer efficiency 641.1 Asso Reads 5,560 w/o FIC Buffer efficiency 250.5 Asso Reads 14,268 ?g|f6s  /   j!Adabas v71: I/O Summary Overall Adabas CPU usage is reduced by an average of 10-20% Without FIC 5-10% reduction in I/Os to LBP With FIC 20-30% reduction in I/Os to LBP     k"Adabas v71: User Results pQuotes from emails: 7-15% reduction in CPU with about a 5% reduction in ASSO I/O when doing Read Logical and Finds. This is related to the improvements to the improvement in how the buffer chooses the replacement victims. (Not using FIC) With version 622 we used 17:54 CPU hours to process 119 million commands and with 712 we used 12:40 to process 115 million. I also noticed that the IOSQ time of our DASD went down dramatically. I have 7 production databases. CPU savings from v712 are: 7.6%, 8.7%, 8.9%, 10.8%, 14.7%, 18.6%and 0.01% We have an average of 30% CPU savings on each of 2 databases converted to v71 @]X q l#Adabas v71: More User Results MCustomer states: Database 233 (LBP=360 MB) : V62: 0.43 milliseconds CPU per call or 2334 calls per CPU second internal throughput V71: 0.26 milliseconds CPU per call or 3776 calls per CPU second internal throughput This is a reduction in CPU time of more than 38% and an increase in internal throughput of nearly 62% (!) P;:M  m$Adabas v71: More User Results GSame Customer: Database 15 (LBP=360 MB) : V62: 0.34 milliseconds CPU per call or 2930 calls per CPU second internal throughput V71: 0.23 milliseconds CPU per call or 4289 calls per CPU second internal throughput This is a reduction in CPU time of more than 31% and an increase in internal throughput of more than 46%(9G H "Adabas Buffer Pool  JHolds Associator and Data blocks Size Set by DBA Larger Buffer = Less I/O  K %Look Ahead : 64-bit Overview - V7.1.3 & 64-bit Real Storage OS/390 V2R10 and z/OS 1.1 Max. 128 GB Real Storage (temporarily) 2 GB size limitation for allocation 64-bit Virtual Storage z/OS 1.2 2 GB size limitation removed data caches only other structures in later versions of z/OSZeb3 %b  OI/O Buffer Pool (LBP)  Descriptor usage Use fewer descriptors in search Re-order file by most-used descriptor Typical size Small DB: 5MB Medium DB: 10-20MB Large DB: 30-50MB Very Large DB: 70+MBPF HF H  NASSO/DATA Block Sizes  Various block sizes waste various amounts of LBP? LBP is divided into 256 byte slots Assume 3390 device: ASSO block size 2544 2544 / 256 = 10 slots 1,000,000 / 2544 = 394 * 10 = 3940 * 256 = 1,008,640 bytes in LBP Assume 8392 device: ASSO block size 4092 4092 / 256 = 16 slots 1,000,000 / 4092 = 245 * 16 = 3920 * 256 = 1,003,520 bytes in LBP Conclusion Larger block sizes save very little in the buffer pool EXERCISE FOR THE USER !2LX)X]2LX)X R  PAdabas Caching Facility  A buffer in addition to the Adabas buffer pool -  Read Only For selectable data User-specific - RABNs User specified file(s) WORK parts 2 and 3 Cache buffer location Extended memory Data space Hiperspace (depending on operating system) CBUFNO=n Read ahead to end of track Affects L2/L5, L3/L6, L9, and S1 (non-DE search)TAF LTAFL d   & Advantages  BLarger Cache results in less I/Os More space in the 31-bit area  C S ADABAS v7.1" (5  @So - Second Way to Reduce Overhead Reduce/Eliminate ADABAS CallsD#xx"< A 0 ADABAS v7.1" (5  YHOW TO REDUCE ADABAS CALLS FastPath Prefetch / Multifetch Change Programs Add New Keys 8x?x? W   - ADABAS v7.1" (5  HOW TO REDUCE ADABAS CALLS W I T H O U T CHANGING PROGRAMS ! FastPath - A data buffering approach Prefetch / Multifetch - A read ahead approach 8@xVx?V  3ADABAS v7.1 - FastPath"(5  FastPath uses its own buffer to hold data and control information. FastPath can be monitored on-line Parameters control what FastPath optimizes 2xx  4ADABAS v7.1 - FastPath"(5  FastPath has many displays available to show what is being optimized and the savings Some parameters can be modified on-line while FastPath is active 2xx  2Adabas Fastpath Statistics   EFASTPATH - normal look up      FD&Adabas Fastpath Statistics - Aha !  GFASTPATH - WHY ?     JADABAS facilities    AFastpath Hints  1How to determine which files to Fastpath. Determine top ten files per physical Database. Fastpath ten files - but watch out for update activity. Monitor for week to make sure resources are adequate. Add files until all resources consumed or there are no more high volume files to fastpath F*-*N   @       CFastpath Hints  Reasons Commands may be excluded from a File Insufficient CID/User Areas. ADABAS / File processing is stopped. A Job step is running that has "Prefetch" parameters. The "Command / Descriptor" is not defined in the file Parameters Record Buffer Length / Set ID Length Exceeded Set ID Length = Search Buffer + Format Buffer field length values + other factors. Minimum Sequential Storage (k) exceeded. FAPP,,    B%!ADABAS PREFETCH/MULTIFETCH- Batch " kUses a Read Ahead approach Needs a Buffer on the User Side Controlled by ADARUN parameters Very Easy to Usel 5wlQ ?!ADABAS PREFETCH/MULTIFETCH- Batch " PREFETCH=OLD for Prefetch PREFETCH=NEW for Multifetch PREFSBL=nnnn for setting work area size PREFXFIL=nn and PREFXCMD used in pairs to exclude a file/command from Prefetch 5w =!ADABAS PREFETCH/MULTIFETCH- Batch " PREFETCH Brings Back ALL of the Prefetched Data in the ISN Buffer - with a 16 byte header for each Record returned MULTIFETCH Brings back the Records in the Record Buffer without any separation - The 16 byte headers are returned in the ISN Buffer 5w >"ADABAS PREFETCH/MULTIFETCH- Online # VERY SPECIAL CASE VERY DETAILED CODING INVOLVED BYTE SHIFTING/MOVING REQUIRED BUT CAN BE VERY REWARDING In NATURAL you can use the USR1043N ENTRY POINT for ADABAS Direct Calls !  5w Q Monitoring   CPU utilization ADANC7: Format translations ADANC2: Command execution (L1, etc.) ADANC8: Compression/decompression Monitoring packages Provide valuable information Can use considerable CPU cycles and I/OPcEcE  <Converting to V7  What Gets Converted GCB Version; XGCBSTAT=x C7 DSECT changes FCB DSECT changes new fields (YIVDE initialized) FST Blocks 10-14 Blocks 11-14 formatted WORK formatted PLOG formattedN 5w,3$ & THE END  Until Next Time !  /p |),0V|}~Pb ` ̙33` ` ff3333f` 333MMM` f` f` 3` >?" dZ R?ndRdlPIndX%  P5 r?" dd@%   @@``@n?" dd@  @@``PP   @ ` `0p>> 3 +  (  |  TZ?? 9 |  TZ??{ |  TZ??c K  ZYxaxa1 ? Y ]Firstlevel: Arial bold, 24 point Second level: Arial, 24 point Third level: Arial, 20 point ! ^    `TYxaxa1 ?0 Y a-Headline, Arial bold, 32 point 2 lines max. . .^B  6DR?|  TZ?M? iF P   P   # lZ?Md1?``   0?P`   0R?`   HY? ?0~ Y *.(l2    8Xh^  6A1?y@?f  S ~Y_ж_ж 1?3 pPacific Southwestern User Group Meeting  March 19, 20029 29  9 B  s *޽h ? R  sag_template.ppt   0d(     `8xaxa1 ? Q V Click to edit Master title style! ! ~F  9      TZ?? 9   TZ?? {  TZ?? c  TZ?M? i^B  6DR?   Hĵ81 ?H   Q Y#Click to edit Master subtitle style$ $ F P   P   # lZ?Md1?``   0?P`   0R?`  Hd8? ?0~ Q *.(l2    8Xh^  6A1?y@?B  s *޽h ? 2 0 P(    # l8 8c?  Q a*     # l$8 8c? z Q c*   v  6 ?;@  QT  # lĸ8 8c?x U%b Q RClick to edit Master text styles Second level Third level Fourth level Fifth level!     S   # ld8 8c?   Q a*     # l8 8c? z  Q c*   H  0xl>L ? ̙33 @ 0(   B  s *xl>L ? a(   d$( p  d  d Z8xaxa1 ?` P tDavid Del Rio (_ r  d S D8  Q l d C 8 pP  Q H d 0޽h ? ̙33  | `J(  x  c $E80  <   S E8  < ,@h8H  0޽h ? A|o^U    pp J(  p x p c $4E80  <  p S D8  < ,@h8H p 0޽h ? A|o^U    x J(  x x x c $tD80  <  x S D8  < ,@h8H x 0޽h ? A|o^U    ` J(  ` x ` c $TC80  <  ` S B8  < ,@h8H ` 0޽h ? A|o^U   VN&& (     C xB8xaxa1 ?0  <   ZA8xaxa1?@P p gADABAS Nucleus *  XB  01? E\ XB  01? U <XB  01?e <XB  01?@@XB  01?U <6 ^  61? @ ^  61? ^  61?@ ` ^2  61? p ^  61? p ^  61?  ^2  61? 0 ^2  61?p p ^  61? p ^  61?`  ^  61?  ^2  61?  ^2  61?0  ^2  61? p0 ^  61? ` P ^2  61? ` P ^  61?@ ` ^2  61? p ^  61? P @ ^2  61?p P @ ^  61? p ^2  61? p ^  61?0 P ^2  61? `  ! ZA8xaxa1?4 iZ V Data Storage      " TK8xaxa1?   R Associator     # Z4K8xaxa1?-  LWork    $ ZtJ8xaxa1? * XProtection Log    % ZI8xaxa1?}  d Command Log *       & ZH8xaxa1?@P 0  cI/O Buffer Pool&  H  0޽h ? f3f3E    m(     C xH8xaxa1 ?0  :   C x4H8xaxa1 ? :   ZtG8xaxa1? P `  bInverted Lists for Files    ZF8xaxa1?P @  VControl Blocks  ^B  61?  ^B  61? \   Zxaxa1? P   uAddress Converters for Files *  ^B  61?P  P ^  61?  ^2  61?`  ^  61? `  ^2  61? `    TDxaxa1? -S  \ Associator "    H  0޽h ? f3f3  6(     Zxaxa1? dADABAS Architecture Overview,  x  Txaxa1?@` JAssociator (continued) Control Blocks for Files File Control Block (FCB) f%       K ^  61?  ^2  61?`  ^  61? `  ^2  61? `    Txaxa1? -S  \ Associator "      Z$xaxa̙1?   W FCB - File 16  ^B  61?@ U@   Zdxaxa̙1?  p W FCB - File 17  ^B  61? U   Zxaxa1? s   E. .  ^B  61?@ U @ ^B  61? U  ^  61? ``  ZDxaxa1? ` mRABN RABN RABN RABN "    XB  01? XB  01? 00XB  01? ^  61? `0   Zxaxa1? `  p*Field Field Field Field++  + XB  01?  XB  01? 00 XB  01?    Zxaxa1? -  OFile 17    Z$xaxa1? -g  OFile 16  H  0޽h ? f3f3 aY)) (     Zdxaxa1? dADABAS Architecture Overview,  :  Txaxa1?@` :Associator (continued) Inverted Lists of Descriptor values8% $   $ ; ^B  61?@ 5@ ^  61?` pXB  01?e  XB  01?U P P   TDxaxa1?} M h 0  K301   XB   01?U @ @    Zxaxa1?} m 0  MBrown   XB   01?U    Zxaxa1?} 0  K301   XB   01?U   Z$xaxa1?} 0  NCooper     Zdxaxa1?}  (  Q Applegate    XB  01?U    Zxaxa1?} 0  K302   XB  01?U  XB  01?U    Zxaxa1? =O  l Applegate 4       XB  01?e P P    TD"xaxa1? } ' @  I4   XB  01?e @ @    Z&xaxa1? m ?@  X3, 23, 56, 1296   XB  01?e @@   Zd&xaxa1? =@  MBrown   XB  01?e    T&xaxa1? g8  I3   XB  01?e    Z$$xaxa1? 8  R 7, 89, 231    XB  01? | XB   01?e  XB ! 01?   " Zd#xaxa1?M  Q Block 301     # Z"xaxa1?   Q Block 200     $ ZD(xaxa1?d >  ]Inverted List - Last-Name  ^ % 61? P ^2 & 61?` P ^ ' 61? ` ^2 ( 61? `  ) T'xaxa1? m  \ Associator "    H  0޽h ? f3f3?      g (     C xd xaxa1 ?0  8   C x!xaxa1 ? 8 ^  6f1?L < ^2  61? @x ^  6f1? xl^2  61? x }  Z!xaxa1?&o  {- Compressed data records on blocks called RABNs (Blocks) - Stored on DASD in physical extents - Contains up to 5000 files4|M +  K   T xaxa1?   ZData Storage      Zdxaxa1?   XCustomers File    Z$xaxa1?   VEmployees File  ^B  61?  ^B  61?p  p   Zxaxa1? s l \. . . (   H  0޽h ? f3f3  !! ( @    C xxaxa1 ?0  8   C xDxaxa1 ? 8 ^  61?  6  Z xaxa1?0 P  FData Record Data Record Data Record Data Record Data Record8G   !  G (  Zxaxa̙1?   HISN Field Field Field Field Field Field Field(I F  I   Z$xaxa1?  0 BLOCK BLOCK BLOCK BLOCK 21 *   1 XB  01? XB  01?0 0 XB  01?@@   Z xaxa1?CG ~ NFILE 7  XB  01? %4 XB  01? ,4 XB  01? , XB  01? 00 XB  01? ,T XB  01?5 L XB  01?5 0 0 L XB  01?5 L XB  01?5 L XB  01? < 4 XB  01? 5 4 XB  01? 4 XB  01? \4 ^B  61?  ^B  61?U XB  01? XB  01?@@XB  01?``XB  01?XB  01?XB  01?  XB ! 01?ppH  0޽h ? f3f3,   l(   l  C T 0  8    c _ж_жA ? 1?P  H  0޽h ? R   h J(  h x h c $0  8  h S   8 ,@h8H h 0޽h ? A|o^U    X(      `4xaxa1 ?-| N(ADABAS Mainframe Command Path Overview  ) XB  01?lXB  01?YXB  01?pYpXB  01?]]lXB  01?YXB  01?lXB  01?M M lXB  01?==ldB  <1?}}^B  61?^  61? i ^B  61?q dB  <1?^  61?lXB  01?    Zxaxa1?s kLw  UOnline Natural    Z!xaxa1?Q*  R Link Routine      T!xaxa1?p  ISVC   ^  61?AYl  Z"xaxa1?#  /  TADABAS Nucleus  XB  01?  T"xaxa1? HCICS  XB  01?AY  TT#xaxa1?:`  S   ^  61?Q 9   T#xaxa1?J   U Natural Batch  ^  61?I l^  61? Q 9lH  0޽h ? f3f3   0X J(  X x X c $t$0  8  X S    ,@h8H X 0޽h ? A|o^U    @ J(    x  c $$0     S 4%   ,@h8H  0޽h ? A|o^U 5  Pl ](  l j l B2?P X@^ l 6? R l s * x l c $% x    l <a  f0AA12341 AA127899 AA1399 AB111 AB11111 AC0001 :11 l <% a  G7 AA12341 8 AA127899 6 AA1399 5 AB111 7 AB11111 6 AC0001 :H     l <& "    XB  l 0D   l <' v  Z Index Values    l < #  wStandard Compression$  v  l  `xaxa 1? 9,$D 0 Can be activated via ADALOD/ADAORD: INDEXCOMPRESSION Forward Compression in Normal Index and Upper Index Less storage required in Buffer Pool and ASSO Less I/Os Performance increase for applications 0%z 9   l   ,$D 0 l  <t3?` @  ` l  0A?0_ l  <r: E8 0 AA12341 5 4 7899 4 3 399 5 1 B111 3 5 11 6 1 C0001 :F `B l  0DHH l  <Ds:  Forward Index Compression6 fB l  6D l   `t:xaxa 1?91   i'Storing redundant prefix via count byte(( ( l 6dt:i 6@@ 00 9FCB H l 0޽h ? ̙33m     ` t (  t x t c $$u:P   r t S u:!     t <Dv: W  Standard Compression 104 bytes6!  ^  t 6? l   t <v:    R 26 CHYRSLERTOWNANDCOUNTRY1998 26 CHYRSLERTOWNANDCOUNTRY1999 26 CHYRSLERTOWNANDCOUNTRY2000 26 CHYRSLERTOWNANDCOUNTRY2001 :          ^ t 6? l  t <w:   9q 26 0 CHYRSLERTOWNANDCOUNTRY1998 2 25 9 5 22 2000 2 25 1 :r  ,       g XB t 0D  l XB t 0D l  t <dw: p 0Forward Index Compression 40 bytes 61% savings61"XB t 0Dl H t 0޽h ? ̙33  p *(   x  c $$x:0   r  S x:!  H  0޽h ? ̙33  x 0(  x x x c $Dy:0   x x  <A ??(8 H x 0޽h ? ̙33  bZ| (   | R | s *kx | c $z:0   ` |  c $A ??E x | c $dz:    H | 0޽h ? ̙33[    ( @  x  c $${:0   r  <{:1?5   EMPLOYEE file-Adabas v7 DESCRIPTOR VALUES ISNS AVG UI BLKS NI BLKS FIC LEN -------------------- ------------ ------- ------- ------------- ------------- ----------- AA (UQ) 1,107 1,107 8 1 7 0% AE 804 1,107 7 1 5 0% AH 922 1,107 4 1 5 0% AJ 307 1,107 10 1 4 0% AO 167 1,107 6 1 3 0% AP 237 1,107 15 1 4 0% AZ 21 1,812 3 1 3 0% H1 259 1,081 4 1 3 0% PH 604 1,107 3 1 4 0% S1 13 1,107 4 1 2 0% S2 1,052 1,107 13 1 9 0% S3 1,567 3,383 13 1 16 0%       E  E  j   hh88i   f{:xaxa? 1?  S* Example taken from Computer Associates International, Inc. Spaceman v3.5 product.,TZR Shh88H  0޽h ? ̙33"   b(   x  c $|:0   9  H}:1?0  EMPLOYEE file-Adabas v7 DESCRIPTOR VALUES ISNS AVG UI BLKS NI BLKS FIC LEN -------------------- ------------ ------- ------- ------------- ------------- ------------ AA (UQ) 1,107 1,107 9 1 5 62% AE 804 1,107 8 1 5 29% AH 922 1,107 5 1 4 45% AJ 307 1,107 11 1 4 19% AO 167 1,107 7 1 3 63% AP 237 1,107 16 1 4 32% AZ 21 1,812 4 1 3 7% H1 259 1,081 5 1 3 51% PH 604 1,107 4 1 4 23% S1 13 1,107 5 1 2 15% S2 1,052 1,107 14 1 6 45% S3 1,567 3,383 14 1 10 72% L  B      hh88i   fd}:xaxa? 1? 2 S* Example taken from Computer Associates International, Inc. Spaceman v3.5 product.,TZR Shh88H  0޽h ? ̙33   *( D2J2$R20V2  x  c $$~:@   r  S :P  H  0޽h ? ׊|o|oUA^ L   (   l  C :0   l  C d:  l  C Ĺ:   H  0޽h ? RX   (   r  S D:0   r  S :P  l  C :(   H  0޽h ? R   *(   x  c $:h   r  S : P  H  0޽h ? ׊|o|oUA^    *( l=ԑ=[LL  x  c $:@   r  S d:@  H  0޽h ? ׊|o|oUA^    *(   x  c $:H   r  S )8@  H  0޽h ? ׊|o|oUA^     *(   x  c $T+80   r  S +8!   H  0޽h ? ̙33  0 *(   x  c $,80   r  S 4-8  H  0޽h ? ̙33  @$ *( ,,Um4 $ x $ c $-80   r $ S -8!   H $ 0޽h ? ̙33  P, *(  , x , c $t/80   r , S /8!   H , 0޽h ? ̙33  `0( 1 x  c $080   x  c $T18  H  0޽h ? R`  p+(  x  c $180   x  c $28P   2   `2838c?0  cLess I/Os = more performance  H  0޽h ? R`   0(   x  c $T480   x  c $48  H  0޽h ? R  x *(  x r x S t58I   x x c $V8  H x 0޽h ? R   0( ##DDDggg  x  c $4W80   x  c $W8  H  0޽h ? R`  <(  ~  s *TX80   ~  s *X8  H  0޽h ?     J(   x  c $Y80     S tY8   ,@h8H  0޽h ? A|o^U     J(  0  x  c $Y80  8   S 4Z8  8 ,@h8H  0޽h ? A|o^U     J(   x  c $Z80  8   S Z8  8 ,@h8H  0޽h ? A|o^U     J( }  x  c $\80  8   S t\8  8 ,@h8H  0޽h ? A|o^U     J( }  x  c $4]80  8   S ]8  8 ,@h8H  0޽h ? A|o^U 6   v( ii  x  c $^80  8    BA ?8c?` .rL 8H  0޽h ? A|o^U    f0 6(  0  0 3 r_8 jJ jJ ?P   8 0 0 Tt_8gֳgֳ?<  DIRECT READ/FIND& READ LOGICAL (L3) FIND, FIND FIRST, FIND UNIQUE (S1, S2) HISTOGRAM (L9) GET (L1) FASTPATH uses a look up techniqueP0ZX0Z"0ZX" f    H 0 0޽h ? D 079 l(  8  8 N4`8 jJ jJ?f fFASTPATH - special    H 8 T`8gֳgֳ?  SEQUENTIAL Process a set of records for both batch and on-line users READ BY ISN (nth in sequence) (L1) READ PHYSICAL (nth in sequence) (L2) READ LOGICAL (nth in sequence) (L3) HISTOGRAM (nth in sequence) (L9) FIND (ISQ > 2) (S1, S2, S8, S9) FASTPATH uses Read Ahead ! !h 0Z<0(Z0Z0Z      H 8 0޽h ? 6  @, v( / , x , c $`80  8  ,  BA ?8c?` .XL 8H , 0޽h ? A|o^U   "Pf@ (  @  @ 3 ra8 jJ jJ ?Pf\    f@ N)gֳgֳ?e .V 80% of accesses to 20% data No need to  preload entire files Challenge is to identify  popular data in  popular formats Constantly re-identify popular data0(Z0Z$0(Z0Z)0(Z0Z%0(Z +  y H @ 0޽h ? X  `77Y ( @ X  X 3 rt) jJ jJ ?pf/    F   X    X  C B C DEF 1?AA=]{{]=]6q{X]C=/\6/CXrqXC/6]/=C]X{r6\@ b X   2BCDEDFL1?'N|sreUA+,BUert|N'#$@< b X   2BCDEDFL1?]|6reUB,qXC/sN'#$@ = b X   2BCDEDFL1?\6/CXqqXC/6]#$@ = b X   2BCDEDFL1?'Nt/CXq+AUer6|\#$@<   X  pBCDEF ?AA|T/ oWlAO.1}V0 .AWopWA. /U|0.PAmWp 0V}1OlmO0|@   X  pBCDEF ?AAuO*m|Uc@G-) zT/ -@UnoWB.*Ou'.FBbW|o /Tz )Gc||bE'u@   X  pBCDEF ?AAoI%lqTX?=- uP+-?UloVA.%Jo.<AXVro+Pu =XrqX;o@   X  pBCDEF ?AAhC|ifRO>5+qM(+>RjoVA.!Ei.2ANVgo~(Mq5~OgfM|1h@   X  pBCDEF ?AAb=pg\QE<++nI&+=QhmU@->c -(@CU\ms&In+rE\\Bp' b@  X  pBCDEF ?AA[w8eQQg<{# iF#{hQm9U@-\9-@UfmP<*#Fi* ;#O<eQ~ew7[@ x| X  pBCDEF ?AAVy,?/TGk]qAdp\1FG.ZkzxU2zk|ZdGN1:)dA):Ndk|T?,4V@ ru X  pBCDEF ?AAPs, >%R>iSfw<_vfS'=<%N _myrP. ym_zNb<L'9)_<)9McizR>, .P@ mm X  pBCDEF ?AAJl+=R3hI\lz7Z{zl\I32CTamv|lJ)|vmaTxCa2K8({Z7(8KahxR=+)J@ he X  pBCtDEF ?AADe+=P(g=P`mx2Stxn`P=(&8GT_hnerDs#rnh_TGv8_&J7'tS2'7J_gvP=+#D@ b] X  pB}CgDEF ?AA>_~*<Oe3}FUcnu z.|NzouncUF4  -<IS[a_e?fea[SI<t-]I 7'oN. &6