IMS Physical Organization of Databases Workshop
Course code
CM22GUA
Duration
4 Days, 32 Acad. Hours
Course Overview
Objectives
Prerequisites
Course Outline
Course Overview
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
Prerequisites
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)
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
Request the training
IMS Physical Organization of Databases Workshop
Course code:
CM22GUA
Duration:
4 Days, 32 Acad. Hours
