IBM-training-courses

IMS Physical Organization of Databases Workshop

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

Read More
$3,880 USD
Course Code CM22G
Duration 4 days
Available Formats Classroom
6342 Reviews star_rate star_rate star_rate star_rate star_half
Course Image

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

Skills Gained

  • 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

Who Can Benefit

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 Details

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
Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward