The complete IMS HALDB guide : all you need to know to manage HALDBs / [Jouko Jantti ... et al.].

Format:

Book

Contributor:

Jäntti, Jouko.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Database management.

IMS (DL/I) (Computer system).

Physical Description:

xvi, 306 p. : ill.

Edition:

1st ed.

Other Title:

Information Management System High Availability Large Database

Place of Publication:

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

Language Note:

English

System Details:

text file

Summary:

This IBM Redbooks publication describes the High Availability Large Database (HALDB) capability available with IMS. IMS HALDB was introduced with IMS Version 7. It allows IMS databases to grow to almost unlimited sizes while providing increased availability. This book updates IMS Version 7 High Availability Large Database Guide, SG24-5751, as well as adding topics that were not covered in the previous book. This publication provides a broad explanation of HALDB and its uses. Specific areas covered include: -HALDB overview, definition, and structure -Migration from non-HALDB databases -Application considerations -HALDB database administration This publication documents our hands-on experience in a test environment. It includes migration and administration examples. Some IBM Data Management Tools for IMS are also discussed in this publication. Special emphasis is given to the IMS HALDB Conversion and Maintenance Aid product. Examples of the use of these tools are provided.

Contents:

Front cover

Contents

Notices

Trademarks

Preface

The team that wrote this redbook

Become a published author

Comments welcome

Part 1 HALDB overview

Chapter 1. HALDB introduction and structure

1.1 An introduction to High Availability Large Databases

1.2 Features and benefits

1.3 Candidates for HALDB

1.4 HALDB definition process

1.4.1 Database Recovery Control (DBRC)

1.5 DL/I processing

1.6 Logical relationships with HALDB

1.7 Partition selection

1.7.1 Partition selection using key ranges

1.7.2 Partition selection using a partition selection exit routine

1.8 Database structure

1.8.1 Partition ID and reorganization number

1.8.2 Segment structure

1.8.3 Extended pointer set (EPS)

1.8.4 Indirect list data set (ILDS)

1.8.5 Number of data sets

1.8.6 Special considerations for secondary indexes

1.9 Naming conventions

1.9.1 Partition names

1.9.2 DD names

1.9.3 Data set names

Chapter 2. Defining HALDB databases

2.1 Overview of HALDB definition

2.1.1 Design the logical structure of the database

2.1.2 Implement the logical structure with the DBDGEN process

2.1.3 Determine the partitioning scheme

2.1.4 Create the partitioning scheme

2.1.5 Database exit routines

2.1.6 System definition

2.1.7 Buffer pools

2.1.8 Dynamic allocation

2.2 DBDGEN differences for HALDB

Chapter 3. HALDB and DBRC

3.1 RECON records for HALDB

3.1.1 Master database record

3.1.2 Partition database record

3.1.3 Partition record

3.1.4 Partition DBDS record

3.2 Dynamic allocation

3.3 Authorization processing

3.4 Partition initialization

3.5 DBRC commands

3.5.1 INIT commands

3.5.2 CHANGE commands

3.5.3 DELETE commands

3.5.4 LIST commands

3.5.5 GENJCL commands

3.6 DBRC groups for HALDB

3.6.1 Change accumulation groups.

3.6.2 Database data set groups

3.6.3 Database groups

3.6.4 Recovery groups

3.7 Use of database names in DBRC commands

3.7.1 Commands that require a master database name

3.7.2 Commands that require a partition name

3.7.3 Commands that allow a master database or a partition name

3.7.4 DBRC commands that are not allowed with HALDB

Chapter 4. Partition Definition utility

4.1 Using the PDU

4.1.1 Configuring the PDU

4.1.2 Selecting a database

4.1.3 Setting HALDB master DBD parameters

4.1.4 Setting processing options and global partition information

4.1.5 Creating your partitions manually

4.1.6 Creating your partitions automatically

4.1.7 Changing partition definitions

4.1.8 Deleting definitions

Chapter 5. Batch definition of HALDB

5.1 Using the batch interface

5.2 DBRC initialization commands for HALDB

5.2.1 INIT.DB

5.2.2 INIT.PART

5.3 DBRC change commands for HALDB

5.3.1 CHANGE.DB

5.3.2 CHANGE.PART

5.3.3 CHANGE.DBDS

5.4 DBRC delete commands for HALDB

5.4.1 DELETE.DB

5.4.2 DELETE.PART

Chapter 6. Partition initialization

6.1 Partition initialization function

6.2 DBRC flags used with partition initialization

6.2.1 Partition initialization required (PINIT) flag

6.2.2 Image copy needed flag

6.3 Database Prereorganization utility

6.4 Database Partition Data Set Initialization utility

6.4.1 Unconditional partition initialization

Chapter 7. Partition selection

7.1 Choosing the type of partition selection

7.1.1 Key range partitioning

7.1.2 Partitioning with an exit routine

7.2 Writing partition selection exit routines

7.2.1 Partition selection exit routine functions

7.2.2 Information passed to and from the exit routine

7.2.3 Sample exit routine (DFSPSE00)

Part 2 Migration

Chapter 8. Migration from non-HALDB to HALDB.

8.1 General migration considerations

8.1.1 DBD changes

8.2 HALDB Migration Aid utility (DFSMAID0)

8.2.1 Reports

8.2.2 Adjusting the sizes from the reports

8.2.3 Control statements

8.3 Migrating simple databases

8.3.1 Unloading the existing database

8.3.2 Saving existing database information

8.3.3 Changing the DBD

