CA - Interskill Learning Mainframe Training

CAEducation@ca.com

The Online Mainframe Training Specialists
Search   Course Catalog  
Return to Catalog Home     Return to Curriculum Listing

IMS Databases

Duration

4 hours

Overview

The IMS 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 “Introduction to IMS” 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

IMS Databases Mastery Test


Search our catalog