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.

• 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

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

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.

• 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

Prior to enrolling, IBM Employees must follow their Division/Department processes to obtain approval to attend this public training class. Failure to follow Division/Department approval processes may result in the IBM Employee being personally responsible for the class charges.

GBS practitioners that use the EViTA system for requesting external training should use that same process for this course. Go to the EViTA site to start this process:http://w3.ibm.com/services/gbs/evita/BCSVTEnrl.nsf

Once you enroll in a GTP class, you will receive a confirmation letter that should show:

• The current GTP list price
• The 20% discounted price available to IBMers. This is the price you will be invoiced for the class.