Administration Solutions for DB2 UDB for z/OS.
Redbooks, IBM.
Administration Solutions for DB2 UDB for z/OS. - 1st ed. - 1 online resource (356 pages)
Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction -- 1.1 DB2 DB/Tools today -- 1.2 Contents of this redbook -- Chapter 2. DB2 DB/WORKBENCH, DB2 Administration Tool and DB2 Object Restore -- 2.1 Overview -- 2.2 DB2 DB/WORKBENCH summary of relevant functions -- 2.3 Comparison between tools -- 2.3.1 Extract architecture -- 2.3.2 Catalog navigation -- 2.3.3 Revoke impact report -- 2.3.4 Drop impact report -- 2.3.5 DSNZPARM information -- 2.3.6 Estimate size information -- 2.3.7 Create new objects -- 2.3.8 Housekeeping -- 2.3.9 Customize your DB2 Administration Tool parameters -- 2.3.10 Display subsystem select -- 2.3.11 Global Commands -- 2.3.12 Utilities -- 2.3.13 Macros -- 2.3.14 RI Map -- 2.3.15 Accum Member -- 2.3.16 Migrate -- 2.3.17 DO Command -- 2.3.18 ? Command -- 2.3.19 Explain -- 2.3.20 Performance Queries -- 2.3.21 Work statement list -- 2.3.22 LISTDEFs and Templates -- 2.3.23 Showing index columns -- 2.4 DB2 Object Restore Tool -- 2.4.1 Building the versioning repository -- 2.4.2 How to restore a dropped object -- 2.5 Comparison summary -- Chapter 3. DB2 DB/QUICKCHANGE and DB2 Administration Tool -- 3.1 Overview -- 3.2 DB2 DB/QUICKCHANGE - Summary of relevant functions -- 3.3 Alter Database -- 3.3.1 DB2 DB/QUICKCHANGE - Alter Database -- 3.3.2 DB2 Administration Tool - Alter Database -- 3.4 Alter Tablespace -- 3.4.1 DB2 DB/QUICKCHANGE - Alter Table space -- 3.4.2 DB2 Administration Tool - Alter Table space -- 3.5 Alter Index -- 3.5.1 DB2 DB/QUICKCHANGE - Alter Index -- 3.5.2 DB2 Administration Tool - Alter Index -- 3.6 Alter Table -- 3.6.1 DB2 DB/QUICKCHANGE - Alter Table -- 3.6.2 DB2 Administration Tool - Alter Table -- 3.7 Migrate Database. 3.7.1 DB2 DB/QUICKCHANGE - Migrate Database -- 3.7.2 DB2 Administration Tool - Migrate Database -- 3.8 Comparing Manage and Save Sessions to the Work Statement Lists -- 3.8.1 DB2 DB/QUICKCHANGE - Manage and Save Sessions -- 3.8.2 DB2 Administration Tool - Manage Work Statement Lists -- 3.9 DB2 DB/QUICKCHANGE and DB2 Administration Tool functional mapping -- Chapter 4. DB2 DB/QUICKCOMPARE and DB2 Object Comparison Tool -- 4.1 Overview -- 4.2 DB2 DB/QUICKCOMPARE summary of relevant functions -- 4.3 The differences in detail -- 4.3.1 Dependencies -- 4.3.2 Term definitions -- 4.3.3 Processing -- 4.4 Implementing changes with DB2 Object Comparison Tool -- 4.4.1 Step 1: Specify a compare source -- 4.4.2 Step 2: Specify a compare target -- 4.4.3 Step 3: Specify compare masks -- 4.4.4 Step 4: Specify fields to ignore -- 4.4.5 Step 5: Generate a compare job -- 4.4.6 Analyze compare reports -- 4.4.7 Run the work statement list -- 4.5 Save, manage and restore dialogs -- 4.6 Cross-reference of functions -- 4.7 Summary -- Chapter 5. DB2 DB/SMU and DB2 Automation Tool -- 5.1 Overview -- 5.2 DB2 DB/SMU function summary -- 5.3 DB2 Automation Tool function summary -- 5.3.1 Function cross-reference -- 5.4 Comparison between utility processes -- 5.4.1 ISPF interface -- 5.4.2 Object profiles -- 5.4.3 Utility profiles -- 5.4.4 Exception profiles -- 5.4.5 Job profiles -- 5.4.6 Data set manager -- 5.4.7 Data page display -- 5.4.8 Disaster recovery -- 5.5 DB2 Automation Tool operational scenario -- 5.5.1 Step 1: Create object profile -- 5.5.2 Step 2: Create utility profile -- 5.5.3 Step 3: Create exception profile (optional) -- 5.5.4 Step 4: Create job profile -- 5.5.5 Step 5: Build job -- 5.5.6 Managing profiles -- 5.5.7 Quick Build -- 5.6 Comparison summary -- 5.7 DB2 Automation Tool for z/OS V2.2 highlights -- Chapter 6. Using DB2 Tools with DB2 UDB for z/OS Version 8. 6.1 Current status -- 6.2 DB2 Administration Tool -- 6.2.1 Support for long names -- 6.2.2 DDL and GEN commands -- 6.2.3 Viewing extracted SQL for packages and plans -- 6.2.4 Alter table enhancements -- 6.2.5 Alter and add partitions -- 6.2.6 Rotate partitions -- 6.2.7 Materialized query tables -- 6.2.8 Sequence objects -- 6.3 DB2 Object Comparison Tool -- 6.3.1 Alter Table Alter Column -- 6.3.2 Alter a partitioned table -- Appendix A. Sample work statement list -- Appendix B. Working with a copy of DB2 system catalog -- B.1 ADBCUST job - 1 step -- B.2 ADBCATVT job - 2 step -- B.3 DDLBNDxx job - 3 step -- B.4 CPYRUNxx job - 4 step -- B.5 Run ALIBNDxx for distributed system -- Appendix C. Current maintenance -- C.1 Maintenance for DB2 administration tools -- Appendix D. Sample JCL for a Restore Job -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover.
9780738490595
Electronic data processing -- Backup processing alternatives.
Data recovery (Computer science).
Electronic books.
QA76.9.D3 -- A36 2005eb
005.75/65
Administration Solutions for DB2 UDB for z/OS. - 1st ed. - 1 online resource (356 pages)
Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction -- 1.1 DB2 DB/Tools today -- 1.2 Contents of this redbook -- Chapter 2. DB2 DB/WORKBENCH, DB2 Administration Tool and DB2 Object Restore -- 2.1 Overview -- 2.2 DB2 DB/WORKBENCH summary of relevant functions -- 2.3 Comparison between tools -- 2.3.1 Extract architecture -- 2.3.2 Catalog navigation -- 2.3.3 Revoke impact report -- 2.3.4 Drop impact report -- 2.3.5 DSNZPARM information -- 2.3.6 Estimate size information -- 2.3.7 Create new objects -- 2.3.8 Housekeeping -- 2.3.9 Customize your DB2 Administration Tool parameters -- 2.3.10 Display subsystem select -- 2.3.11 Global Commands -- 2.3.12 Utilities -- 2.3.13 Macros -- 2.3.14 RI Map -- 2.3.15 Accum Member -- 2.3.16 Migrate -- 2.3.17 DO Command -- 2.3.18 ? Command -- 2.3.19 Explain -- 2.3.20 Performance Queries -- 2.3.21 Work statement list -- 2.3.22 LISTDEFs and Templates -- 2.3.23 Showing index columns -- 2.4 DB2 Object Restore Tool -- 2.4.1 Building the versioning repository -- 2.4.2 How to restore a dropped object -- 2.5 Comparison summary -- Chapter 3. DB2 DB/QUICKCHANGE and DB2 Administration Tool -- 3.1 Overview -- 3.2 DB2 DB/QUICKCHANGE - Summary of relevant functions -- 3.3 Alter Database -- 3.3.1 DB2 DB/QUICKCHANGE - Alter Database -- 3.3.2 DB2 Administration Tool - Alter Database -- 3.4 Alter Tablespace -- 3.4.1 DB2 DB/QUICKCHANGE - Alter Table space -- 3.4.2 DB2 Administration Tool - Alter Table space -- 3.5 Alter Index -- 3.5.1 DB2 DB/QUICKCHANGE - Alter Index -- 3.5.2 DB2 Administration Tool - Alter Index -- 3.6 Alter Table -- 3.6.1 DB2 DB/QUICKCHANGE - Alter Table -- 3.6.2 DB2 Administration Tool - Alter Table -- 3.7 Migrate Database. 3.7.1 DB2 DB/QUICKCHANGE - Migrate Database -- 3.7.2 DB2 Administration Tool - Migrate Database -- 3.8 Comparing Manage and Save Sessions to the Work Statement Lists -- 3.8.1 DB2 DB/QUICKCHANGE - Manage and Save Sessions -- 3.8.2 DB2 Administration Tool - Manage Work Statement Lists -- 3.9 DB2 DB/QUICKCHANGE and DB2 Administration Tool functional mapping -- Chapter 4. DB2 DB/QUICKCOMPARE and DB2 Object Comparison Tool -- 4.1 Overview -- 4.2 DB2 DB/QUICKCOMPARE summary of relevant functions -- 4.3 The differences in detail -- 4.3.1 Dependencies -- 4.3.2 Term definitions -- 4.3.3 Processing -- 4.4 Implementing changes with DB2 Object Comparison Tool -- 4.4.1 Step 1: Specify a compare source -- 4.4.2 Step 2: Specify a compare target -- 4.4.3 Step 3: Specify compare masks -- 4.4.4 Step 4: Specify fields to ignore -- 4.4.5 Step 5: Generate a compare job -- 4.4.6 Analyze compare reports -- 4.4.7 Run the work statement list -- 4.5 Save, manage and restore dialogs -- 4.6 Cross-reference of functions -- 4.7 Summary -- Chapter 5. DB2 DB/SMU and DB2 Automation Tool -- 5.1 Overview -- 5.2 DB2 DB/SMU function summary -- 5.3 DB2 Automation Tool function summary -- 5.3.1 Function cross-reference -- 5.4 Comparison between utility processes -- 5.4.1 ISPF interface -- 5.4.2 Object profiles -- 5.4.3 Utility profiles -- 5.4.4 Exception profiles -- 5.4.5 Job profiles -- 5.4.6 Data set manager -- 5.4.7 Data page display -- 5.4.8 Disaster recovery -- 5.5 DB2 Automation Tool operational scenario -- 5.5.1 Step 1: Create object profile -- 5.5.2 Step 2: Create utility profile -- 5.5.3 Step 3: Create exception profile (optional) -- 5.5.4 Step 4: Create job profile -- 5.5.5 Step 5: Build job -- 5.5.6 Managing profiles -- 5.5.7 Quick Build -- 5.6 Comparison summary -- 5.7 DB2 Automation Tool for z/OS V2.2 highlights -- Chapter 6. Using DB2 Tools with DB2 UDB for z/OS Version 8. 6.1 Current status -- 6.2 DB2 Administration Tool -- 6.2.1 Support for long names -- 6.2.2 DDL and GEN commands -- 6.2.3 Viewing extracted SQL for packages and plans -- 6.2.4 Alter table enhancements -- 6.2.5 Alter and add partitions -- 6.2.6 Rotate partitions -- 6.2.7 Materialized query tables -- 6.2.8 Sequence objects -- 6.3 DB2 Object Comparison Tool -- 6.3.1 Alter Table Alter Column -- 6.3.2 Alter a partitioned table -- Appendix A. Sample work statement list -- Appendix B. Working with a copy of DB2 system catalog -- B.1 ADBCUST job - 1 step -- B.2 ADBCATVT job - 2 step -- B.3 DDLBNDxx job - 3 step -- B.4 CPYRUNxx job - 4 step -- B.5 Run ALIBNDxx for distributed system -- Appendix C. Current maintenance -- C.1 Maintenance for DB2 administration tools -- Appendix D. Sample JCL for a Restore Job -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover.
9780738490595
Electronic data processing -- Backup processing alternatives.
Data recovery (Computer science).
Electronic books.
QA76.9.D3 -- A36 2005eb
005.75/65