Back to Courses

IMS 15 Databases


4 hours


The IMS 15 Databases course covers in detail how data is stored within an IMS database and describes how it is referenced and accessed from a number of different sources. Instructions describing how to create database definitions, allocate databases and components, are also provided. IMS backup and recovery strategies are discussed as well as the use of maintenance utilities used in day-to-day operations.


This course is suitable for systems programmers, DBAs, operations staff, and application programmers.


Successful completion of the “IMS 15 Introduction” course or equivalent knowledge.


After completing this course, the student will be able to:

  • Describe how data is stored and accessed in an IMS database
  • Explain IMS database backup and recovery strategies
  • Describe why IMS Database reorganization is required and how it is run
  • List the products, programming languages, and interfaces that can be used to access IMS database content
  • Write code to create database definitions, and allocate database components

Course Content

IMS Database Concepts

IMS Database Structure
Segments and Fields
Parent and Child Segments
Database Paths and Views
How Programs Access IMS Data

Understanding IMS Database Access

Online and Batch Access
PCBs, PSBs, and ACBs
PSB Structure and Definitions
Coding DL/I Statements

Types of IMS Database Access

Db2 Stored Procedures
CICS Access
External Java Access
File Manager for z/OS
IMS Explorer

Creating an IMS Database

DBD Coding and Generation
Dynamically Created ACBs
SQL DDL Statements
Creating Databases and Indexes
Loading the Database

IMS Database Administration Tasks

Backup and Recovery Scenarios
Image Copies
Concurrent and Non-Concurrent Backups
Recovery Methods
Change Accumulation
Database Reorganization
Monitoring Database Performance

IMS Databases Mastery Test