IMS Database Performance and Tuning

PT25349
Training Summary
This course is designed to provide you with the skills necessary to evaluate and improve the performance of you 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 experience.
Duration
3 Days/Lecture & Lab
Audience
For 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
  • Intro to IMS DB Tuning
  • Measuring Performance
  • Review of HISAM,
  • HIDAM/PHIDAM,
  • HDAM/PHDAM
  • Bring your own DBDs for analysis
  • Tuning Buffers: VSAM & OSAM
  • Data Set Tuning: VSAM & OSAM
  • Tuning HISAM
  • Tuning HIDAM/PHIDAM
  • Tuning HDAM/PHDAM
  • Tuning Secondary Indexes
  • Tuning Logical Relationships
  • Other Tuning Considerations
  • Tuning Summary

Related Scheduled Courses