Skip to main Content

IMS Physical Organization of Databases Workshop

  • Course Code CM22G
  • Duration 4 days

Course Delivery

Public Classroom Price

Please call

Request Group Training Add to Cart

Course Delivery

This course is available in the following formats:

  • Public Classroom

    Traditional Classroom Learning

Request this course in a different delivery format.

Course Overview

Top

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

Course Schedule

Top

Target Audience

Top

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

Course Objectives

Top
  • 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 Content

Top
  • 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
  •  

    Course Prerequisites

    Top

    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)