IMS Physical Organization of Databases Workshop

Code: CM22G

Description

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)

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

Topics

  • 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

Price (ex. VAT)

€ 3.040,00 per person

Duration

4 days

Schedule

  •  virtual
  •  02-09-2024 - 05-09-2024
  • register

  •  virtual
  •  28-10-2024 - 31-10-2024
  • register

Delivery methods

  • Classroom
  • On-site (at your location)
  • Virtual (instructor online)

Questions?

Write us and we will contact you to discuss your requirements
contact us