IBM 5655-DB2 инструкция обслуживания

Storage Management with DB2 for OS/390 Paolo Bruni, Hans Duerr, Daniel Leplaideur, Steve Wintle Inter national T echn ic al Suppor t Organization SG24-54 62-00 www.redbooks.ibm.com[...]

[...]

In ternat io nal T ec hni cal Su pport Or gani za tion SG24- 546 2-00 Sto rage M anag em ent wit h D B2 f or O S/390 Sep tem ber 1 999[...]

© Copyright Internatio nal Busi ness Machines Cor pora tion 1999. All right s reser ved Note to U.S Governm ent U sers - Docume ntation rel ated to res trict ed r ights - Use, duplic ation o r disclo sure is subj ect to res tr ictions set forth in GSA A DP Schedule C on tract with IBM C or p. Fir st Edi tion (Se ptemb er 1999) Thi s edit ion app l[...]

© Cop yrig ht IBM Corp . 1999 iii Contents Figures .......... ........... ................ ............ ..... x i Ta b l e s ..... ................. ........... ........... ........... x v Preface .... ........... ........... ........... ............ .... x v i i The Team That Wrote This Redbo ok . ....... ...... ....... ............. . x v i i C [...]

iv Storage Mana geme nt with DB 2 for OS/390 3 . 7 O t h e rD B 2D a t aS e t s .... ........... ........... ............ .. 2 2 3 . 7 . 1 D B 2L i b r a r yD a t a S e t s .......... ........... ............ .. 2 2 3 . 7 . 2 D B 2T e m p o r a r y D a t aS e t s ....... ........... .............. 2 2 3 . 8 D B 2 D a t a S e t sN a m i n g C o n v [...]

v 6 . 1 . 2 S M SD a t aC l a s s ....... ........... ........... ........... 4 7 6 . 1 . 3 S M SS t o r a g eC l a s s .......... ........... ............ ..... 4 8 6.1.4 SM S Managem ent Class . ........... ........... ........... 4 9 6.1.5 SM S Storage Groups . . . ..... ........... ............ ..... 5 0 6.1.6 DB2 STOGROUPs and SM S S torage Gr[...]

vi Storage Mana geme nt with DB 2 for OS/390 7 . 5 . 1 S t o r a g eC l a s s ........... ........... ........... ........ 7 2 7.5.2 Management Class . ........... ........... ............ .. 7 2 7 . 5 . 3 S t o r a g eG r o u p ........... ........... ........... ........ 7 3 7 . 6 S u m m a r y .. ................. ........... ........... .......[...]

vii 9.5.4.3 Extende d Remote Copy ....... ...... ............. ....... . 9 9 9 . 5 . 5 C o m p r e s s i o n .......... ........... ........... .......... 1 0 0 9.5.6 Sequential Data Striping . ........... ........... .......... 1 0 1 Chapter 10. DB2 I/O Op erat i ons . ........... ........... .......... 1 0 3 1 0 . 1 A v o i d i n g I / O O p e r [...]

viii Storage Man agem ent with DB2 for OS /390 Chapter 12. Case Study ............... ........... ............ . 1 4 1 1 2 . 1 D B 2 C a s e S t u d yA n a l y s i s .......... ........... ............ . 1 4 1 12.1.1 G eneral Analysis . . ........... ........... ............ . 1 4 1 1 2 . 1 . 1 . 1E l a p s e da n d C P UT i m e .. ....... ...... .[...]

ix A.6 Part itioned T able S pace U sing SM S Di stribution . ............. ....... 1 7 8 A . 6 . 1 D e f i n e V o l u m e st oS M SS t o r a g e G r o u p ... ....... ...... ....... 1 7 9 A . 6 . 2 A C SR o u t i n e s..... ............. ...... ....... ............. 1 7 9 A . 6 . 3 D B 2D e f i n i t i o n s .... ...... ....... ............. ....[...]

x Storage Ma nagem ent wit h DB2 for OS/390[...]

© Cop yrig ht IBM Corp . 1999 xi Fi gure s 1 . C r e a t i n gaS T O G R O U PD e f i n e dT a b l e S p a c e .......... ...... ........ 1 4 2 . U s e rD e f i n e dT a b l eS p a c e :S t e p1 — D e f i n et h eC l u s t e r ......... ....... . 1 4 3 . U s e rD e f i n e dT a b l eS p a c e :S t e p2 —D e f i n e t h eT a b l e S p a c e ...[...]

xii Stora ge Managem ent w ith DB2 for OS/390 5 1 . I / O Q u e u i n g A c t i v i t yR e p o r t ........ ....... ...... ............. ..... 1 3 1 52. Channe l Path Act ivity Report: LPA R Mod e . . . ............. ...... ..... 1 3 2 5 3 . D B 2I / O .... ....... ...... ............. ...... ....... ...... ..... 1 3 5 5 4 . I X F PD e v i c e P e [...]

xi ii 104.Test Case 3 - IDCA MS LISTCAT Display Extract . ............. ....... 1 7 4 105.Test Case 4 - S torage Class Routine Extract ........... ...... ....... 1 7 6 106.Test Ca se 4 - Mana gement Class Extract . ............. ...... ....... 1 7 6 107.Test Case 4 - IDCA MS LISTCAT Extract . ...... ....... ...... ....... 1 7 8 108.Test Case 5 - IS[...]

xiv Storage M anagemen t with DB 2 for OS/390[...]

© Cop yrig ht IBM Corp . 1999 xv Ta b l e s 1. Summary of Partition and Partitioned Table Space Sizes . . ............. . 1 2 2. DB2 Image Copy with and without Concurrent Copy ...... ...... ....... . 2 1 3. Table Space and Index Sp ace Names .......... ....... ...... ........ 2 3 4 . B S D S N a m e s .... ...... ............. ...... ....... ....[...]

xvi Storage Manag emen t with DB2 for OS/39 0[...]

© Cop yrig ht IBM Corp . 1999 xvii Pref ace This r edbook will help you t ailor and configure DF SMS constructs to be used in a DB2 f or OS/390 en vironment. In addit ion, thi s redbook pro vides a broad underst andi ng of new disk architec t ures and their impact in DB2 data set management for l arge installations. This book addresses both the st[...]

xviii Storage Mana geme nt with DB2 for O S/390 Thanks to the f ollowing people for their in v al uable c ontribut ions to this project: Mary Lovel ac e Markus Muetschard Hans-P eter Nagel Ali son Pate To r u Ya m a z a k i International T echnical Support Organization, San Jose Center T ed Blank John Cam pbell P ar amesh D esai Ching Lee Ric k Le [...]

xi x Ma r tin P a cker IB M UK John B urg Nghi Eakin IBM Gait hersburg Da vid P etersen IBM W ashington Thanks t o Elsa Mar tinez f or administr ation suppor t, M aggie Cutler and Yv onne Ly on f or technical editing, and Emma Jac obs f or the gr aphics. Comments W e lcome Y o ur comments are imp ortant to us! We w ant our redbook s to be as helpfu[...]

xx Storage Man agem ent with DB2 for OS /390[...]

© Cop yrig ht IBM Corp . 1999 1 P a rt 1. In tr oduc tion a nd Sum mary[...]

2 Storage Man ageme nt with DB2 f or OS/ 390[...]

© Cop yrig ht IBM Corp . 1999 3 Ch apte r 1. I ntr odu cti on A ux iliary s torage management in the DB 2 environment f or the MVS plat f or m has, so f ar, been mainly the r esponsibi li ty of the dat abase administr ators. In the firs t few year s of its usage, DB2’ s implicit def inition of page sets through i t s Storage Groups (ST O GROUP) [...]

4 Storage Man ageme nt with DB2 f or OS/ 390[...]

© Cop yrig ht IBM Corp . 1999 5 Ch apte r 2. S ummary of Con sid era tions This book describes t he e x ploitat ion of storage by DB2 f or O S/390 (DB 2). T wo major areas are analyz ed: 1. DB2 and stor age managem ent 2. DB2 and stor age ser vers This chapter summarizes the major concl us ions of thi s project. 2.1 DB2 and Storage Manag ement A d[...]

6 Storage Man ageme nt with DB2 f or OS/ 390 • DB2 data s haring perf ormance improv em ent f or open/ close of dat a sets (especial ly ben eficial during DB 2 s tar t-up) with Enhanced Catalog Sharing (ECS); ECS reduces the path l ength and s uppor ts the ICF shar ed catalog on th e cou pling facility . Y ou can chec k t he A ppendix section G.4[...]

Su mma r y of C on side ra tion s 7 Instal lations having these devi c es could use s equential caching as an ins t allat ion option. I ns tallat ions with a m ixture of de vi ces with large, small , or no cac he can benefit f rom the bypass cache option. 2. 2.3 L o g S tru ct ur e d F il e De vices using the log structured file technique (like the[...]

8 Storage Man ageme nt with DB2 f or OS/ 390 v olumes, c losing it on v olumes to be remo ved), and final ly removing the v olum es you w ant to ex c lude from the Storage Group . All those functi ons can be accomplis hed while the data is on line. Data sets that were unmov able , nev er-closed, or nev er reallocated could be mov ed us ing remote c[...]

© Cop yrig ht IBM Corp . 1999 9 P ar t 2 . DB 2 and Sys tem M anage d St or ag e[...]

10 Storage Man agem ent with DB2 for OS /390[...]

© Cop yrig ht IBM Corp . 1999 11 Chapter 3. DB2 Storage Objects This chapter repres ents an i nt roduct ion to DB2 f or OS/390 (DB2 throughout this redbook) f or the storage administrat ors interested in understanding the diff erent types of data related objects used in a DB 2 en vironment. Special emphasis is plac ed on the data sets managed dire[...]

12 Storage Man agem ent with DB2 for OS /390 3.2 .1 T ABLE All data managed b y DB2 i s associated t o a tab le. T he data within the t able is organized i n columns and rows , and this represents t he m inimum unit of data t hat can be identifi ed by t he user . The tabl e i s the main object us ed b y DB2 applications . The SQL DML used by applic[...]

DB2 Storage Objects 13 DB2 V6 has increased the maximum size of a par titioned tab le spac e to almost 16 TB, incr eas ing the maximum data set size t o 64 GB. This i s suppor ted only if the y are def ined and managed with DFSMS 1.5. 3.2 .3 INDEX A tab le can have z ero or m ore inde xes . A n inde x contains ke ys. Each ke y m a y point t o one o[...]

14 Storage Man agem ent with DB2 for OS /390 DB2 def ined and managed spaces should be the choice b y defaul t. It is t he easier of t hes e solutions and i s adequat e f or most table and i nde x s paces in t he majority of situat ions. User def ined table spaces pr ovide more control of the dat a s et placement and all VSAM definit i on options a[...]

DB2 Storage Objects 15 database name, and the table s pace nam e in Figure 2 on page 14 must match the definitions on Fi gure 3 on page 15. Figure 3. User Defined T a b le S pa ce: Step 2— D efine th e T able Sp ace 3.4 DB2 S ystem T able S paces DB2 us es four internally def i n ed databases t o control and m anage i t self and the applicati on [...]

16 Storage Man agem ent with DB2 for OS /390 Work dat abas e tab le spaces. When requir ed, 8K and 16K pages are pl aced in a 32K table space of the Work database. Figure 4 on p age 16 shows how the size and n umber of tab le spaces in th e Work database is defined. P arameters 13 through 16 on this figure s how the def ault number of table spaces [...]

DB2 Storage Objects 17 log RBA (or LRSN) of up dat es to a t able space. T he recor d is opened when a first update is detected, and closed after an inter v al of read only activity . The inter v al is defined with tw o read-only swi tch parameters on the DB2 installation panel DSNT IPN. 3.5 DB2 A pplicati on T a ble Spac es All applicat ion data i[...]

