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

Format:

Book

Contributor:

Bruni, Paolo.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Database management.

IBM Database 2.

z/OS.

Physical Description:

xxvii, 324 p. : ill.

Edition:

2nd ed.

Place of Publication:

San Jose, CA : IBM, International Technical Support Organization, 2003.

Language Note:

English

Contents:

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.

Notes:

"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."

Includes bibliographical references (p. 317-318) and index.

OCLC:

939263373