> Formations > IMS Database Performance and Tuning (CMW30G)

Publication date : 12/13/2024

Course : IMS Database Performance and Tuning (CMW30G)

Official IBM course

Practical course - 5d - 35h00 - Ref. CM0
Price : 4450 € E.T.

IMS Database Performance and Tuning (CMW30G)

Official IBM course



With this course, you'll learn how to optimize IMS databases by mastering the features that influence performance. You'll explore dataset considerations, buffers for VSAM and OSAM, and apply a pre-deployment performance estimation method. Through hands-on practice, you will strengthen your skills in optimization and advanced management of IMS databases.


INTER
IN-HOUSE
CUSTOM

Practical course in person or remote class
Available in English on request

Ref. CM0
  5d - 35h00
4450 € E.T.




With this course, you'll learn how to optimize IMS databases by mastering the features that influence performance. You'll explore dataset considerations, buffers for VSAM and OSAM, and apply a pre-deployment performance estimation method. Through hands-on practice, you will strengthen your skills in optimization and advanced management of IMS databases.


Teaching objectives
At the end of the training, the participant will be able to:
Analyze performance data on the IMS database environment
Choose the IMS access methods that offer the best database performance
Improve performance by selecting database buffer pools
Improve performance by selecting buffer pool options
Improve performance with the right data set access method and storage attributes
Implement optimal performance options for VSAM datasets
Assess the need for secondary indexes and select implementation options to improve their performance
Choose physical database implementation options to improve performance
Select HDAM randomization parameters to improve the key randomization process

Intended audience
IMS system programmers, database administrators (DBAs) and technical support staff responsible for IMS database performance.

Prerequisites
Avoir suivi les cours IBM CM220 ou CMW22. Posséder une expérience de six à douze mois avec le système de base de données IMS.

Certification
Official course without certification.
Comment passer votre examen ?

Practical details
Teaching methods
Training in French. Official course material in digital format and in English. Good understanding of written English.

Course schedule

1
Official program

  • Introduction au réglage de la base de données IMS.
  • Introduction to the laboratory project.
  • Review of IMS access methods.
  • IMS database performance measurement.
  • Setting VSAM buffers.
  • Setting VSAM data sets.
  • Additional performance problems.
  • Setting secondary indexes.
  • HDAM setting.
  • Setting OSAM data sets and buffers.
  • Other setting considerations.
  • Summary of database settings.


Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class

Dernières places
Date garantie en présentiel ou à distance
Session garantie

REMOTE CLASS
2026 : 15 June, 7 Dec.

PARIS LA DÉFENSE
2026 : 15 June, 7 Dec.