CM22 IMS Physical Organization of Databases Unit 12 (HALDB)

This unit provides an overview of the HALDB databases. Features and functions covered include:

• Database Partitioning

• The location and purpose of HALDB Indirect Pointers

• HALDB Online Reorganization

After completing this unit, you should be able to

•Describe the characteristics and benefits of HALDB databases

•Describe the contents of pointers found in the prefix of segments in HALDB databases

•Explain the contents and purpose of HALDB ILDS datasets

•Describe the operations of HALDB Online Reorganization

Student Notes : https://ibm.box.com/s/z7yf7vrj1t7lyfeg4q1fj4psf428azv3

0:01:22 HALDB (High Availability Large Database) 

0:25:29 HALDB Benefits 

0:29:46 HALDB Highlights

0:40:28 Database Reorganization 

0:43:29 Indirect Pointers

0:53:25 HALDB Database Data Sets 

0:55:42 HALDB Differences from HD Databases 

1:06:11 Direct and Indirect Pointers

1:08:05 Extended Pointer Set

1:11:10 HALDB Pointers

1:13:42 More on HALDB Pointers 

1:14:05 Definition Process 

1:14:36 Partition Selection

1:19:32 Partition Independence

1:20:55 Naming Conventions - Partition & DD Names

1:31:29 Naming Conventions - Data Set Names 

1:31:35 What DBRC Sees 

1:31:50 HALDB Migration 

1:32:12 HALDB Fallback 

1:32:39 Special Considerations for HALDB

1:33:59 HALDB Online Reorganization (OLR)

1:39:46 Copying Records During Reorganization

1:39:48 Application Access During Reorganization 

1:39:52 Completion of Reorganization