Overview

Learn how to design, implement, reorganize, and recover Information Management System (IMS) databases. Practice these skills in intensive machine labs.

Audience

This is a basic level course for database administrators, system programmers, and other data administration individuals, who design, implement, and maintain IMS databases.

Prerequisites

You should have:

• basic understanding of IMS database features and organization along with a working knowledge of z/OS tools, Virtual Storage Access Method (VSAM) services utilities, and Job Control Language (JCL)

Objective

• Code the Database Directories (DBD) and Program Specification Blocks (PSB) for physical databases
• Code the DBDs and PSBs to implement secondary indexing
• Use the appropriate IMS utilities to reorganize and recover physical databases, including those with secondary indexes
• Use the DL/I test program
• Prepare a job stream to load a database using different IMS access methods

Course Outline

• Introduction to DL/I
• IMS Access Methods
• HISAM
• DBD/PSB/Data Sets/JCL
• IMS Test Utility: DFSDDLT0
• HD Access Methods
• HIDAM
• HDAM
• Database Reorganization
• IMS Data Sets Summary
• Secondary Indexing
• Database Recovery
• Database Design Considerations
• IMS Space Utilization