18 Storage Man agem ent with DB2 for OS /390 2. The failing BSDS must be r edefined, or alter natively , an existing spare BSDS cop y must be renamed. 3. The BSDS is rebuilt f rom the good cop y with an IDCAMS REPRO . 3.6 .2 A ctive L o gs The activ e log data sets are used for data recov er y and t o ensure data int egrity in case of software or h[...]

DB2 Storage Objects 19 • The amount of time to cov er with all logs (Time 1 up to Current Time) • The amount of time to cov er with acti ve logs (Time 2 up to Current Time) Figure 5. DB2 Log and Its Data Sets 3.6.3 Archive Logs Archiv e log data s ets are DB2 managed backups of the activ e log data s ets . Archiv e log data sets are creat ed au[...]

20 Storage Man agem ent with DB2 for OS /390 3. 6. 4 Ima ge Co pie s Image copies are the backup of user and system data. DB2 V6 i ntroduc es the possibility of taking im age copy f or index es. For a well-managed bac k up and reco very policy , it is recommended that the am ount of data in image copy dat a sets should cov er at least t hree genera[...]

DB2 Storage Objects 21 Fig ure 7. Im a ge Cop y SHRLEVE L CHANG E Another opt ion f or image copies is the use of the conc urrent copy f eature, with or without SnapS hot. Concurr ent cop y and SnapShot are described in 9.5.2, “Concurrent Cop y” on page 94. These features allo w DB2 to create full image copies w i th only a s hor t tim e inte r[...]

22 Storage Man agem ent with DB2 for OS /390 f or an archiv e log that is older t han the oldest image cop y unless other types of back ups, not jus t image copies, a re also used f or recov er y . Image copies and archiv e logs ar e r ecorded in DB2 and opt ionally cataloged in an ICF Catalog. Phy s ical deletion of t he data sets remov es them f [...]

DB2 Storage Objects 23 3.8 .1 T ab le Space and Inde x Space Names The names for DB2 tabl e s paces and index s pac es hav e the fol lowing structure: T able 3. T ab le Space an d Index Sp ace Nam es The elements of this name ar e: hlq VSAM catalog high le vel qualifi er DSNDB S t andard part of the name x Identif ies a VSAM cluster or data compone[...]

24 Storage Man agem ent with DB2 for OS /390 LOGCOPY S tandard par t of the name n A c t i v el o gc o p y ,1o r2 mm Active l og number , 01 to 31 3.8 .4 A rchi ve Log and BSDS Bac kup Names The def ault names f or archiv e log and BSDS bac kup data sets hav e the f ol lo wing optional s truc ture: T able 6. Archive Log and BSDS Backup Names hlq VS[...]

© Cop yrig ht IBM Corp . 1999 25 Cha pte r 4. Sys tem M an ag ed St orag e Co nc ept s and Com pon en ts This chapter is designed to fa m iliar ize the DB2 dat abas e adm inistrator (DBA) with the concepts and components of system managed s tor age (SMS). The f ollo wing topics are discussed: • Bac k g round •E v o l u t i o n • DFSMS/MVS co[...]

26 Storage Man agem ent with DB2 for OS /390 4.3 DFSMS/ MVS C omponents DFSMS/MVS pro vides and enhances functions f or merly provi ded by MVS/DFP , Data F acility Dat a Set Ser vices (DF DS S), and t he Data F acility Hi erarchic al Stor age Manager (DFHSM). The product is now easier t o install and order than the c om binati on of the earlier of [...]

Sys tem Ma nage d Stor age Co ncept s and Co mpon ents 27 4.3.1.2 ISMF f or the Sto rage Adminis trator Figure 9 on page 27 shows the IS M F primar y opt i on men u displa yed f or a storage adminis trator. Options allow lis ts to be built fro m v o lum e selec tion cr iteria (Sto rage Group), as well as t he Management Class, Dat a Class, and St o[...]

28 Storage Man agem ent with DB2 for OS /390 Logic al proc es sing, which is data set oriented. T his means it perf or ms against data sets independently of the phy sical dev i ce format. Ph ysical processing, whi c h can perf or m against data set s, volu m es, a nd t racks, bu t m oves da ta at t h e track-image lev e l. PRINT Used to print both [...]

Sys tem Ma nage d Stor age Co ncept s and Co mpon ents 29 by i s suing spec ific commands when manual operations are appropriate. V olumes can be: • Managed by S M S. In this case the St orage Group definit ions controls HSM init iated aut omatic functi ons, depending upon the appropr iat e M anagement Clas s of the data set. • Managed by HS M [...]

30 Storage Man agem ent with DB2 for OS /390 determined by either the Management Class f or SMS m anaged data sets , or set by the ADD V OL parameter f or H SM managed. It can also be controlled i n combination with v olume thresholds set b y the storage administ rator . Data sets may be mig r ated to ML1 (nor mally disk) 4 ,a f t e r a period of i[...]

Sys tem Ma nage d Stor age Co ncept s and Co mpon ents 31 • Recov er y Recov er y c an be either at the individual data set le vel or to ph y si cally restore a full vol ume. This is applicable f or both SM S and non-SMS managed data set s. Note that f ull e x ploitat ion of this c om ponent requi res t he use of t he DSS and Optimiz er c omponen[...]

32 Storage Man agem ent with DB2 for OS /390 • Simulate pot ential policy changes and understand t he c osts of t hos e changes. • Produce presentat ion quality chart s. F or more inf orm ati on on t he DFSMS/MVS Optimiz er Feature , see t he f ollowing publ ications: • DFSMS Optimiz er V1R2 User' s Guid e and Refer ence , SC26-7047-04 ?[...]

Sys tem Ma nage d Stor age Co ncept s and Co mpon ents 33 • A ut omat ed disk space management SMS has the facility t o autom atica lly rec laim spac e whic h is allo cated t o old and unused data sets. P olicies can be defined t hat determine how long an unused data set are allo wed to reside on lev el 0 volumes (act ive data). Redundant or e xp[...]

34 Storage Man agem ent with DB2 for OS /390[...]

© Cop yrig ht IBM Corp . 1999 35 Ch apte r 5. St ora ge Mana gemen t wit h DFSMS This chapter is designed to f amiliar ize the D B 2 administrator with the functionality of SMS. This chapter co vers the f ollowing t opi cs: • The SMS base configurat ion • The automatic class select ion routine • The SMS constructs • Objecti ves of using SM[...]

36 Storage Man agem ent with DB2 for OS /390 Communications Data Set The communications dat a set (COM MDS) holds the name of the ACDS and prov i des communicat ion between SMS systems in a mult isy stem en vironment. The COMMDS also contains s t atist ics on the SMS, and MVS st atus for eac h SMS v olume, including space. 5.1.2 Class an d Sto rage[...]

Sto rage M anage ment w ith DFS MS 37 1. Data Class—data definition param et ers . 2. Storage Class—perf or mance and accessibility requirem ents. 3. Managem ent Clas s—migrat ion, backup and retenti on attributes . 4. Storage Group—candidate allocation vol umes. Because data set allocat i ons, whet her dynamic or through JCL, are processed[...]

38 Storage Man agem ent with DB2 for OS /390 5.3 SMS Class es The storage adminis t r at or uses ISMF to create an A CS routine f or each of the three types of classes and one to assign the Storage Groups . These routines , used together wit h the Dat a Class, Storage Class, Management Class, Storage Group definiti ons, and t he base configura tion[...]

Sto rage M anage ment w ith DFS MS 39 User defined all oc ations tak e prec edence ov er defaul t Data Classes. For e xample , if a Data Class specifi es an LRE CL of 80 byt es, and the JCL allocation specifies an LRECL of 100 b ytes, t hen 100 b ytes are allocated. If the Data C lass is alt ered by the storage administ rator , attributes pre vious[...]

40 Storage Man agem ent with DB2 for OS /390 was av ailab le. SM S all ows t he separati on of perf or m ance and ser vi c e lev el of data sets by use of the Storage Class . A Storage Class construct detail s the intended performance charact eristics required f or a dat a set as s igned to a giv en class. T he r esponse times set f or eac h Stor a[...]

Sto rage M anage ment w ith DFS MS 41 5.3 .3 M anagement Cl ass 5.3.3.1 Des criptio n Prior to SMS, DFHSM managed the data sets at volume lev el , applying a standar d m anagement criteria f or all data sets on a giv en volume. Al though this is still applic able f or non-S MS managed data s ets , with the introduction of SMS, the control is carrie[...]

42 Storage Man agem ent with DB2 for OS /390 DFSMShsm's automatic bac kup serv ices, suppor ted by concurrent cop y , to help wit h point of consistency backups . It is not advisab le to use HSM to manage most production databas es . T herefore , use a NOMIGRA TE M anagement Class f or this type of data. This pre ve nts HSM space and av ailabi[...]

Sto rage M anage ment w ith DFS MS 43 5.3.4 Storage Group 5.3.4.1 Des criptio n Prior to SMS, di sk storage was maintained as individual vol umes, requiring manual inter v ention to pre vent v ol umes from filling up, and t o prev ent I/O bottlenec k s. SMS signif icantly improv es the management of disk by b uilding on DFHSM capabilit ies to pool [...]

44 Storage Man agem ent with DB2 for OS /390 • The number of volumes in the Storage Group satisfi es the volume count • Accessibilit y requested • A v ailability (dual cop y or RAMAC) request ed • The vol um e was e x plicit ly requested and guarant eed space is YES • Suffici ent free space to perform the allocati on without ex ceeding th[...]

Sto rage M anage ment w ith DFS MS 45 Electing DB2 t o select t he vol um e requi res assigning a S tor age Class with guarant eed space. Howe v er, guarant eed space reduces t he benefits of S MS allocati on, so this approach is not recommended. If you do choose to use specific volum e assignments, addit ional manual space management m us t be per[...]

46 Storage Man agem ent with DB2 for OS /390 hardwar e c apabilities. F or a f ew specific and e xc eptional cases, the storage c l ass GU ARANT EED SP ACE option can be use d. As the S t orage Group defini t ion ex ists only in SMS tables , its logical mapping onto vol umes can be redistrib uted when a hardware change occurs, without any DB2 appli[...]

© Cop yrig ht IBM Corp . 1999 47 Chapter 6. Managing DB2 Dat abases with SMS This chapter describes DB2 databases from the point of vi ew of their attrib utes f or S MS management, and provides e xampl es f or these databases. Due to their stricter av ailability requir em ents , the DB2 s yst em databases are analyzed separat ely . This chapter i [...]

48 Storage Man agem ent with DB2 for OS /390 Fig ure 14. Displa y a Data Cl ass Figure 15 . Data C lass D CDB2 6. 1.3 S M S St or ag e Cl a ss Some DB2 instal lations m a y us e only one Storage Class f or DB2, but in others , the D B2 administr ators ma y require s ev eral S t orage Class e s f or DB2 t able spaces . T able 12 on page 49 s ho w s [...]

M anagin g DB2 D atab ases wi th S MS 49 SCDBF AST Thi s Storage Cl ass is int ended for tab le spaces belonging to applicati ons requiring perf or mance. It prov i des high perf or mance and good av ailability . SCDBCRIT This Storage Cl ass is int ended f or tab le spaces belonging to critical appl ications. It provides high perf orm ance and cont[...]

50 Storage Man agem ent with DB2 for OS /390 MCDB22 This Management Class is i ntended f or tab l e spaces that are allowed to migrate and require l ess a vailability than that defined in the MCDB2M1 Managem ent Class . Thi s Management Class causes m ig ration after one w eek of inact ivity and t he table s pace will migr ate direct ly to lev el 2[...]

M anagin g DB2 D atab ases wi th S MS 51 SGDBTEST Stor age G roup for DB2 tab le s paces and inde x spaces with lo w perf or mance and availability requirements. This St o r age Group allo ws migrati on. SGDBXXXX Other Storage Groups intended f or specific par titioned DB2 tab le spaces and inde x spaces, or f or other critical tabl e spaces, where[...]

