Course Overview
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.
IACET Continuing Education Units: 4.0
What you’ll learn
- 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 and 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
Requirements
- You should complete: IMS Physical Organization of Databases Workshop (U3722) or have four to six months experience with the IMS database system.
- Describe the physical storage and processing characteristics of Hierarchial Indexed Sequential Access Method (HISAM), Hierarchial Indexed Direct Access Method (HIDAM), and Hierarchial Direct Access Method (HDAM) access methods.
- Code the Data Base Definitions (DBD) and Program Specification Blocks (PSB) macros to implement secondary indexing, HISAM, HIDAM, and HDAM physical databases.
- Describe the physical storage characteristics of secondary indexes.
- Describe the PSB and programming requirements and processing characteristics when using a secondary index.
- Use the IMS utilities to load and reorganize logically related databases with secondary indexes.
- Use Virtual Storage Access Method (VSAM)s access method services to delete and define the Key-Sequenced Data Set (KSDS) and Entry-Sequenced Data Set (ESDS) data sets needed to support the database environment.
- Use reports created by the database tool's program, DBD/PSB/ACB MapperSpecify buffers for VSAM data set supported databases
Target audiences
- This intermediate course is for ndividuals interested in the performance of the IMS Database System.
Curriculum
- 1 Section
- 19 Lessons
- 40 Hours
Expand all sectionsCollapse all sections
- Topics19
- 1.1Introduction to IMS database tuning
- 1.2Introduction to the lab project
- 1.3Review of the IMS access methods
- 1.4Measuring IMS database performance
- 1.5Lab 1: The base case
- 1.6Lab 2: Using IMS Reports
- 1.7Tuning VSAM buffers
- 1.8Lab 3: Tuning VSAM buffers
- 1.9Tuning VSAM data sets
- 1.10Lab 4: Tuning VSAM data sets
- 1.11Additional performance issues
- 1.12Tuning secondary indexes
- 1.13Lab 5: Tuning secondary indexes
- 1.14Tuning HDAM
- 1.15Lab 6: Tuning HDAM
- 1.16Tuning OSAM data sets and buffers
- 1.17Lab 7: OSAM data sets and buffers
- 1.18Other tuning considerations
- 1.19Database tuning summary
Instructor
