Instruction/ maintenance manual of the product 5695-DF1 IBM
Go to page of 274
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.
.
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.
© Cop yrig ht IBM Corp . 1999 iii Contents Figures .......... ........... ................ ............ ..... x i Ta b l e s ..... ................. ........... ........... ........... x v Preface .... ........... ........... ........... ............
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 .
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 .
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 ........... ..........
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 .
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 . . ........... .
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..... ............. ...... ....
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 .
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 .
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.
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 .......
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.
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 Pat.
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.
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.
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.
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 .
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.
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 .
© 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.
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 .
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 .
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.
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.
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.
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.
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.
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 .
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.
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.
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.
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.
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.
© 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).
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).
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.
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.
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.
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 .
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.
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.
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).
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.
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.
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.
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 .
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.
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.
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.
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.
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.
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.
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.
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.
© 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 .
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 .
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.
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 .
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.
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 .
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.
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.
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 .
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.
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.
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.
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.
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 .
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.
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.
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 .
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.
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 guara.
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.
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 .
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.
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.
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.
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 .
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.
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.
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.
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.
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.
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.
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.
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.
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.
© 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.
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 • .
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.
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): •.
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.
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.
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 .
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.
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.
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 .
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.
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.
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 .
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.
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.
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.
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 .
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.
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.
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.
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.
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.
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 .
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 .
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 .
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 .
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.
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 ASY.
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 .
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.
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 .
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 .
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 .
© 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.
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 .
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.
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.
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 .
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 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.
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.
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.
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.
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, stag.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 .
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.
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 .
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.
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).
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 .
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 .
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.
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.
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 .
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.
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.
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.
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.
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.
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 ac.
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).
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 .
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.
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.
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.
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.
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.
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.
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 .
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 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.
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 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.
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 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.
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 /**** ******* ******* ******* ***.
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.
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.
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.
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 .
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.
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 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.
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 .
© 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.
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.
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.
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 .
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.
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 .
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 .
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.
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.
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 .
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 .
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.
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.
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.
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 .
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
© 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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)- % DE.
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 REA.
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 FUNCT.
© 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.
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 .
© 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.
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.
© 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 .
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.
© 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.
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 .
© 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 .
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.
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 ic.
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 .
© 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.
SG24- 5462-00 Printed i n t he U . S.A. Storage Management wit h DB2 for OS/390 SG24-5462-00.
An important point after buying a device IBM 5695-DF1 (or even before the purchase) is to read its user manual. We should do this for several simple reasons:
If you have not bought IBM 5695-DF1 yet, this is a good time to familiarize yourself with the basic data on the product. First of all view first pages of the manual, you can find above. You should find there the most important technical data IBM 5695-DF1 - thus you can check whether the hardware meets your expectations. When delving into next pages of the user manual, IBM 5695-DF1 you will learn all the available features of the product, as well as information on its operation. The information that you get IBM 5695-DF1 will certainly help you make a decision on the purchase.
If you already are a holder of IBM 5695-DF1, but have not read the manual yet, you should do it for the reasons described above. You will learn then if you properly used the available features, and whether you have not made any mistakes, which can shorten the lifetime IBM 5695-DF1.
However, one of the most important roles played by the user manual is to help in solving problems with IBM 5695-DF1. Almost always you will find there Troubleshooting, which are the most frequently occurring failures and malfunctions of the device IBM 5695-DF1 along with tips on how to solve them. Even if you fail to solve the problem, the manual will show you a further procedure – contact to the customer service center or the nearest service center
