Overview

Learn about the Information Management System (IMS) High Availability Large Database (HALDB). Examine how databases may be migrated to HALDB and the advantages of using HALDB.

Audience

This is an intermediate course for IMS database administrators, who implement and manage HALDB.

Prerequisites

You should complete:

• Physical Organization of Databases (CM220) or
• Physical Organization of Databases - Web (CMW22)
• or have equivalent work experience.

You should have:

• working knowledge of IMS full function databases
• database administrator responsibilities for their support.

Objective

• Define HALDB databases and their partitions
• Understand database administrator responsibilities in managing HALDB
• Develop procedures for the support and recovery of HALDB
• Migrate databases to the use of HALDB
• Understand application design for HALDB

Course Outline

• Overview
• Database Structures
• Definition
• Partition Selection
• DBRC Support
• Database Commands
• Utilities
• Database Creation and Migration
• Changing Databases
• Secondary Indexes
• Application and Miscellaneous Considerations
• HALDB Online Reorganization
• Summary