LEADER 09142nam 2200577Ia 450 001 9910823612003321 005 20200520144314.0 035 $a(CKB)1000000000243380 035 $a(SSID)ssj0000278486 035 $a(PQKBManifestationID)11212610 035 $a(PQKBTitleCode)TC0000278486 035 $a(PQKBWorkID)10246243 035 $a(PQKB)11197619 035 $a(MiAaPQ)EBC3306448 035 $a(Au-PeEL)EBL3306448 035 $a(CaPaEBR)ebr10112431 035 $a(OCoLC)939263373 035 $a(EXLCZ)991000000000243380 100 $a20031128d2003 uy 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt 182 $cc 183 $acr 200 00$aDB2 for z/OS tools for database administration and change management /$f[Paolo Bruni ... et. al.] 205 $a2nd ed. 210 $aSan Jose, CA $cIBM, International Technical Support Organization$d2003 215 $axxvii, 324 p. $cill 225 1 $aIBM redbooks 300 $a"July 2003." 300 $aRev. ed. of: DB2 for z/OS DM tools for database administration and change management / Bart Steegmans and others. 2002. 300 $a"SG24-6420-01." 311 $a0-7384-5314-5 320 $aIncludes bibliographical references (p. 317-318) and index. 327 $aFront cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Summary of changes -- July 2003, Second Edition -- Chapter 1. Introduction -- 1.1 Products overview -- 1.1.1 DB2 Administration Tool for z/OS -- 1.1.2 DB2 Object Comparison Tool for z/OS -- 1.2 Sample IT database environment -- 1.2.1 Development test -- 1.2.2 Acceptance test -- 1.2.3 Stress test -- 1.2.4 Production -- Chapter 2. First steps with DB2 Admin -- 2.1 First time in DB2 Admin -- 2.1.1 Customize your DB2 Admin parameters -- 2.2 Looking at database objects -- 2.2.1 Navigating the DB2 system catalog -- 2.2.2 Optimizing the SQL search -- 2.2.3 Showing the recovery status of a page set using the ICS command -- 2.2.4 Printing output to the print data set -- 2.3 Working with a copy of the DB2 system catalog -- 2.4 Showing data set information -- 2.5 Revoke impact -- 2.6 Drop impact -- 2.7 Connect to a remote DB2 system -- 2.8 Restart monitor -- 2.9 Using work statement lists -- 2.9.1 Work statement list basics -- 2.9.2 Create a work statement list -- 2.9.3 Working with a work statement list -- 2.9.4 Modify a work statement list -- 2.9.5 Executing a work statement list -- 2.9.6 Cloning a work statement list -- Part 1 Implementing an initial design (V0) -- Chapter 3. Developing DDL using DB2 Admin -- 3.1 Creating new DB2 objects from scratch (CRE) -- 3.1.1 Creating database DSG24D0 -- 3.1.2 Creating a storage group -- 3.1.3 Creating a table space -- 3.1.4 Creating a table into a table space -- 3.1.5 Creating an index on a table -- 3.1.6 Creating a view -- 3.1.7 Creating objects from the Create/Drop/Label/Comment On Objects panel -- 3.2 Creating new objects based on existing objects -- 3.2.1 Creating a limited number of objects (DDL). 327 $a3.2.2 Create many objects including dependencies (GEN) -- 3.3 Granting privileges -- 3.3.1 Granting privileges on a single object -- 3.3.2 Granting privileges on more than one object -- Chapter 4. Developing databases using generated DDL -- 4.1 Introduction -- 4.2 Create the Master Development Database (D0) -- 4.2.1 Use the modeling tool to define a physical model -- 4.2.2 Generate DDL from a modeling tool -- 4.2.3 Modify DDL with a REXX program -- 4.2.4 Create the database and all its objects -- 4.2.5 Routine database housekeeping tasks -- 4.2.6 Make physical changes to database -- Chapter 5. Rolling out the initial design (V0) -- 5.1 Using GENerate to clone a database -- 5.2 Create (clone) development databases (D1-D4) using MIG -- 5.2.1 Migration panels -- 5.2.2 Run migration source jobs -- 5.2.3 Run migration target jobs -- 5.3 Cloning to another DB2 subsystem -- 5.3.1 Migration panels -- 5.4 Cloning multiple physical databases -- 5.4.1 Using MIG(rate) - ADD function -- 5.4.2 Using DB2 Compare -- Part 2 Implementing changes to a design (Vn) -- Chapter 6. Modifying DB2 objects using DB2 Admin -- 6.1 Classifying changes performed using DB2 Admin -- 6.2 Altering database objects using the AL command -- 6.2.1 Adding a primary key to a table -- 6.3 Using the ALC command to implement table changes -- 6.3.1 Specify a column alteration online -- 6.3.2 Generate the job(s) or WSL to implement the changes -- 6.3.3 Run the ALC generated jobs -- 6.3.4 Altering primary key/foreign key columns using ALC -- 6.4 Changes in the technical design -- Chapter 7. Modifying the Master Development Database (D0) using generated DDL -- 7.1 Make changes to the database -- 7.1.1 Physical changes made to database -- 7.1.2 Logical changes made with a modeling tool -- 7.2 Generate and modify DDL -- 7.3 Use DB2 Compare panels -- 7.3.1 Specify Compare Source. 327 $a7.3.2 Specify Compare Target -- 7.3.3 Specify Compare Masks (optional) -- 7.3.4 Specify Ignore Fields (optional) -- 7.3.5 Generate Compare Jobs -- 7.4 Run compare jobs -- 7.5 Run apply jobs -- 7.5.1 Unload data -- 7.5.2 Drop objects -- 7.5.3 Create objects -- 7.5.4 Apply alter changes -- 7.5.5 Reload data -- 7.5.6 Reorganize table spaces -- 7.5.7 Rebind plans and packages -- Chapter 8. Rolling out new versions of a database design -- 8.1 Introduction -- 8.2 Creating version files -- 8.2.1 Create only a version file -- 8.2.2 Creating a version file as part of the compare operation -- 8.3 Comparing version files -- 8.3.1 Comparing versions of the same database -- 8.3.2 Comparing version to version - an example -- 8.3.3 Versioning comparing database to database -- 8.3.4 Comparing database to database - an example -- 8.3.5 Comparing both versioning techniques -- 8.4 Implementing the changes -- 8.4.1 Implementing changes using work statement list -- 8.4.2 Implementing changes using DB2 Compare jobs -- 8.5 Comparing versions - the full picture -- 8.6 Comparing databases - the full picture -- Part 3 Customization -- Chapter 9. Tailoring DB2 Admin and DB2 Compare -- 9.1 Allocating libraries -- 9.2 Tailoring ISPF skeleton libraries -- 9.3 Running the customization EXEC -- 9.4 Creating the checkpoint table -- 9.5 DB2 bind -- 9.6 MVS customization -- 9.6.1 When using DB2 security exit type AUTH -- 9.6.2 When running DB2 utilities from a WSL -- 9.6.3 Required changes -- 9.7 Use of catalog copies -- 9.7.1 Entry in the ADB2DB2D -- 9.7.2 Create the catalog version table -- 9.7.3 Create an entry in the catalog copy version table -- 9.8 Enable using commands for a remote system -- 9.9 Additional hints -- 9.10 Calling DB2 PM source explain from DB2 Admin -- Part 4 Appendixes -- Appendix A. Examples for generated DDL technique -- A.1 Generated DDL. 327 $aA.2 DDL modification program -- A.3 Modified DDL -- A.4 Skeleton CREATE DATABASE DDL -- A.5 Skeleton CREATE TABLESPACE DDL -- A.6 Skeleton GRANT table DDL -- A.7 Control file for sample database DDL modificaton program -- Appendix B. Cloning with MIGrate -- B.1 Jobs run on the source system -- B.1.1 Re-engineer the DDL (SST1RE) -- B.1.2 Re-engineered DDL source -- B.1.3 Unload data (SST2UL1) -- B.1.4 Load control file -- B.1.5 Load file -- B.1.6 Change load control file -- B.1.7 Changed load control file -- B.1.8 Data sets to transfer -- B.1.9 Delete source data sets -- B.2 Migration target jobs -- B.2.1 Create target objects -- B.2.2 Reload job -- B.2.3 Check data -- B.2.4 Delete target data sets -- B.3 Combining steps together -- B.3.1 Combined steps run on the source system (Job MD7F1SE) -- B.3.2 Combined steps run on the source system (Job MD7F1S1) -- B.3.3 Combined steps run on the target system (Job MD7F1T1) -- Appendix C. Examples using DB2 Compare -- C.1 Compare jobs -- C.1.1 S01DDL -- C.1.2 T02DB2 -- C.1.3 T03COMP -- C.1.4 Compare DDL to D0 - CHANGE file -- C.1.5 Compare DDL to D0 IFF file -- C.1.6 DDL to D0 compare results report -- C.1.7 T04GAPY -- C.2 Apply jobs -- C.2.1 Generated apply jobs -- C.2.2 Unload job -- C.2.3 Drop job -- C.2.4 Create job -- C.2.5 Alter job -- C.2.6 Reload job(s) -- C.2.7 Load control file - before convert -- C.2.8 Load control file - after convert -- C.2.9 Column conversion -- C.2.10 Load SYSPRINT output -- C.2.11 Reorg job -- C.2.12 Rebind job -- Appendix D. Additional material -- Locating the Web material -- Using the Web material -- How to use the Web material -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover. 410 0$aIBM redbooks. 606 $aDatabase management 615 0$aDatabase management. 676 $a005.74 701 $aBruni$b Paolo$0144515 712 02$aInternational Business Machines Corporation.$bInternational Technical Support Organization. 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910823612003321 996 $aDB2 for z$93945989 997 $aUNINA