52 Storage Man agem ent with DB2 for OS /390 Figure 16 . Disp lay of Storage G roup SGD B20 6.1 .6 D B 2 ST OGROU Ps and SMS Stor age Gr oups The concepts of DB2 ST OGRO UP and SMS Storage Group are differen t, but very similar . While a Storage Group ref ers to a set of v olum es in an installation, the ST OGROUP ref ers to a set of v olumes conta[...]

M anagin g DB2 D atab ases wi th S MS 53 Figure 17 . V olume s in Stora ge Grou p SGDB20 6.1 .7 A ssigning SMS Classe s t o DB2 T able Sp aces and I nde x Sp aces SMS clas s es and S torage Groups are assigned t o DB2 tab le spaces and index spaces through A CS routines. Normally , A CS routines hav e only the data set name av ailable f or t heir d[...]

54 Storage Man agem ent with DB2 for OS /390 comb inations o f these nam es. This pr ovides the inst allation w ith great flexibility in implementation alternativ es, suc h as: High Le v el Qualifi er Fil ter The ACS r outines contain a list of high le v el qualifi ers. These qualifier s are used to as s ign the specifi c SMS classes . The high lev[...]

M anagin g DB2 D atab ases wi th S MS 55 Figure 18 . ACS Rout ine Extract U sing T a ble and Index Name Filt er Lis t T abl e Spa ce N ame C ode s The DB2 table space and inde x s pace names contain a Storage Cl as s code and a Management Class code. These codes are used to assign the specific SMS classes . Each table space and each inde x space c [...]

56 Storage Man agem ent with DB2 for OS /390 6.1 .8 T ab le Space and Inde x Space Na mes for SMS The recommendation in this book f or finely tuned SMS installati ons is t o imbed SMS codes into the names of DB2 tab le and inde x s paces . This is shown in T able 16 on page 56. The data set names hav e the structure shown in T able 3 on page 23, wi[...]

M anagin g DB2 D atab ases wi th S MS 57 ma y not leav e enough volumes with adequate free space; this could cause a REORG to f ail due to lack of s pac e . The fol lowing methods address t hi s issue . Us e One SMS Sto rage Gr oup f or Ea ch P art iti on A one- volume SMS Storage Group c an be defined for each partition. T he ACS routine as signs [...]

58 Storage Man agem ent with DB2 for OS /390 6.2 .1 On line Pr o duct ion Databases The databases used in production nor mally contain impor tant data and hav e special a vailability and security requirements. P erf or mance ma y become a critical issue, if the databases are us ed in an online envi ronment. Because online producti on dat abases con[...]

M anagin g DB2 D atab ases wi th S MS 59 6.2.3.1 Storage Clas ses The fol lowing e xample Storage Classes can be us ed f or Data War ehouse table spaces: • SCDBMED • SCDBTES T • SCDBF AST 6.2.3.2 Manage ment Class es The fol lowing e xample Managem ent Classes can be used for Data W arehouse tab le spaces: • MCDB20 • MCDB21 • MCDB22 6.2[...]

60 Storage Man agem ent with DB2 for OS /390 T able 17. Exam ples of SM S Class U sage for DB2 User Databa ses 6.3 DB2 S ystem D at abases A DB2 subsystem stor es data about itself wit hin a set of tabl es s tored in tab le spaces in system databases . The system databases are: • Catalog database (DSNDB06) • Dir ectory database (DSNDB01) • Wo[...]

M anagin g DB2 D atab ases wi th S MS 61 6.3.1.1 Storage Clas ses The fol lowing e xample Storage Classes can be used for online production tab le spaces: • SCDBCRI T 6.3.1.2 Manage ment Class es The follo wing exampl e Management Clas s can be us ed for online pr oduction tab le spaces: • MCDB20 6. 3.2 Work Da t ab as e All DB2 subsystems use [...]

62 Storage Man agem ent with DB2 for OS /390[...]

© Cop yrig ht IBM Corp . 1999 63 Cha pter 7. M anagin g DB2 Recover y D ata S ets w ith SMS Some DB2 data s ets are standard sequent ial fil es or par titioned data sets . Many install ations already manage these data sets with SMS and hav e already SMS classes def ined for these data sets. Theref ore, this chapter only anal y zes DB 2 reco very r[...]

64 Storage Man agem ent with DB2 for OS /390 T able 19. SMS S torage C lasses for Recover y Data Set s 7.1 .3 SM S M ana g emen t Class DB2 administ rators ma y require se ver al Management Classes f or DB2 recov er y data s et s. T hese M anagem ent C lasses ha ve di f f erent e xpirat ion and bac kup requirements . T abl e 20 on page 65 s ho w s [...]

Mana ging D B2 Re co v ery Data S ets wi th SMS 65 T able 20. Man agem ent Classe s for Recover y Data S ets 7.1.4 SMS Storag e Groups SMS Storage Classes and Management Classes are combined to generate Storage Groups . Thi s function is perf orm ed by the AC S rout ines. T able 21 on page 66 s hows the relat i onship bet ween SMS Stor age Classes [...]

66 Storage Man agem ent with DB2 for OS /390 SGDBA CT L Storage Group intended for B S DSs and ac tiv e logs f or all non-product ion DB2 subsystems. Because the corresponding Stor age Class has guaranteed space defined as ye s ,t h eD B 2 administ rator can dir ec t t he allocation of the dat a sets on v olum es whic h are dedicated to a specific [...]

Mana ging D B2 Re co v ery Data S ets wi th SMS 67 7.2 BSDS The bootstr ap data set (BSDS) contains the inf orm ation requi red by DB2 to star t the subsystem in nor mal circumstances . It also handles the restar t and recovery in any abnormal circumstance. F or example , all log data s ets (activ e and ar chive) are aut om ati cally registered wit[...]

68 Storage Man agem ent with DB2 for OS /390 7.2.3 Storage Group Because the Stor age Class has guaranteed space , the BSD S data sets ar e allocated on the disk volume s requested b y the DB2 adm inistrator . The volum es must belong t o the assigned Storage Group (such as: SGDB ACTL), and the dis k v olume must be eligible f or SM S . For e xampl[...]

Mana ging D B2 Re co v ery Data S ets wi th SMS 69 Figure 20. Ex ampl e VSAM D efinition of One Acti ve Log 7.3 .1 St orage Clas s A Storage Class with guaranteed space s et to ye s , enab les the DB2 adminis trator to dec ide the l ocation of t he activ e logs. • SCDBA CTL 7.3 .2 M anagement Cl ass The fol lowing Management Class has been define[...]

70 Storage Man agem ent with DB2 for OS /390 can def ine two separate de vice types f or the primary and secondary archi ve l og. This can be s een on line 5 and 6 of Figure 21. Figure 21 . Ar chive Log Inst allatio n P a nel DSNTIP A P e r f orma nce The ar c hiv e log perf or mance requi rem ent is dependent on recov er y perf or mance, service l[...]

Mana ging D B2 Re co v ery Data S ets wi th SMS 71 direc tly to tape . Backup The archiv e logs are a bac kup of t he activ e logs. DB2 can create dual archive logs. There i s no need f or an additional bac kup of the archive l ogs. 7.4 .1 St orage Clas s Stor age Class SCDBARCH is an e x ample of a Stor age Class f or archiv e logs. This Storage C[...]

72 Storage Man agem ent with DB2 for OS /390 means that a large number of image c op y data sets are required and need to be managed. Data Organization Image Cop y data sets are ph ys ic al sequential data sets . Record siz e is 4096 (f or any siz e of page) and the bloc k size is typically 28672 b y tes . S ample statements to e xecute an image c [...]

Mana ging D B2 Re co v ery Data S ets wi th SMS 73 7.5.3 Storage Group F or this e xample, three Storage Groups are def ined. These pro vide diff erent lev els of per form ance and av ailability . SGDBA RCH ser ves to separ at e secondary copies from the primar y copies. •S G D B I C •S G D B I C H • SGDBARCH 7.6 S umma ry T able 23. Storag e[...]

74 Storage Man agem ent with DB2 for OS /390[...]

© Cop yrig ht IBM Corp . 1999 75 Cha pter 8. Co n ve r ting D B2 to Sy stems Ma nag ed Sto rage This chapter describes the t echni ques for conv er ting DB2 data to SMS . H o wev er , each c us tomer has unique data set s a nd facilities to suppor t t hei r online envir onment. These differenc es have an impact on recommended s tor age management [...]

76 Storage Man agem ent with DB2 for OS /390 are not duple x ed b y t he database management system. The use of f ast w rite and cache f acilities will pr ovide increased perf or mance f or databases and recov er y data s et s. DFSMS/MVS enhances the backup and r ecov e ry utilities pr o v ided b y t he DB2 system as f ollows: • DFS MSdss uses co[...]

Conver ti ng DB 2 to Sy stem s M anag ed St or age 77 8.4 P os itioning for Implementation F or the DBA, there are a number of items to be considered as prerequis ites for th e proce ss. 8.4.1 Prerequis ite Plannin g Categor ize each data type into sep arate groups The usage characteristics and ser vi ce requirements will hav e to be considered f o[...]

78 Storage Man agem ent with DB2 for OS /390 DB2 Naming Co n v entions Cer tain part s of tab lespace names are generated by DB2. T his does not lea ve t he DBA with much scope f or a fle xibl e naming conv ention. For further info r mation on this subject see 6.1.7, “Assigning S MS Classes to DB2 T able Spaces and Inde x Spaces” on page 53 and[...]

Conver ti ng DB 2 to Sy stem s M anag ed St or age 79 • Activ e logs and BSDS. 8.5.2 Method ology 8.5.2.1 Conversion Window Deci de when eac h type of data is av ailab le f or conv ersion. During a nor mal processi ng c ycle , some dat a sets w ill be d el eted and real l ocated, pro v iding t he oppor tunity f or SMS m anagement. Online data mus[...]

80 Storage Man agem ent with DB2 for OS /390 8.5.2.4 Continge ncy Time F rame Limit the amount of dat a con v er ted at a particular time, s o if prob lems are ex peri enced, the s i tuati on can be reco ver ed or bac ked out. 8.5 .3 SM S Implemen tatio n The storage adminis t rator per forms the implementation of SMS, using ISMF to update the ACS [...]

Conver ti ng DB 2 to Sy stem s M anag ed St or age 81 • T ranslat ing and validat i ng the ACS routines • Generating test cases, to ensure updat es to t he ACS routines hav e the desired ef fect • Activ ating the new SMS configuration 8.5 .4 P ost Imp leme n t ation Once DB2 data sets are SM S managed, there must be an ongoing procedur e for [...]

82 Storage Man agem ent with DB2 for OS /390 • P erform storage repor ting, through IS MF and with DCOLLECT and V olume Mount Analyz er (VMA) data. • Pr int IS M F lis ts. • Run ISMF functions in batch mode, using the REXX EXECs pro vided. F or more inf orm ation on t his f eature , see DFSMS/MVS V1R3 Nav iQuest User's Guide, SC26- 7194 [...]

© Cop yrig ht IBM Corp . 1999 83 Pa r t 3 . DB2 and Stora g e Servers[...]

84 Storage Man agem ent with DB2 for OS /390[...]

© Cop yrig ht IBM Corp . 1999 85 Chapter 9. Dis k En v ir o nment O verv iew This chapter consider s the disk architecture from a DB2 point of view . It f ocuses on concept s and recommendations f or their pr ac tical im plementati on, rather t han on technical details. In order to facilitate the mutual understanding of s ome stor age t er ms betw[...]

86 Storage Man agem ent with DB2 for OS /390 • RAID 1: mirrori ng • RAID 2: synchronized acc es s with separate error cor rection disks • RAID 3: synchronized access wit h fixed parity disk • RAID 4: independent ac c ess with f ix ed parity disk • RAID 5: independent access with rotating parity • RAID 6: dual redundancy w ith rot ating [...]

