IMS Physical Organization of Databases Workshop – CM22GCR

image_pdfCourse Outline PDF

Enrol   Details


Course Code: CM22G Brand: IBM Z – Information Management Solution Category: Systems Skill Level: Basic Duration: 32H Modality:CR      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:

_x000D_
_x000D_

    _x000D_

  • 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)
  • _x000D_

  Short Summary


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


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

  Topic


  • 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


    _x000D_

  • Code the Database Directories (DBD) and Program Specification Blocks (PSB) for physical databases
  • _x000D_

  • Code the DBDs and PSBs to implement secondary indexing
  • _x000D_

  • Use the appropriate IMS utilities to reorganize and recover physical databases, including those with secondary indexes
  • _x000D_

  • Use the DL/I test program
  • _x000D_

  • Prepare a job stream to load a database using different IMS access methods
  • _x000D_

Tags :
Call Now +27 72 266 2599