---

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: 4 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
• Describe the operational and performance implications of the various IMS database structures
• Describe the tools and techniques used in monitoring existing databases

Class Format: Lecture with classroom exercises and group discussion.

Cost: In-house: $6,800 for up to 15 students; $400 for each additional student.

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