Dis k E nvi ron m ent O ver v i ew 87 • Only one set of write operations t o disk in continuous ph ysical sequence (instead of a set of random writes), which is the most optimized write mode f or RAID technol og y Figure 23 on page 87 and Figure 24 on page 87 illus trat e t he LSF concept. Figure 23 . LSF C oncept 1 The main challenge o f an LSF [...]

88 Storage Man agem ent with DB2 for OS /390 Figure 25 . Sna pshot O v e r view SnapShot, as i t " copi es" from a source object to a target object (in compliance with MVS def initions): • Defines inst ant aneously the tar get object • Allo ws instant aneous access to both source and target objec t s (no ph ysical cop y lead time to w[...]

Dis k En vir on m en t O ver v iew 89 vo l u m e s to ph ys ical disks. A functional volume is a logical volume still defi ned b y tr ack size , capacity , and address. This mapping str ucture is contained in a ser ies of table s stored in the control unit. These tables are updat ed at each wr ite on functional v olume, and h av e to be m aint aine[...]

90 Storage Man agem ent with DB2 for OS /390 processing of any ot her f ailing cluster . Let us briefly review the storage server subcomponent relat ionships: • Host adapt ers at tach channel links and allow them t o communicate with either cluster-processor comple x. Practically , statistic s at this lev el deal with what is cal l ed upper inter[...]

Dis k En vir on m en t O ver v iew 91 In a relational database environment, the physical separation of logically related data results in little localit y of ref erence. Data in memor y techniques also minimize the re-refer enc ing of data on disk, as this is ideally acc omplished in processor m em ory . Write c aching requires that data integrity b[...]

92 Storage Man agem ent with DB2 for OS /390 9. 3.3 W r ite Re c ord Ca chi ng (Q ui ckwr it e ) Write r ecord caching, called quick wr ite , e x tends the benefits of DFW to data that does not have a read-bef ore-update ac cess patter n (whic h is currently r equired to hav e a DF W hit) and for data with a poor cache h it rate. Data with a predic[...]

Dis k En vir on m en t O ver v iew 93 allows them a longer stay in cache. Other data sets should be set in ma y c ache Storage Classes, defined with inter mediate response t ime values . 9.4 P aths and Bandwidth Evolution A path is a logical conc ept that lies on the physical web of links (cab les ) exis ting between hosts and storage ser v ers. Th[...]

94 Storage Man agem ent with DB2 for OS /390 one-to-one redundancy . Its pur pose is I/O automatic s wit ching to secondar y when unattended outage occurs on pri mary . Vir tual volume , RAID 5, and RAID 6 have made the concept of dual copy practically obsolete . 9.5.2 Concurre nt Copy Concurrent copy is a f unction the disk storage ser ver c ont r[...]

Dis k En vir on m en t O ver v iew 95 DB2 fully integrates conc ur rent cop y into DB2 recov er y . The CONCURRE NT option on the DB2 COP Y utilit y r educes disruption and automatically manages the copies used for recov er y , to ens ure consistent data. This option inv okes the concurrent copy f unc tion of DFSMSdss, and r ecords the resulting im[...]

96 Storage Man agem ent with DB2 for OS /390 tr aditional disaster recov er y , is that each software subs y stem (CICS, I MS, DB2, VSAM, and others) has its own recovery technique. Because an application is typically made up of m ulti ple soft w are s ubsy stems , it is impossib le to get a time-consistent backup ac ross all subsystems unless the [...]

Dis k En vir on m en t O ver v iew 97 database would be c orr upted and would ha ve to be recov ered from image copies and log data. In all cases notification of this miss mus t be known at s ec ondar y . When that happens f or hundreds of volumes, w i thout a clear notification of status of impacted secondar y v ol umes , recov er y can be e xtrem[...]

98 Storage Man agem ent with DB2 for OS /390 This replaces a manual site sw i tch process that could requir e more than 20 people to be pres ent to perform their s pecialized tasks. Figure 30 on page 98 shows the global GDPS ar chitecture. Fi gu re 3 0. GDP S Arc hit ect ure Implemen tation GDPS is being im plemented as an automation solut ion , us[...]

Dis k En vir on m en t O ver v iew 99 During nor mal operations GDPS continuously monitors all systems and specifically looks for messages indi cating that PPRC volume pairs are being suspended. At the occ ur rence of a sus pend , GDPS immediately freezes the image of the secondar y disk configuration, to ensure restar tab ility of the applications[...]

100 Storage Ma nagem ent with D B2 for OS /390 site . XRC external izes a tim es tam p of the recov er ed system so that manual reco ver y is possible from a specified time. The time lag between the primar y and the secondar y sites c an be minimized by perf or mance t uning actions. Figure 31 . XRC Data Flow 9.5 .5 Compress ion Host compression te[...]

Dis k En viro nmen t Ov ervi ew 101 9.5.6 Sequent ial Da ta Striping Sequential data stri ping provides the oppor tunity for significant improv em ent in sequential processing performance by allowing data t o be spread acr oss multiple dev ices that are acc essed concurrently transparently to t he applic at ions . With sequential data str iping, th[...]

102 Storage Ma nagem ent with D B2 for OS /390[...]

© Cop yrig ht IBM Corp . 1999 103 Chapter 10. DB2 I/O Op erations The information shown here is extr ac ted and modified from different sections of the DB2 UDB f or OS/390 V6 A dmini s trat ion Guide, SC26-8957. T his inf orm ation is provided to give storage administrato r s an understanding of the I/O operations perf ormed by DB2. The two most i[...]

104 Storage Ma nagem ent with D B2 for OS /390 Figure 32 . Stor age Hierar chy 10.2 Data R ead Ope rati ons DB2 uses four r ead mechanisms to get data pages from disk into t he vir tual buf ferpool: • Nor mal r ead (or synchronous read) • Sequential prefetch • Dynamic prefetch • List sequential prefetch 10. 2.1 N ormal Read Normal read i s [...]

DB2 I /O Oper atio ns 105 instances that do not hav e total ov erlap, in which w ait times will still appear in the accounting records. Sequential prefetch c an be used t o read dat a pages, b y tab le space sc ans or index s c ans with cl ustered data ref er ence. It can also be used to read inde x pages in an inde x scan. Sequential prefet c h al[...]

106 Storage Ma nagem ent with D B2 for OS /390 Figure 24 shows the prefetch quantity as a function of the page s ize and the buf fer pool size . F or c er tain utilities (REORG, R E CO V ER), the pref et ch quantity can b e twi ce as much . T able 24. Numbe r of Pages Read A synchr onou sly in One Pr efetch Reques t F r om the DB2 PM accounting t r[...]

DB2 I /O Oper atio ns 107 10. 2.7 Se quenti al Prefet ch Thresh old The sequential prefetch threshold (SPTH) is set by DB2 at 90% of each vir t ual buf fer pool. This threshold is c heck ed at two differ ent times: • Befor e scheduling a pref etch oper at ion. If t he threshold has been exc eeded, the pr ef et ch is not scheduled. • During buff[...]

108 Storage Ma nagem ent with D B2 for OS /390 10.3.2 Synchronous W rites Synchronous writes occur exceptionally , when: • The vir tual buf fer pool is too s m all and the immediate w r ite threshold (IWTH, see 10.3.3, “I mmediate Write Thr eshold” on page 108) is exceeded . • More than t wo DB2 check poi nts hav e been taken during the e x[...]

DB2 I /O Oper atio ns 109 T able s paces containing pages w hi ch are f r equently rer ead and updated should hav e a high threshold, placing them in a v ir tual b uff er pool with a high D WQT , or high VD W QT . This ensures that pages are reused in s t orage . The ref erenc e value J in Figure 35 on page 110 s hows the rate of updates per each w[...]

110 Storage Ma nagem ent with D B2 for OS /390 Figure 34 . DB2 P M Statis tic Repor t B uffer P ool Rea ds Figure 35 . DB2 P M Statis tic Repor t B uffer P ool W r ites BP4 READ OPER ATIONS QUANT ITY /MINU TE /THREAD /C OMMIT ----- ------- ------- ------- - -------- -- ----- --- ---- ----- -- BPOOL HIT RA TIO (%) 55 .12 GETPA GE REQU EST 221.8K 653[...]

DB2 I /O Oper atio ns 111 Figure 36 . Disp lay Buffer P oo l Data Set Statis tics 10.4 Log Write s Log records are cr eated by application programs when data is updated. Each data update requires two log records, one with the data before the update, and another with the data after the update, generally combined into one phys ic al rec o rd . The ap[...]

112 Storage Ma nagem ent with D B2 for OS /390 10.4.1 Asynchronou s W rites DB2 writes t he log records (the control inter vals ) from the out put buff er t o the active log data set when the number of log buffers used reaches the value the installation set for the WRITE THRESHOLD field of installation panel DSNTIPL; see Figure 40 on page 115. The [...]

DB2 I /O Oper atio ns 113 Figure 37 . Lo g Record Path to D isk Figure 38 . T w o-Phase C ommit with D ual Active Logs APPLIC A TION PR OGRA M Log R e cor d Log Output Buff er Act ive Log Data set ASYNC SYNC NOW AIT FORCE I/O I/O I/O I/O Force End o f Pha se 1 Forc e Begi nning of Phase 2 En d of C OM MIT Log 1 Log 2 App licatio n w aiting for log [...]

114 Storage Ma nagem ent with D B2 for OS /390 10.4.5 Improving Log Writ e Performance In this section we p resent some c onsidera t ions on choic es to improv e log w rite perf ormanc e . LOG OU TPUT BUFFE R Siz e The OUTPUT BUFFER field of inst allation panel DSNTIPL let s the system administrator specify the s ize of the output buffer us ed for [...]

DB2 I /O Oper atio ns 115 Figure 39 . M inimum A ctiv e L og D ata Set D istribution Pref ormat New Acti ve Log Data S et s The system administrator , when allocating new active log data sets, can pref ormat them using t he DSNJLOGF utility desc ribed in Section 3 of DB2 f or OS/390 U tility G uide an d Reference, SC26-8967. This avoids the ov erhe[...]

116 Storage Ma nagem ent with D B2 for OS /390 records into the input buf fer used by the reading process (such as a recovery job or a rollback). F r om a performance point of view , it is alwa y s best for DB2 to obtain t he log records from the output b uffer . These accesses are repor ted by DB2 P M ; see F in Figure 41 on page 118. The ne xt fa[...]

DB2 I /O Oper atio ns 117 If you allow DB2 to create the archive log data sets on R V A disks, you can take adv antage of the com pression capability offered b y the device . Depending on the type of applic ation data DB2 is processing and stor ing in the log data sets, you could obtain a very good reduction i n D ASD occupancy with R V A and achie[...]

118 Storage Ma nagem ent with D B2 for OS /390 needs v alues from the statistics repor t shown in Figure 41: the NO W A IT counter C, and the n um ber of control intervals cr eated in the active log, counter D .U s e the f ollowing f ormula: a v gs i z eo fl o gr e c o r d i nb y t e s= D * 4096 / C Using this value to estimate logging needs, plus [...]

© Cop yrig ht IBM Corp . 1999 119 Ch apte r 11 . I/ O P erf orman ce and Moni tori ng T ool s This chapter addresses I/O performance repor ting and monitoring tools in relat ion to storage management in a DB2 environment. The follo wing tools are des cribed: • DB2 P erformance Monitor (DB 2 PM) • Resource Monitoring F acility ( RMF) • IBM Ex[...]

120 Storage Ma nagem ent with D B2 for OS /390 Statistics and ac c ounting tr aces are collected in m ost installat ions. A perf ormanc e trace is collected when a specifi c prob l em has to be inv estigated. Activ at ing the performance trace has a significant impact on DB2 s ubsystem perf ormanc e . The user can cause more or less information t o[...]

I/O Perform a nce an d Mo nito ri ng T o ol s 121 Figure 44 . DB 2 PM Acc ountin g, Buffer P ool S ectio n 11.1.1. 2 I/O S uspensi ons If acc ounting trac e class 3 is activat ed, the DB2 account ing repor ts sho w a summary of the wait times of a DB2 application. This summary shows when the DB2 application is suspended ( waiting) for a DB2 system [...]

122 Storage Ma nagem ent with D B2 for OS /390 the accounting report. Some additional inf or mation is c alc ulated in t his report , for ex ample, in Figure 45 it shows the a verage number of pages f or each type of pref etch read. Figure 45 . DB 2 PM Statis tics, Bu ffer Pool Read Oper ations Sec tion 11.1.2. 2 L og Activity The log activity repo[...]

I/O Perform a nce an d Mo nito ri ng T o ol s 123 Line C in Figure 46 shows BSDS ac cesses. Just like the active log accesses, these accesses are mai nly writes. The bloc k of lines s t ar ting with D s ho ws volume of rec ords created in the ac t ive log and of fl oaded b y the arc hiv ing proc ess . The bloc k of lines s t ar ting with E shows ar[...]

124 Storage Ma nagem ent with D B2 for OS /390 T able 26. T ra ce Requirem ent for the I/O Ac tivity Repor t s Figure 47 . Buf fer P ool S ection fro m I/O A ctiv ity Summ ar y Repor t 11.2 RMF Moni toring F r om a DB2 point of vi ew , I/O flows between disk storage and buff er pools. I/O activity can be modeled as a three-step proc e s s inv olv i[...]

I/O Perform a nce an d Mo nito ri ng T o ol s 125 Most of the RM F repor ts ar e issued either at t he central processor complex (CPC) le vel for a global view , or at t he logical par t ition (LP A R) le vel for each MVS image v iew . The follo wing t w o processes c an be us ed to e xt rac t relev ant data from the v ar ious RMF repor ts: 1. Dete[...]

126 Storage Ma nagem ent with D B2 for OS /390 There are three Cache Subsystem Activity repor ts: • Cac he Subsys tem Sta tus This repor t gives the amount of cache s torage and nonv olatile s torage (NVS) installed, as well as the current status of the cache. • Cac he Subsys tem Ov ervie w This repor t gives the number of I /O r equests s ent [...]

I/O Perform a nce an d Mo nito ri ng T o ol s 127 Figure 48. Cac he Subsy stem Activity Status and O v er v iew Repor ts Figure 49. Cac he Subsy stem Activity Device O verview Re por t CACHE SUBS YSTEM ACTIVI TY PAGE 1 OS/390 SYSTEM ID IPO 4 STA RT 11/19/1998-10.30.00 INTERVAL 001.00.00 REL. 02.05.00 RPT VERSION 2.4.0 END 11/19/1998-11. 30.00 SUBSY[...]

128 Storage Ma nagem ent with D B2 for OS /390 Cache S ubs ystem Device Ov erv iew This repor t lists the devices kno wn by the subsystem at the beginning of the interval. Each li ne displa y s statistics for a specific (functional) v olum e. The I/O rat e, div ided into two groups (CA CHE HIT and DA S D I/O ), shows the diff erent types of I/ O ac[...]

I/O Perform a nce an d Mo nito ri ng T o ol s 129 • Dis c onnect time , which cov er s all inter nal LCU dela ys pr imarily due to a prerequisite process in t he storage ser ver; f or instance, staging activity f or cache misses, or PPRC propagation of the I/O to t he secondar y site • Connect tim e, which covers eff ective data transfer ac t i[...]

130 Storage Ma nagem ent with D B2 for OS /390 • A V G CONN TIME, connect t ime mainly f or data transf er . T o estimate path percentage utilization dem and, calculate: A VG CONN TIME * DEVICE A CTIVI TY RA TE/1000)*100 • As an ex am ple, an av erage connect of 4.5 ms with 1200 I/O/sec gives 540%, which means a minimum of six paths is required[...]

