DB2 for z/OS tools for database administration and change management / / [Paolo Bruni ... et. al.]

• Pubblicazione: San Jose, CA, : IBM, International Technical Support Organization, 2003
• Edizione: 2nd ed.
• Descrizione fisica: xxvii, 324 p. : ill
• Disciplina: 005.74
• Soggetto topico: Database management
• Altri autori: BruniPaolo
• Note generali: "July 2003."; Rev. ed. of: DB2 for z/OS DM tools for database administration and change management / Bart Steegmans and others. 2002.; "SG24-6420-01."
• Nota di bibliografia: Includes bibliographical references (p. 317-318) and index.
• Nota di contenuto: Front 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). ; 3.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. ; 7.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. ; A.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.
• Titolo autorizzato: DB2 for z
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910823612003321
• Lo trovi qui: Univ. Federico II
• Serie: IBM redbooks.