---

Physical Organization of IMS Databases

Course Abstract: This course provides the student with the skills necessary to support and monitor IMS full-function and Fast Path databases. A comprehensive analysis of the physical structures and their operational impact is presented. Classroom exercises reinforce topics presented in lectures.

Duration: 5 days

Primary Audience: Senior technical staff, including DBAs, system programmers and senior operations personnel, who require a detailed understanding of the physical organization of IMS full-function and Fast Path databases and their performance implications.

Prerequisites:

• A working knowledge of the IMS database environment.
• Programming experience is not required.

Course Objectives: Upon successful completion of this course, the student should be able to:

• Describe in detail the different types of IMS database structures, and space management techniques
• Identify the operational and performance implications of the various IMS database structures
• Identify and use the tools and techniques used in monitoring existing databases
• Generate and maintain IMS full-function databases, secondary indexes and logical relationships
• Use Image Copy to backup IMS databases Use Database Tools to monitor space usage, data distribution and performance

Class Format: Lecture with hands-on exercises

Cost: In-house: $8,500 for up to 15 students; $500 for each additional student. Public: $2,685.

Topics:

• Sequential and Direct Access Methods (HSAM, HISAM, SHSAM, SHISAM, GSAM, HDAM, HIDAM)
• Main Storage Databases (MSDBs), Data Entry Databases (DEDBs), Areas
• HDAM Randomizing Parameters
• Pointers (HF, HB, PCF, PCL, TF, TB)
• Dataset Groups
• Unkeyed Segments
• Secondary Indexing
• Tuning Considerations and Tools
• HDAM Randomizing Parameters
• HISAM Reorganization Unload/Reload
• Prefix Resolution/Update
• Image Copy
• Batch Backout
• Database Tools: Pointer Checker, HD Tuner, HD Physical Sort/Reload