I/O Perform a nce an d Mo nito ri ng T o ol s 131 Figure 51. I/O Queuing A ctivity R epor t I / O QUEUIN G ACT IVITY OS/390 SYS TEM ID IPO4 STAR T 11/19 /1998-1 0.30.00 INTERVAL 001.0 0.00 REL. 0 2.05.00 RPT VE RSION 2 .4.0 END 11/19/1 998-11. 30.00 CYCL E 1.000 SECON DS TOTAL SAMP LES = 3600 IOP ACTIVIT Y RATE AVG Q LNGTH IODF = 40 CR-DA TE: 11/05[...]

132 Storage Ma nagem ent with D B2 for OS /390 Figure 52. Chan nel P a th A ctivity Rep or t: LP AR Mode 11.2.2 Using R MF R epor ts In a performance m onitoring contex t, there are sev eral heterogeneous considerations t o be a ware of before us ing RMF repor ting. When doing a resource lev el analysis, what is the reason for us ing SMs for DB2, a[...]

I/O Perform a nce an d Mo nito ri ng T o ol s 133 same view as cache repor ts f or each LCU: and second, bet w een all LCUs to get the whole storage server vie w . Some tools , such as IXFP , offer consolidated data. In the case study activiti es, t here is only one a c tiv e LP A R, s o only LCU le v el consolidation is done. 11.2.2. 2 RMF R epor [...]

134 Storage Ma nagem ent with D B2 for OS /390 2. Star ting RMF2SC on the PC, using appropriate options to s elect the repor ts to be c on vert ed. 3. Using your spreadsheet program to manipulate t he spreadsheet data. Details of ho w to do this depend on which progr am you are using, b ut in all cases, the cells and ranges t hat y ou can refer enc[...]

I/O Perform a nce an d Mo nito ri ng T o ol s 135 Figure 53 . DB2 I /O 11.3 IXFP Monitoring The IBM Extended Fac ilit ies Product (IX FP) is a hos t software that helps to manage the R V A. IXFP pr ovides an additional l e vel of cache c ontrol f or R V A bey ond that provided b y the local operator panel. In addition, I XF P m aximizes the benefit[...]

136 Storage Ma nagem ent with D B2 for OS /390 own report wr iter and graphics display tools. Ref er t o Chapter 10 of IX FP Subsystem Repor ting, SC26- 7184, as a ref erenc e manual f or any R V A monitoring and repor ting f ac ilities. Standard IXFP repor ts require us e of a SAS statistical env ir onment from SAS Institute , Incor porated. IBM S[...]

I/O Perform a nce an d Mo nito ri ng T o ol s 137 F or storage specialists, we recommend monitoring t he FREE S P ACE COLLECTION LOAD which represents the amount of back-end phy sic al space collected f or free space consolidation that did not yield av ailable free space. This is the av erage per cent full of c ollected storage areas. During per io[...]

138 Storage Ma nagem ent with D B2 for OS /390 • WRITE PER SEC is the av er age number of writ e operations per second f or th e su bsystem . • I/O PER SEC is the av erage number of I/O operations per second for t he subsystem. This field may not be equal to t he sum of REA D PER SEC and WRITE PER SE C, either because it includes other I/O oper[...]

I/O Perform a nce an d Mo nito ri ng T o ol s 139 Figure 56. IXFP S pace Utiliz ation Sub system R epor t The fields to re v ie w are as follo ws : • NET CAP ACITY LO AD ( %) PROD is the perc entage of back- end physic al capacity that is used (not f ree) in t he subsystem. This incl u des user data and the system areas needed to maintain the arr[...]

140 Storage Ma nagem ent with D B2 for OS /390[...]

© Cop yrig ht IBM Corp . 1999 141 Cha pter 12. Case S tudy The case study appli es all pre viously descr ibed monitoring f acilities in a common project f r om the DB 2 and stor age per spectiv es. This approach introduces s om e redundancy . The good new s i s that redundancy allows cross-chec king inf or mation am ong various sources. The enviro[...]

142 Storage Ma nagem ent with D B2 for OS /390 Figure 57 . DB 2 PM Acc ountin g, Class 1 an d Class 2 S ections Figure 58 . DB 2 PM Acc ountin g, SQL D ML Se ction The DB2 PM account ing repor t contains two more sect ions with SQL statements. One of these (SQL D CL) contains interesting inf or mation f or this st udy . This section is shown in Fig[...]

Case Stu dy 143 The e x planation can be found in t he driver program used to r un the quer y . This progr am does a CONNECT RESET automatically after each quer y . Figure 59 . DB 2 PM Acc ountin g, SQL DC L Section Figure 60 . DB 2 PM Acc ountin g, P arallel Q uer y Sec tion 12.1.1. 3 Tim e Not Accoun ted H in Figure 57 on page 142 s hows 19 min u[...]

144 Storage Ma nagem ent with D B2 for OS /390 Figure 61 . DB 2 PM Stat istics, Global D DF Activ ity Sectio n 12. 1.2 Dat a Access The ne x t step of this analysis is the ex amination of the b uf f er pools t o establish the patt er n of data access . The accounting r epor t show s that the f ollowing b uffer pools are being used: BP0 System table[...]

Case Stu dy 145 Figure 63 . DB 2 PM Acc ountin g, BP4 Se ction 12. 1.3 Suspend T imes The class 3 s ection of the ac counting repor t s ho ws suspend (wait) times . This is shown in Figure 64 on page 145. These values are only shown if the ac counting tr ace is started with class 3. In this e x ample, the w ai t times repor ted c or respond to I/O [...]

146 Storage Ma nagem ent with D B2 for OS /390 Fig ure 65. DB2 PM Accou nting Highlig hts 12.1 .3.2 Asyn chronous Read I/O B in Figure 64 on page 145 s hows 143669 asynchronous reads. This corresponds to the s um of all pr efetch oper ati ons ( sequential, dynamic and list pref etch). The sus pend time for these reads is 29 m inutes and 59.155952 s[...]

Case Stu dy 147 Figure 66 . DB 2 PM Acc ountin g Buffer Pool Sum mar y 12.1.4 Con clusions This e x ample show s a very complex and hea vy read-only quer y . Fiv e-way parallelism has been used t o reduce elaps ed time . The query i s CPU bound with c omple x s tage 2 type predic ates , which ac cess many pages but pr oduce a small result set of 10[...]

148 Storage Ma nagem ent with D B2 for OS /390 discarding "foreign ov er head" from the target study . Howe ver , values related to this f or eign o verhead mus t be preser v ed because interactions exist on resource access inside the sam e computing perim eter . T he first step is an over all analy sis. Moreo ver , this f irst ov er view[...]

Case Stu dy 149 12.2.1. 1 D evice Activity Rep ort An alysis The RMF repor t analysis is bas ed on the LCU l e vel and Storage Group lev el dev ice ac tivity repor ts. Figure 68 on page 149 shows the e x tracted summar y lines. T he Storage Group le vel line is the a verage c om bination of LCUs 46- 48 and 4A-4D activities, as the det ail volume le[...]

150 Storage Ma nagem ent with D B2 for OS /390 1. F or LCUs 0046-0049: 07, 08, 12, 8B , 91, 1E, C8, D0 2. F or LCUs 004A-004D: 0A, 8C , 95, 15, 8F , C1, D2 This results in a total of 16 different paths. Look at their b usy percentage in the channel path activity repor t. Fi gu re 69. Case S t udy RM F I/O Q ueu in g Act ivi ty Ex tr act 12.2.1.3 C [...]

Case Stu dy 151 12.2.1. 4 C ache Sub system A ctivity Repo rts Ana lysis These repor ts address questions: 1. Is cache overloaded ? 2. What is the efficiency of staging and destaging processes ? All %READ fields of repor ts show 100%, so the I/O activity is read-only . F ocus t he analysis on LCU 0046, associated with the CU-ID 2B00; ref er t o Fig[...]

152 Storage Ma nagem ent with D B2 for OS /390 12.2.2 IXFP V iew IXFP b uilds R V A statistics repor ts at t he le vel of the storage ser ver: it has a hardwar e standpoint, and s o consolidates acti vities from s h ar ing LP ARs. This standpoint also gives to IXFP a good knowledge of data handed into each channel program. Inf or mation on function[...]

