Audience
This intermediate course is for individuals interested in the performance of the IMS Database System.
Prerequisites
You should complete IMS Physical Organization of Databases Workshop - CM22G, or have four to six months experience with the IMS database system.
Duration
5 days. Hands on.
Course Objectives
Learn how to tune Information Management System (IMS) databases for use in IMS/Batch, IMS/Data Communications (DC), CICS-Local-Data Language One (DL/I), and Data Base Control (DBCTL) environments. Explore the IMS database features that affect performance such as data set considerations and buffers for VSAM and OSAM. You will also practice a method for estimating performance before implementation. Plus, you will reinforce the skills you have learned with seven machine labs.
Course Content
Analyze performance data about the IMS database environment
Choose IMS access methods that provide the best database performance
Improve performance by selecting database buffer pools and buffer pool options with the correct data set access method and storage attributes
Implement the optimum performance options for VSAM data sets at define and execute time
Evaluate the need for secondary indexes and select implementation options to improve their performance
Choose physical database implementation options to improve performance
Select HDAM randomizing parameters that can improve the key randomization process