Duration
4 hours
Overview
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.
Audience
This course is suitable for systems programmers, DBAs, operations staff, and application programmers.
Prerequisites
Successful completion of the “IMS 15 Introduction” course or equivalent knowledge.
Objectives
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
PSBGEN
Coding DL/I Statements
Types of IMS Database Access
ODBA and DRA
APPLCTN Macro
Db2 Stored Procedures
CICS Access
External Java Access
REXX
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
DBRC
Database Reorganization
Monitoring Database Performance