IMS Database Design and Implementation

Information Technology professionals (database administrators, application programmers & designers, and production support personnel) who want a detailed understanding of the structure of and implementation options for IMS full-function and HALDB databases, including performance implications and guidelines.

Retail Price: $3,200.00

Next Date: Request Date

Course Days: 5


Request a Date

Request Custom Course


Objectives

Upon successful completion of this course, the student will be able to:

  • Choose the appropriate IMS database access method
  • Define optimization parameters for maximum efficiency
  • Describe the tools and techniques used in tuning existing structures

Prerequisites

A working knowledge of the IMS database environment as obtained by on the job work or attending IMS FUNDAMENTALS; programming experience is not required.


  1. The Project Life Cycle
    • Data requirements analysis
    • Data Element identification
    • Data Structures
    • Data Mapping
    • Database Design
    • Data Conflict resolution
  2. IMS Database Management System
    • Components of an IMS system
    • Hierarchic databases terminology and characteristics
    • Segment prefix area and pointers
    • The “LOAN” database and details
    • Database Positioning
  3. IMS Database Control Blocks
    • The control blocks used by IMS
    • Database Definition (DBD)
    • Program Communication Block (PCB)
    • Processing options
    • Program Specification Block (PSB)
    • Application Control Block (ACB)
  4. VSAM Review
    • VSAM Data Sets used by IMS
    • Entry Sequenced Data Set (ESDS)
    • Key Sequenced Data Set (KSDS)
    • CI / CA Splits
    • KSDS Index Architecture and performance issues
  5. IMS Access Methods Overview
    • z/OS Access Methods
    • IMS Access Methods
    • HSAM (Hierarchic Sequential Access Method): structure, limitations, usage, & DBD
    • HISAM (Hierarchic Indexed Sequential Access Method): structure, characteristics, retrieval, root insert, dependent segment insert, usage, performance implications, DBD, and exercise
    • GSAM (Generalized Sequential Access Method): special usage and definition
    • SHSAM & SHISAM (Simple HSAM & Simple SHISAM): usage and definition
    • HISAM Exercise
  6. IMS Direct Access Methods
    • Direct Points: types, usage by IMS
    • DBD Pointer Definition
    • Free space management
    • VSAM vs. OSAM comparision
    • HD Exercise
  7. HIDAM
    • Features
    • Structure (IMS View vs z/OS view)
    • Characteristics
    • Processing
    • Usage
    • HIDAM and primary index DBDs
  8. HDAM
    • Features
    • Structure: primary and overflow (IMS view vs z/OS view)
    • Characteristics
    • Loading
    • Synonyms
    • Processing
    • Usage
    • HDAM DBD
  9. HDAM Tuning
    • Design Goals
    • Performance Parameters: Randomizers, RAPs, BYTES
    • Calculations: RAPs, RAA, Overflow
    • Cascading
    • HDAM Exercise 1
    • HDAM Exercise 2
  10. Secondary Indexes
    • Terminology
    • Features
    • Definition
    • Creating unique keys
    • Storing duplicate data
    • Secondary data structure
    • Sparse indexing
    • Processing as a stand-alone database
    • PSB specifying secondary index processing
    • Performance considerations
    • Secondary Index Exercise
  11. Logical Relationships
    • Unidirectional: terminology, concatenated segment, logical view
    • Bidirectional physically paired: physical and logical views
    • Bidirectional Virtually Paired: physical and logical views
    • LR Pointers: Direct vs symbolic, DBD implementation
    • DBD examples
    • Insert / Delete / Replace rules
    • Logical relationship guidelines
    • Recursive structures and implementation
    • Performance consideration
  12. Miscellaneous Topics
    • Data set groups
    • Unkeyed and non-unique keyed segments
    • Variable length segments
    • Segment data compression
  13. HALDB
    • Overview
    • Structure: partitions, pointers, self healing pointer implementation
    • Naming conventions
    • Definition: DBD changes, DBD / SEGM / LCHILD examples, partition secondary index, exit routines
    • DBRC commands and records for partitions and data sets
    • Buffer pool specifications
    • Dynamic allocation
    • Partition selection for processing
    • Utilities specific to HALDB
    • Migration considerations
    • Application considerations


Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com


Request a Date