Case Stu dy 153 12.2.2. 2 Cache effecti veness O vera ll Summar y Figure 73 on page 153 shows an ex tract of t hese repor ts for both R V As that contains inf or mation similar to RM F , but wit h more details on caching algorit hms , and also explains the origin of t he obser v ed disconnect times. T he I/O demand the host submits to the R V A s a[...]

154 Storage Ma nagem ent with D B2 for OS /390 Figure 74. Cas e Study IXFP S pace Utiliz ation Summar y E xtract 12.3 Case Stud y Summary The summary is dr iv en from the application point of view , bec ause application generat es the I /O demand. Then correlations are established with the RMF system and IXFP harwar e performance moni tors. T hose [...]

Case Stu dy 155 Figure 75. D B2PM I/O Summ ar y Figure 76. D e v ice Act ivit y Summar y DB2 PM I/O SU MMARY Elaps ed (sec): 2260 BUFFE R POOL To t4K reques ts wa it / requ est per sec ms per read getpa ges 61358 75 2714.5 2 synch ronous pr efetc h 1646 49 72.8 4 dynam ic prefe tch 260 65 11.5 3 total pr efetch 1 90714 8 4.37 9.4 synch ronous re ad[...]

156 Storage Ma nagem ent with D B2 for OS /390 Figure 77. Cac he Act ivity Su mmar y Figure 78 . IXF P Summ ar y CACH E ACTI VITY normal se quent norm al sequen t dest age seque nt field rate read rea d st aging sta ging async icl read unit io/s io/s io/s trk /s trk/ s io/s io/s hi t rati o RVA_1 1st LCU 18.2 0.4 17.8 0.2 41.1 0 0 0.999 2nd LCU 10.[...]

Case Stu dy 157 Fi gu re 79. Case S tud y I/ O Flo ws D B 2 A p p l i c a t i o n s Vi rt ual Buffer Pool Storage Cache Disk LPAR Disk St ora ge Server GET P AGE READ ST AG E 2715 row s/s ec 216 tr acks/sec 93 req uests/ sec[...]

158 Storage Ma nagem ent with D B2 for OS /390[...]

© Cop yrig ht IBM Corp . 1999 159 Par t 4. Ap pend ixes[...]

160 Storage Ma nagem ent with D B2 for OS /390[...]

© Cop yrig ht IBM Corp . 1999 161 Appendix A. T est Cases f o r DB2 T able Space Data Sets This appendix shows the dif f erent t est cases generated dur ing the writ ing of this publication, related to the alloc ation of tab le spaces ( and inde xes). The f ollowing tests are documented: TEST CASE 1 Appendix A.2, “ P ar titioned T able Space, DB[...]

162 Storage Ma nagem ent with D B2 for OS /390 A.2 P artitione d T able Spa ce, DB2 Defi ned, W ith out SMS T est case 1 illustrates how to allocate a DB 2 par titioned tab le space using DB2 defined data s ets, without SM S . The pur pose is to distr ibut e the diff erent data s et s across m ultiple v ol umes and access paths, in order t o obtain[...]

T es t C as es for D B 2 T abl e S pa ce D a ta S ets 163 A.2.3 C reate the T able Space The CRE A TE T A BLESP A CE s tatement is shown in Figure 83 on page 163. I n this statement, each par t ition is dir ected to a spec ific ST O GROUP . Figure 8 3. T e st Case 1 - CREA TE T ABLESP A CE A. 2.4 D i spl ay a V ol ume V olum es can be displa yed, t[...]

164 Storage Ma nagem ent with D B2 for OS /390 A.3 Partiti oned T able S p a ce, User Defin ed, With out SMS T est case 2 illustrates how to allocate a DB 2 par titioned tab le space using user defined data sets, without SM S . The objective and the t ab le s pace are the same as f or Appendix A, section A.2, “P ar titioned T able Space , DB2 Def[...]

T es t C as es for D B 2 T abl e S pa ce D a ta S ets 165 Figure 8 7. T e st Case 2 - CREA TE T ABLESP A CE A. 3.5 D i spl ay a V ol ume V olum es can be displa yed, to ensure that the allocation was done c orrectly . As an ex ample, Figure 88 on page 1 65 shows the contents of volume R V2CU1. F rom this figure we can see that only two data sets ar[...]

166 Storage Ma nagem ent with D B2 for OS /390 databases, B CUS T OMR, BSER VICE, BTRANS are allocated on SG DBF A ST . • All table spaces in t he de velopment system will be allocated on SGDB TEST . • The dev elopment dat abases are subject to m ig r ation by HSM. Those databases with a nam e star ting wit h B will get pref er ential treatment[...]

T es t C as es for D B 2 T abl e S pa ce D a ta S ets 167 Figure 90 . T est Ca se 3 - S torage Class R outin e Extract A.4.2 M anagem ent Class This ex erc ise requires multiple management at tributes f or the T able s paces according to the space name spec ified in the data set name. Therefore , using ISMF , opt ion 3.3, three Management Class es,[...]

168 Storage Ma nagem ent with D B2 for OS /390 Figure 91 . T est Ca se 3 - IS MF Ma nagement C lass Definition Ne xt, using ISMF , option 7.1, t he ACS routine code w as edited to as sign the appropriate Management Classes to all data sets with the corresponding naming conv ent ion. Figure 92 on page 168 dis pla y s the associated routine ex tract:[...]

T es t C as es for D B 2 T abl e S pa ce D a ta S ets 169 A.4.3 Sto ra ge Group F our Storage Groups , SGDBF AST , SGDB20 , SGDBCRIT , and SGDB T ES T were defined using I S MF , option 6.2. Fi gure 93 on page 169 sho ws the associated panel used by the storage administrator for the definiti on of POOL Storage Groups: Figure 93 . T est Ca se 3 - IS[...]

170 Storage Ma nagem ent with D B2 for OS /390 ex ample of the ISMF panel opti on 6.4 us ed b y the storage administrator to define vo l u m e s . T able 28. T e st Case 3 - Storage G roup V o lumes Figure 95 . T est Ca se 3 - IS MF Stora ge Gro up V olum e Definiti on DFSMSdss was us ed to con ver t these v olumes to SMS management, b y specifying[...]

T es t C as es for D B 2 T abl e S pa ce D a ta S ets 171 Figure 97 on page 171 shows the output from the ex ecuted batch job: Figure 97 . T e st Case 3 - D FSMS dss CO NVERTV O utput A. 4.4 ISM F T est Ca ses Prior to permanently updating the S MS configuration, I SMF , opti o n 7.4, was us ed to compar e the activ e configuration (A CDS) against [...]

172 Storage Ma nagem ent with D B2 for OS /390 Figure 99 on page 172 shows the tes t case results for the same pattern t ab le space name against the updated SCDS. This time , with the relev ant source code in place, the SMS qualif ication is suc cessful, and Management Class and Storage Group attributes ar e also assigned: Figure 99 . T est Ca se [...]

T es t C as es for D B 2 T abl e S pa ce D a ta S ets 173 Figure 101. T est Case 3 - CREA TE DA T ABASE Extr a ct Figure 102 on page 173 shows an ex t ract of the CRE A TE T ABLESP A CE statements used f or the pur poses of this ex er cise: Figure 1 0 2. T est Case 3 - CREA TE T ABLESP ACE Ext ract A.4.7 D ata Set Allocation Results Figure 103 on p[...]

174 Storage Ma nagem ent with D B2 for OS /390 Using the I DCAMS LISTCA T command, it can be seen from t his ex t ract in Figure 104 on page 174, that the catal og retains the SMS attributes assigned at data s et allocation time, and shows the space at tributes that were allocated in cylinders: Figure 10 4. T est C ase 3 - ID CAMS LI STCA T D ispla[...]

T es t C as es for D B 2 T abl e S pa ce D a ta S ets 175 The FIL TLIST definitions f or SCDBF AST and SCDBCRIT were coded to ensur e that table spaces assigned with these attri butes would not be subject to HS M migr at ion. Any attempt to deviate from this nam ing patter n would result in a null Storage Class being assigned. A.5.2 M anagem ent Cl[...]

176 Storage Ma nagem ent with D B2 for OS /390 Figure 10 5. T est C ase 4 - S torage C lass Rou tine Extra ct Figure 10 6. T est C ase 4 - Ma nagem ent Class Extrac t /**** ******* ******* ******* ******** ******* ******* **/ /* ST ORAGE C LASS */ /* FILTLI ST DEFINIT IONS */ /**** ******* ******* ******* ******** ******* ******* **/ FILTL IST SCDB[...]

