Schulung - IBM CM30G - IMS Database Performance and Tuning

Zielgruppe

Audience

This intermediate course is for ndividuals interested in the performance of the IMS Database System.

Voraussetzungen

Prerequisites

You should complete:

• IMS Physical Organization of Databases Workshop (U3722)

or have four to six months experience with the IMS database system.

For additional prerequisites visit our Web site and search on U3720.

• 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