IMS Physical Organization of Databases Workshop – cm22gpl
Course #: cm22gpl
Duration: 4 Days
Learn how to design, implement, reorganize, and recover Information Management System (IMS) databases. Practice these skills in intensive machine labs.
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
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)
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