T es t C as es for D B 2 T abl e S pa ce D a ta S ets 177 A.5.4 D B2 Definiti o ns 1. Three ST O GR OUP’ s were defined on system DB2P: •S G B T R A N S w i t h ( V O L U M E S ( * ) •S G C U S T M R w i t h ( V O L U M E S ( * ) • SGBRANCH with (V OLUMES(*) 2. One ST OGR OUP was defined on system DB 2D: •S G T E S T w i t h ( V O L U M E[...]

178 Storage Ma nagem ent with D B2 for OS /390 Figure 10 7. T est Case 4 - ID CAM S LIST CA T Ext ract A.6 Partiti oned T able S pace U sing SMS Dis tr i bution T est case 5 illustrates how it is possible to def ine a par tit ioned table space, allowing S MS to control t he allocation of each separate par tition. The aim is to distribute the diff e[...]

T es t C as es for D B 2 T abl e S pa ce D a ta S ets 179 A . 6 . 1D e f i n eV o l u m e s t o S M S S t o r a g e G r o u p The SMS Storage Group SGDBTEST , was ex panded to contai n eight disk v olumes. Figure 108 on page 179 shows the ISMF panel, option 6. 1 using the LISTV OL line command, to displa y the assigned v olum es. T able 30. T e st [...]

180 Storage Ma nagem ent with D B2 for OS /390 Figure 1 1 0. T est Case 5 - CREA TE T ABLESP ACE Ext ract A.6.4 D ata Set Allocation Results The follo wing res ults were displa yed once the table space was allocated. Figure 111 on page 180 s hows the ISPF data s et list display . F rom this figure we can see that one table space par t ition was all[...]

T es t C as es for D B 2 T abl e S pa ce D a ta S ets 181 Figure 11 2. T est C ase 5 - IS MF Storage G roup V olu me Disp lay Figure 113 on page 181 shows an ex t ract from an IDCAMS LI STCA T displa y of one of t he T able space par t itions defined in t his test, s ho wing the SMS attributes, and the space allocation in cylinders: Figure 11 3. T [...]

182 Storage Ma nagem ent with D B2 for OS /390 on page 182 s hows the v olume dis tribution. Figure 114 on page 182 shows the ISMF panel Storage Group l ist display ing the eight Storage Groups. T able 31. T e st Case 6 - Storage G roup V o lumes Figure 11 4. T est C ase 6 - ISMF Storage G roup Lis t A.7.2 ACS Routin es The f ollowing amendments we[...]

T es t C as es for D B 2 T abl e S pa ce D a ta S ets 183 Figure 11 5. T est C ase 6 - Stora ge Gro up AC S Routin e Extrac t A.7.3 D B2 Definiti o ns T wo ST OGROUPs were created in DB2P , (SG DBA000 and SGDBB000). Both ST OGROUP s hav e V OLUMES("*"), as in example of Figure 100 on page 172. D A T ABASE BP A OLOR1 is created using S T O[...]

184 Storage Ma nagem ent with D B2 for OS /390 Figure 1 1 6. T est Case 6 - CREA TE T ABLESP ACE Ext ract Figure 11 7. T est C ase 6 - IS MF Data S et Lis t Extract CREAT E TABLE SPACE A LPHA IN BPAOLO R1 USING STO GROUP SGDBA 000 .... NUMPAR TS 4 (PART 1 USING STOG ROUP SGDBA0 00 .... CREAT E TABLE SPACE B ETA IN BPAOLO R1 USING STO GROUP SGDBB 00[...]

© Cop yrig ht IBM Corp . 1999 185 Appendix B. Te s t C a s e s f o r DB2 R ecover y Data S et s This appendix show s a s election of test cases generated during the wr iting of this publication f or the definition of DB2 reco ver y dat a sets. T he follo wing tests are documented: 1. Allocation of BSDS and active logs using SMS. 2. Allocation of a[...]

186 Storage Ma nagem ent with D B2 for OS /390 Figure 11 8. ISM F Storage Class Definition for BSDS and A ctive Logs Figure 11 9. Stor age Clas s Routine Ex tract for BSD S and Active Logs B. 1.2 SMS Mana geme nt Clas s One Management Class, MCDBA CTL, was defined f or all B SDS and active log data sets of the three subsystems. Figure 120 on page 1[...]

T est Ca ses f or DB2 R ecov ery Data Se ts 187 Figure 12 0. Manag emen t Class R outine Ex tract f o r BSD S and Active Logs B.1.3 Sto ra ge Group Storage Group SGDB 2P LG w as defined for use by the BSDS and activ e l og data sets of the DB2P subsystem. F iv e disk v olumes were defined to this Storage Group: R V 1CU1, R V 2CU1 and R V 3CU1 f or [...]

188 Storage Ma nagem ent with D B2 for OS /390 Figure 121 on page 188 shows an ex tract of t he Storage Group AC S routine. Figure 12 1. Stor age Group R outin e Extract for BSDS and Active Log s B. 1.4 ISM F T est Ca ses Data set name patt ern DB2P .BSDS01.D A T A w as tested against the ac t iv e SMS configuration. Figure 122 on page 188 shows th[...]

T est Ca ses f or DB2 R ecov ery Data Se ts 189 Figure 12 3. ISM F T est Resul t for BS DS (2) B.1.5 D ata Set Allocation Results F ollowing the act iv at ion of the new SMS configuration, a number of data s ets were defined. Figure 124 on page 189 shows an ex t ract of the installat ion supplied IDCAMS parameters used to defi ne two BSDSs. Figure [...]

190 Storage Ma nagem ent with D B2 for OS /390 Figure 1 25. ISPF Data Set List of BSDS’ s Six active log data sets were also defined. Figure 126 on page 190 s ho ws an ex t ract of SYSPRINT m essages from t he out put of t he IDCAMS def inition batch j o bu s e df o r t h ea l l o c a t i o n . Figure 127 on page 191 s hows an ISPF data set lis t[...]

T est Ca ses f or DB2 R ecov ery Data Se ts 191 Figure 127. ISPF Data Set List of Activ e Lo gs It can be seen from the abov e the list, that t he use of the GUA RANTEED SP A CE parameter has allowed the e ven distri but ion of t he six fil es across the thr ee designated v olumes, ensur ing that opt imum perf or mance and a vailability are prov i [...]

192 Storage Ma nagem ent with D B2 for OS /390 Figure 12 8. Storage C lass R outine Inc or porating Ar chive Logs B.2.2 M anagem ent Class T wo Management Classes, MCDBICM and MCDBL V2, were added to the SMS configuration to separate primary and secondary archive log data s et s of t he three subsystems with diff er ent cr iteria. Figure 129 on pag[...]

T est Ca ses f or DB2 R ecov ery Data Se ts 193 B.2.3 Sto ra ge Group One Storage Group, SGDB ARCH, w as added for all archive log data sets of the three DB2 subsystems. Three disk v olum es, R V1CU0, RV 2CU0, and R V3CU0, were defined to the Storage Group as shown in T able 33 on page 193. Figure 130 on page 193 shows an ex tract of t he e x tende[...]

194 Storage Ma nagem ent with D B2 for OS /390 The f our data sets created w ere allocated successfully on disk v olumes assigned to S torage Group S GDBARCH. Figure 132 on page 194 s ho ws an ISPF dat a s et list to display all data s ets with a pat tern nam e of DB2P .ARCH* : Figure 13 2. ISPF D ata Set Lis t of Arch iv e L ogs Although all data [...]

T est Ca ses f or DB2 R ecov ery Data Se ts 195 • The naming standard for the data sets is shown in 3.8.5, “Image Cop y Names” on page 24, using as a hi gh le vel qualifier the subsystem identifier , follow ed by IC . This name inc ludes three codes in t he second qualifi er: Col 1 P or S to indicate pr imar y or secondar y cop y Col 2 S or H[...]

196 Storage Ma nagem ent with D B2 for OS /390 B.3.2 M anagem ent Class T wo additional Management Classes were defined; • MCDBICD fo r daily prim ar y image cop y dat a sets • MCDBICW f or weekly primar y i mage copy dat a sets Figure 120 on page 187 shows an e x tract of the Management Class ACS rout ine used in the pr ev ious t ests, now inc[...]

T est Ca ses f or DB2 R ecov ery Data Se ts 197 B.3.3 Sto ra ge Group T wo additional s tor age groups are defined to cater for image cop y data sets, SGDBIC and SGDICH. T able 34 on page 197 shows the dis tribution of volumes across all the storage g roups used in all t hree e xamples of this appendix. T able 34. Imag e Copies— Storage G roup V [...]

198 Storage Ma nagem ent with D B2 for OS /390 Figure 13 7. JC L for Im age Copy Allocatio n Figure 138 on page 198 shows an e x tr ac t of the JE S output messages generated from the above JCL: Figure 13 8. Im age Copy Allocatio n JE S Outp ut Messages Figure 139 on page 199 shows an ISPF dat a set list, displa ying the s ix image copies created i[...]

T est Ca ses f or DB2 R ecov ery Data Se ts 199 Figure 13 9. ISPF D ata Set Lis t of Image C opies Figure 140 on page 199 shows an IDCAMS LISTCA T displa y of the primar y and the secondar y image cop y c reated in this t est to backup the table space DSN8S61P . The display sho ws their SMS attributes and v ol ume allocation highlighted. Figure 14 [...]

200 Storage Ma nagem ent with D B2 for OS /390[...]

© Cop yrig ht IBM Corp . 1999 201 Appendix C. DB 2 PM Acco unti ng T r ace Re port 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 1-1 GROUP: BOAG ACCOUNTING TRACE - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:43:47.00 SUBSYSTEM: NB22 ACTUAL FROM: 02/12/99 15:43:45.28 DB2 VERSION: V5 ---- IDENTIFICATION ---[...]

202 Storage Ma nagem ent with D B2 for OS /390 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 1-2 GROUP: BOAG ACCOUNTING TRACE - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:43:47.00 SUBSYSTEM: NB22 ACTUAL FROM: 02/12/99 15:43:45.28 DB2 VERSION: V5 ---- IDENTIFICATION ----------------------------------------[...]

DB2 P M Acc ount ing T rac e Report 203 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 1-3 GROUP: BOAG ACCOUNTING TRACE - LONG REQUESTED FROM: 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:43:47.00 SUBSYSTEM: NB22 ACTUAL FROM: 02/12/99 15:43:45.28 DB2 VERSION: V5 ---- IDENTIFICATION ----------------------------------------- ------[...]

204 Storage Ma nagem ent with D B2 for OS /390[...]

© Cop yrig ht IBM Corp . 1999 205 Appendix D . DB2 PM Stat ist ics Repo r t 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-1 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 [...]

206 Storage Ma nagem ent with D B2 for OS /390 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-2 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS --[...]

DB2 P M Sta tist i cs Report 207 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-3 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS ----------------[...]

208 Storage Ma nagem ent with D B2 for OS /390 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-4 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS --[...]

DB2 P M Sta tist i cs Report 209 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-5 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS ----------------[...]

210 Storage Ma nagem ent with D B2 for OS /390 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-6 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS --[...]

DB2 P M Sta tist i cs Report 211 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-7 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS ----------------[...]

212 Storage Ma nagem ent with D B2 for OS /390 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-8 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS --[...]

DB2 P M Sta tist i cs Report 213 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-9 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS ----------------[...]

214 Storage Ma nagem ent with D B2 for OS /390 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-10 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS -[...]

DB2 P M Sta tist i cs Report 215 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-11 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS ---------------[...]

216 Storage Ma nagem ent with D B2 for OS /390 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-12 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS -[...]

DB2 P M Sta tist i cs Report 217 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-13 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS ---------------[...]

218 Storage Ma nagem ent with D B2 for OS /390 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-14 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS -[...]

DB2 P M Sta tist i cs Report 219 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-15 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS ---------------[...]

220 Storage Ma nagem ent with D B2 for OS /390 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-16 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS -[...]

DB2 P M Sta tist i cs Report 221 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-17 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS ---------------[...]

222 Storage Ma nagem ent with D B2 for OS /390 1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-18 GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM : 02/12/99 15:06:03.00 MEMBER: NB22 TO: 02/12/99 15:44:05.00 SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64 DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80 ---- HIGHLIGHTS -[...]

© Cop yrig ht IBM Corp . 1999 223 Appendix E. Disk St or age Ser v er Re por ts RMF EXTRACT R EPORTS CHAN NE L P AT H ACT IV IT Y OS/390 SYSTEM ID QP02 START 02/12/1999-15.05.39 INTERVAL 000.38.01 REL. 02.06.00 RPT VERSION 2.6.0 END 02/12/1999-15.43.41 CYCLE 1.000 SECONDS IODF = 29 NO CREATION INFORMATION AVAILABLE ACT: POR MODE: BASIC CPMF: AVAIL[...]

224 Storage Ma nagem ent with D B2 for OS /390 I / O QUEU IN G ACTIV IT Y OS/390 SYSTEM ID QP02 START 02/12/1999-15.05.39 INTERVAL 000.38.01 REL. 02.06.00 RPT VERSION 2.6.0 END 02/12/1999-15.43.41 CYCLE 1.000 SECONDS TOTAL SAMPLES = 2281 IOP ACTIVITY RATE AVG Q LNGTH IODF = 29 NO CREATION INFORMATION AVAILABLE ACT: POR 00 111.094 0.00 01 17.684 0.0[...]

Dis k Stor age Serv er Rep or ts 225 004C 0.000 0.00 0.00 2C80 0A 1.801 0.05 0.29 8C 1.832 0.02 0.33 95 1.811 0.12 0.10 C3 1.811 0.05 0.31 2C81 15 1.826 0.17 0.12 8F 1.822 0.12 0.26 C1 1.819 0.07 0.17 D2 1.816 0.05 0.38 004D 0.000 0.00 0.00 2CC0 0A 1.464 0.00 0.27 8C 1.452 0.06 0.36 95 1.463 0.00 0.24 C3 1.459 0.03 0.15 2CC1 15 1.465 0.00 0.12 8F 1[...]

226 Storage Ma nagem ent with D B2 for OS /390 RVA 1 1 CACH E SUB SY ST EM ACTI VI TY PAGE 1 OS/390 SYSTEM ID QP02 START 02/12/1999-15.05.39 INTERVAL 000.38.01 REL. 02.06.00 RPT VERSION 2.6.0 END 02/12/1999-15.43.41 SUBSYSTEM 3990-03 CU-ID 2B00 SSID 0088 CDATE 02/12/1999 CTIME 15.05.40 CINT 00.37.56 TYPE-MODEL 9393-002 -----------------------------[...]

Dis k Stor age Serv er Rep or ts 227 * 1 CACHE SUBSYSTEM ACTIVITY PAGE 1 OS/390 SYSTEM ID QP02 START 02/12/1999-15.05.39 INTERVAL 000.38.01 REL. 02.06.00 RPT VERSION 2.6.0 END 02/12/1999-15.43.41 0SUBSYSTEM 3990-03 CU-ID 2B40 SSID 0089 CDATE 02/12/1999 CTIME 15.05.40 CINT 00.37.56 TYPE-MODEL 9393-002 0-----------------------------------------------[...]

228 Storage Ma nagem ent with D B2 for OS /390 1 CACHE SUBSYSTEM ACTIVITY PAGE 1 OS/390 SYSTEM ID QP02 START 02/12/1999-15.05.39 INTERVAL 000.38.01 REL. 02.06.00 RPT VERSION 2.6.0 END 02/12/1999-15.43.41 0SUBSYSTEM 3990-03 CU-ID 2B80 SSID 008A CDATE 02/12/1999 CTIME 15.05.41 CINT 00.37.56 TYPE-MODEL 9393-002 0---------------------------------------[...]

Dis k Stor age Serv er Rep or ts 229 1 CACHE SUBSYSTEM ACTIVITY PAGE 1 OS/390 SYSTEM ID QP02 START 02/12/1999-15.05.39 INTERVAL 000.38.01 REL. 02.06.00 RPT VERSION 2.6.0 END 02/12/1999-15.43.41 0SUBSYSTEM 3990-03 CU-ID 2BC0 SSID 008B CDATE 02/12/1999 CTIME 15.05.41 CINT 00.37.56 TYPE-MODEL 9393-002 0-------------------------------------------------[...]

230 Storage Ma nagem ent with D B2 for OS /390 RVA 2 1 CACHE SUBSYSTEM ACTIVITY PAGE 1 OS/390 SYSTEM ID QP02 START 02/12/1999-15.05.39 INTERVAL 000.38.01 REL. 02.06.00 RPT VERSION 2.6.0 END 02/12/1999-15.43.41 0SUBSYSTEM 3990-03 CU-ID 2C00 SSID 2007 CDATE 02/12/1999 CTIME 15.05.40 CINT 00.37.56 TYPE-MODEL 9393-002 0---------------------------------[...]

Dis k Stor age Serv er Rep or ts 231 1 CACHE SUBSYSTEM ACTIVITY PAGE 1 OS/390 SYSTEM ID QP02 START 02/12/1999-15.05.39 INTERVAL 000.38.01 REL. 02.06.00 RPT VERSION 2.6.0 END 02/12/1999-15.43.41 0SUBSYSTEM 3990-03 CU-ID 2C40 SSID 2008 CDATE 02/12/1999 CTIME 15.05.41 CINT 00.37.56 TYPE-MODEL 9393-002 0-------------------------------------------------[...]

232 Storage Ma nagem ent with D B2 for OS /390 1 CACHE SUBSYSTEM ACTIVITY PAGE 1 OS/390 SYSTEM ID QP02 START 02/12/1999-15.05.39 INTERVAL 000.38.01 REL. 02.06.00 RPT VERSION 2.6.0 END 02/12/1999-15.43.41 0SUBSYSTEM 3990-03 CU-ID 2CA0 SSID 2009 CDATE 02/12/1999 CTIME 15.05.40 CINT 00.37.56 TYPE-MODEL 9393-002 0---------------------------------------[...]

Dis k Stor age Serv er Rep or ts 233 1 CACHE SUBSYSTEM ACTIVITY PAGE 1 OS/390 SYSTEM ID QP02 START 02/12/1999-15.05.39 INTERVAL 000.38.01 REL. 02.06.00 RPT VERSION 2.6.0 END 02/12/1999-15.43.41 0SUBSYSTEM 3990-03 CU-ID 2CC0 SSID 200A CDATE 02/12/1999 CTIME 15.05.41 CINT 00.37.56 TYPE-MODEL 9393-002 0-------------------------------------------------[...]

234 Storage Ma nagem ent with D B2 for OS /390 SYSTE M 1 CACHE SUBSYSTEM ACTIVITY PAGE 1 OS/390 SYSTEM ID QP02 START 02/12/1999-15.05.39 INTERVAL 000.38.01 REL. 02.06.00 RPT VERSION 2.6.0 END 02/12/1999-15.43.41 0SUBSYSTEM 3990-03 CU-ID 71C0 SSID 603C CDATE 02/12/1999 CTIME 15.05.41 CINT 00.37.56 TYPE-MODEL 3990-006 0-------------------------------[...]

Dis k Stor age Serv er Rep or ts 235 1 DIRE CT AC CE SS D EVICE A CTI VI TY OS/390 SYSTEM ID QP02 START 02/12/1999-15.05.39 INTERVAL 000.38.01 REL. 02.06.00 RPT VERSION 2.6.0 END 02/12/1999-15.43.41 CYCLE 1.000 SECONDS - TOTAL SAMPLES = 2,281 IODF = 29 NO CREATION INFORMATION AVAILABLE - DEVICE AVG AVG AVG AVG AVG AVG AVG AVG % % % AVG % % STORAGE [...]

236 Storage Ma nagem ent with D B2 for OS /390 IXFP EXTRACT REPORT S XSA/REPORTER DEVICE P ERFO RMANC E OVE RALL SUMM ARY SUBSYSTEM 20395 SUBSYSTEM % DEV I/O KBYTES ACCESS -I/O SERVICE TIME (MS)- % DEV % DEV % DEV SUMMARY AVAIL PER SEC PER SEC DENSITY TOTAL DISC CONNECT UTIL DISC CONN ----- ------- ------- ------- ----- ------ ------- ----- ----- -[...]

Dis k Stor age Serv er Rep or ts 237 XSA/REPORTER CACHE EFFE CTIV ENESS OVERALL SUM MARY 18FEB1999 17:32:04 SUBSYSTEM NAME: 20395 (CACHE SIZE: 1024 MB NVS SIZE: 8 MB) SUBSYSTEM READ WRITE I/O READ READ WRITE I/O DFW STAGE HITS/ LOW TRACK SUMMARY PER SEC PER SEC PER SEC RATIO HIT % HIT % HIT % CONSTR PER SEC STGE REF CT OCCUP ------- ------- -------[...]

238 Storage Ma nagem ent with D B2 for OS /390 XSA/REPORTER SPACE U TILIZ ATIO N SU MMARY REP ORT 17FEB1999 16:47:05 SUBSYSTEM 20395 (NUMBER OF FUNCTIONAL DEVIC ES: 256) SELECTED DEVICES SUMMARY FUNCTIONAL CAPACITY (MB) % FUNCT CAPACITY -------- DISK ARRAY -------- SELECTED TOTAL FUNCTIONAL NOT NOT -- PHYSICAL CAP USED (MB) -- COMP DEVICES CAPACITY[...]

© Cop yrig ht IBM Corp . 1999 239 Appendix F . S peci al N ot ice s This publication is intended to help managers and profes s ionals understand and ev aluat e the applicability of DFSMS/MVS functions to DB2 for OS/390. It also prov i des disk architecture bac kground i nf orm ation in order to make management and control of DB 2 data sets eas ier[...]

240 Storage Ma nagem ent with D B2 for OS /390 Any perf or mance data cont ained in this document was deter mined in a controll ed envir onm ent, and ther ef ore, the results t hat may be obtained in other operating envir onm ents may v ar y signifi cantly . Users of thi s document should v er ify the applicable data f or their specif ic environmen[...]

© Cop yrig ht IBM Corp . 1999 241 Append ix G. Rela te d Pu blicat ions The publications listed in this section are considered par ticularly s uitable f or a more detailed disc ussion of the topi cs cov ered in t his redbook. G.1 Internat ional T echni cal Support Org anization Public ations F or inf or mation on order ing these ITSO public at ion[...]

242 Storage Ma nagem ent with D B2 for OS /390 G.3 Other Pub lications These publications are also rele vant as fur ther inf or mation sources: • DB2 f or OS/390 V ersion 5 Administrat ion Guide , S C26-8957 • DB2 f or OS/390 V ersion 5 Command Ref erence , SC26-8960 • DB2 f or OS/390 V ersion 5 SQL Ref erence , S C26- 8966 • DB2 f or OS/39[...]

© Copyrigh t IBM Cor p . 19 99 243 Ho w to Get ITSO Re d books T his sect ion e xplai ns ho w both c ust ome rs and I BM emp loy ees ca n find o ut abou t ITSO r edbooks , red pieces , a nd CD -RO Ms . A f orm for or dering boo ks and CD-R OMs b y f ax or e-m ail is also pro vided . • Re dbook s W eb Site http://w ww.redbooks.i bm.com/ S earch f[...]

244 Storage M anage ment with D B2 for OS/390 IBM Redbook F ax Order Form Pl ea se sen d me t he foll o wing : We accept American Exp ress , Diners, Eurocard, Master C ard, and Visa. Pa y ment by cr edit card not a vailable in all countries. Signature mandatory for credit car d payme nt. Title Or de r Number Qua ntity First name Last nam e Com pany[...]

© Cop yrig ht IBM Corp . 1999 245 Lis t o f Ab brev iati on s AB ARS ag gre gat e backup a nd re cover y sup po r t AP AR a uthoriz ed progr am anal ysis repor t ARM a u tomatic restar t manager BLOB bina r y l arg e ob jec ts BSDS boot str a p dat a set CCW chann el c omm and word CEC cent ral e lec tr oni c s co mpl ex CF coupling f a cility CFR[...]

246 Storage Ma nagem ent with D B2 for OS /390 KSDS k e y-s equen ced da ta set LCU logica l cont rol unit LDS linear da ta set LLQ low le vel qualifier LP AR logic ally p a r titioned mode LRS N log r ecord s equen ce nu mber LRU le ast rec ent ly used MB me gab yte (1 ,048 ,576 byte s) MVS Mu lt iple Virt ual Storage NVS non- volat il e s to rag [...]

© Cop yrig ht IBM Corp . 1999 247 Index Numerics 3380 8 5 3390 8 5 A ABARS 30 abbrev i ations 245 accoun ting report 141 ACDS 35 ac r ony m s 245 ACS 36 ACS ro utines 80 ac t iv e c o nt ro l d at a s e t 35 active l og 18 sizing 18 active l og data sets defau l t nam es 23 active l og s ize 117 ADDVOL 30 ARCHIVE 19 ARCHIVE command 69 , 193 archiv[...]

248 Storage M anag ement with DB 2 for OS/390 DUMP 94 DFSMShsm 28 DFSMSopt 31 DFSMSrmm 31 DFW 91 direct or y 15 disk archi tecture 85 DMTH 106 DSN1COPY 22 DSNDB01 15 DSNDB01.SYSLGRNX 16 DSNDB06 15 DSNDB07 15 DSNJLOGF 115 DSNTIPD 15 DSNTIPE 92 DSNTIPL 112 , 116 , 117 DSNTIPN 17 , 117 DSS 27 comp onents 27 filte rin g 28 dual co py 93 DWQT 107 , 108 [...]

249 OPT 31 OUTPUT BUFFER 114 P partiti oned data sets 22 path 93 peer to peer re m ote cop y 93 peer- to-peer remot e copy 96 po licy 80 PPRC 93 , 96 prefetc h quantity 106 Q queui ng t ime 1 28 qu ickwrit e 92 R RAID 85 read oper ations 104 read re cord cachi ng 91 rec all 3 0 RECOVER 21 , 95 recov ery data sets 11 , 17 re co ve r y st ra t egy 18[...]

250 Storage M anag ement with DB 2 for OS/390 times t amp 100 track s ize 85 two-p hase commit 112 U user defi ned t able sp ace 14 V VDWQT 1 07 , 108 vertic al deferred write thres hold 107 virtua l concur r ent copy 95 virtua l v olum es 88 VTOC 26 W work dat abase 15 work tabl e spaces pa ge sizes 15 write freque ncy 108 write oper ati on s 107 [...]

© Cop yrig ht IBM Corp . 1999 251 IT SO Redb ook E val uati on S t or age Ma nagem ent wi th DB 2 f or OS/3 90 SG2 4 -54 62- 00 Y ou r fe edbac k is v er y imp or tant to he lp us mai ntain t he qua lity of I TSO re dbook s. Plea se com plete thi s que st i on na ire a nd r et u rn it us in g on e of t he fol low i ng me t hod s: • Use t he on l[...]

SG24- 5462-00 Printed i n t he U . S.A. Storage Management wit h DB2 for OS/390 SG24-5462-00[...]