IBM - Other Courses

logo

Tailored to Needs

Call Us: 01225 339705 Email: This email address is being protected from spambots. You need JavaScript enabled to view it. Address: Verhoef Training, 11 Kingsmead Square, Bath, BA1 2AB

  • Register

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)

Course Contents

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
Objectives
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

S5 Box

Login

Register