This course provides the student with the skills necessary to design, implement, and tune IMS database structures. Comprehensive physical design alternatives are discussed. Classroom exercises reinforce topics presented in lectures. The class format is lecture with classroom exercises and group discussion.
Before taking this course, a working knowledge of the IMS database environment; programming experience is not required.
5 Days/Lecture & Lab
This course is designed for senior technical staff, including DBAs and applications and production support personnel, who need a detailed understanding of the structure of IMS full-function and HALDB databases and their performance implications.
Data Requirements Analysis
- Overview of IMS Database Management System
- Database Control Blocks (DBD, PSB, ACB)
- VSAM in an IMS Database Environment
- Sequential and Direct Access Methods (HSAM, HISAM, SHISAM, GSAM, HDAM,
- HIDAM, INDEX)
- HALDB (PHDAM, PHIDAM, PSINDEX, ILDS)
- RAPs, Data Cascading, RAAs, MRBN
- Pointers (PCF, PCL, PTF, PTB)
- Dataset Groups
- Unkeyed Segments
- Logical Relationships
- Secondary Indexes
- Logical DBDs
- Logical Pointers (LP, LC, LTF, LTB, LCF, LCL)
- Tuning Considerations and Tools