8.3.4 Deleting database information from the RECONs

8.3.5 Defining the partitions

8.3.6 Allocating database data sets

8.3.7 Initializing the partitions

8.3.8 Reloading the HALDB database

8.3.9 Image copying the database data sets

8.4 ILDS creation options

8.4.1 HD Reload with no control statement

8.4.2 HD Reload with an ILDSMULTI control statement

8.4.3 HD Reload with a NOILDS control statement

8.5 Migrating databases with secondary indexes

8.5.1 Changing DBDs for secondary indexes

8.5.2 Estimating the sizes of secondary index partitions

8.5.3 Unloading databases with secondary indexes

8.5.4 Allocating secondary index data sets

8.5.5 Loading databases and their secondary indexes

8.5.6 Secondary index pointers after the migration

8.5.7 Using MIGRATE=YES with secondary indexes

8.6 Migrating databases with logical relationships

8.6.1 Changing DBDs with logical relationships

8.6.2 Changing DBDs with logical relationships

8.6.3 Unloading logically related databases for migration

8.6.4 Loading logically related databases for migration

8.6.5 Logical relationship pointers after the migration

8.7 Migrating from PDB or PDF

8.7.1 Partition selection

8.7.2 DBD changes

8.7.3 Using standard IMS utilities for the migration

8.7.4 Using application programs for the migration

8.7.5 Using PSU Unload and application programs for the migration

8.8 Migrating from user partitioning

8.8.1 Using application programs for the migration.

8.8.2 Using HD Unload and application programs for the migration

8.8.3 Warning on the use of HD Reload

8.9 Fallback to non-HALDB

8.9.1 Fallback with secondary indexes

8.9.2 Fallback with logical relationships

Chapter 9. Migration examples

9.1 Migration of HIDAM database to PHIDAM

9.1.1 Image copy of non-HALDB database data sets

9.1.2 Running the Migration Aid utility

9.1.3 Unloading the HIDAM database

9.1.4 Saving database information

9.1.5 Deleting the database from the RECONs

9.1.6 Changing the DBD and running the DBDGEN

9.1.7 Defining partitions with PDU

9.1.8 Allocate HALDB data sets

9.1.9 Initializing HALDB partitions

9.1.10 Loading HALDB database

9.1.11 Image copy HALDB data sets

9.1.12 ACBGEN

9.2 Migration of a database with a secondary index

9.3 Migrating a PDB database

Chapter 10. Using the HALDB Conversion and Maintenance Aid

10.1 HALDB Conversion and Maintenance Aid product

10.1.1 The conversion process overview

10.2 Activating the tool

10.2.1 Modifying the startup CLIST

10.2.2 Allocating the environment description data set

10.3 Migration example with HALDB Conversion tool

10.3.1 Define an IMS environment

10.3.2 Define a project

10.3.3 Process a conversion project

10.4 Additional functions

Part 3 Application considerations

Chapter 11. Application considerations

11.1 Initial loads

11.1.1 PHDAM considerations

11.1.2 PHIDAM considerations

11.1.3 Loading partitions in parallel

11.1.4 Initial loads of databases with secondary indexes

11.1.5 Initial loads of databases with logical relationships

11.2 Processing partitions in parallel

11.2.1 DBRC authorization of partitions

11.2.2 Parallel processing within an online system

11.2.3 Parallel processing with block level data sharing.

11.2.4 Parallel processing without block level data sharing

11.2.5 Program modifications for parallel processing

11.3 Restricting a PCB to one partition

11.3.1 Processing a partition sequentially

11.3.2 Requesting segments outside of the partition

11.3.3 Secondary index and logical relationship considerations

11.4 Handling unavailable partitions

11.4.1 Database PCB status code priming

11.5 Processing secondary indexes as databases

11.5.1 Secondary indexes with /SX fields

11.5.2 Secondary indexes with symbolic pointers

11.6 Handling test environments

11.6.1 DBRC registration

11.6.2 Testing with non-HALDB databases

11.7 Copying databases to different environments

11.7.1 The partition ID

11.7.2 Using image copies

11.7.3 Using unloads

11.7.4 Copying part of the data

11.7.5 Copying partition definitions

11.7.6 Timestamp recoveries to a copy

11.7.7 Planned enhancement for copying partition definitions

Part 4 Administration

Chapter 12. HALDB online commands

12.1 Online commands with HALDB

12.2 /DISPLAY command

12.2.1 Display of a HALDB master database

12.2.2 Display of a HALDB partition

12.3 /DBRECOVERY command

12.3.1 DBR of a HALDB master database

12.3.2 DBR of a HALDB partition

12.4 /DBDUMP command

12.4.1 DBD of a HALDB master database

12.4.2 DBD of a HALDB partition

12.5 /START command

12.5.1 Start of a HALDB master database

12.5.2 Start of a HALDB partition

12.6 /STOP command

12.6.1 Stop of a HALDB master database

12.6.2 Stop of a HALDB partition

12.7 /LOCK command

12.7.1 Lock of a HALDB master database

12.7.2 Lock of a HALDB partition

12.8 /UNLOCK command

12.8.1 Unlock of a HALDB master database

12.8.2 Unlock of a HALDB partition

12.9 Using the ALL keyword with commands

12.10 Commands while databases are in use.

12.11 Command examples.

Notes:

"June 2003."

"This book updates IMS Version 7 High Availability Large Database guide, SG24-5751"--Pref.

"SG24-6945-00."

Includes bibliographical references (p. 299-300) and index.

OCLC:

137342298