Home About Courses Schedule Services Webinars Contact Search

IMS HALDB (High Availability Large Data Base)


Duration: 1 day

Method: Instructor-led. Hands-on Workshops

Price: $600.00

Course Code: IM1097


Information Technology professionals (database administrators, application programmers & designers, and production support personnel) who are responsible for implementing and maintaining IMS HALDB databases.


This course is designed to provide you with the skills necessary to design, implement, migrate, and maintain IMS HALDB databases. Upon completion, you should be able to describe the structure of HALDB, install and migrate to HALDB, and use and maintain HALDB.


Working knowledge of the IMS databases (HIDAM, HDAM, Secondary Indexes, Logical Relationships), VSAM and OSAM access methods, and DBRC as obtained by on the job work or attending IMS FUNDAMENTALS and IMS DBRC; programming experience is not required.


  • I. HALDB Overview
    • What is it
    • Benefits
    • Highlights
    • Support
  • II. Structure: partitions, pointers, self-healing pointer implementation
    • New pointers
    • New prefixes
    • Self-healing
  • III. Naming conventions
  • IV. HALDB Definition:
    • DBD changes
    • DBD / SEGM / LCHILD examples
    • Partition secondary index
    • Exit routines
  • V. Partition & Data Set Definitions
    • DBRC commands
    • DBRC records
    • System Definition
    • Database buffers
    • Dynamic allocation
  • VI. Partition Selection
    • Key range
    • PS Exit routine
  • VII. HALDB Utilities
    • Partition Definition Utility
    • Partition Data Set Initialization
    • HALDB Index/ILDS Rebuild
    • HALDB Migration Aid
    • HALDB ALTER Utility
  • VIII. Migration considerations
    • Pointers
    • Structure
    • Primary index
    • Secondary index
    • Logical relationship
    • Miscellaneous operations
    • Application considerations
  • IX. Administration
    • Considerations
    • Backup and Recovery
    • Reorganizations
    • Changing Partitions
    • Test Databases
    • Secondary Index
    • Performance