IMS Database Performance and Tuning

PT25939
Training Summary
This course is designed to provide you with the skills necessary to evaluate and improve the performance of your IMS databases (full function and HALDB only). Comprehensive alternatives and their implications on performance are discussed. Classroom exercises plus using your installation examples reinforces the topics presented in the lectures.
Prerequisites
A working knowledge of IMS database implementation as obtained by attending IMS Database Design & Implementation or equivalent on the job; application programming experience is not required.
Duration
5 Days/Lecture & Lab
Audience
Information Technology professionals (database administrators, system administrators, system programmers, and other technical support personnel) who want a detailed understanding of how to evaluate and improve the performance of their IMS databases.
Course Topics
  • Introduction to IMS DB Tuning Methodology
  • Measuring Performance
  • Review of IMS Databases
  • What to Bring to Class?
  • Tuning Buffers
  • Tuning Data Sets
  • Tuning HISAM
  • Tuning HIDAM/PHIDAM
  • Tuning HDAM/PHDAM
  • Tuning Secondary Indexes
  • Tuning Logical Relationships
  • Other Tuning Considerations
  • Tuning Summary
  • Daily Schedule

Related Scheduled Courses