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.

This course is taught in a Web conference medium with live instructor audio, and Internet Web conferenced materials. You have chat type Questions and Answers (Q and A) ability, plus live audio. The course is taught 10:00 a.m. to 12 noon and 1:00 p.m. to 3:00 p.m. Central time for two work days. Since the class is taught live using Web conferencing methods, you can attend from your home or work. Class durations are approximately one-half day so you can still accommodate daily work responsibilities.

You will be contacted prior to class start to receive connection information, hardcopy materials, and other relevant information.

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 and 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 of HALDB
• Database Structures
• HALDB Definition
• Partition Selection
• Database Recovery Control (DBRC) Support
• Database Commands
• Utilities
• Database Creation and Migration
• Changing Databases
• Secondary Indexes
• Application and Miscellaneous Considerations
• HALDB Online Reorganization
• Summary