CM22G | IMS Physical Organization of Databases Workshop | Training Course | IBM. Skip to main Content

IMS Physical Organization of Databases Workshop

  • Course Code CM22G
  • Duration 4 days

Public Classroom Price

eur2.890,00

excl. VAT

Request Group Training Add to Cart

Course Delivery

This course is available in the following formats:

  • Class Connect HD

    Connect to a class in HD

  • Company Event

    Event at company

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

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
    • Delivery Format: Virtual Learning
    • Date: 08-11 October, 2024
    • Location: Virtual

    eur2.890,00

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)
    Cookie Control toggle icon