Course Content
Database Concepts
- Definition of a Database
- Data Storage Methods
- Database Concepts
- Hierarchical Database Storage
- 3 Major Components of IMS
- IMS™ Database System
- IMS™ Components Overview
- Reasons for Using IMS/DB™
- IMS/DB™ Facilities
Database Structures
- IMS Hierarchical Structure
- IMS Database Record
- Twin Processing
- Design Consideration
- Sequential Processing
- Random Processing
- Program’s View of the Database
IMS Database Rules
- Concepts & Terminology Review
- Structure Quiz
- IMS Control Blocks
- Defining an IMS Database
- DBD Source
- DBD Generation Control Statements
- Defining the Program’s View of the Database
- PSB Source
- PSB Generation Control Statements
- Application Control Block
- Summary of IMS Libraries and
- Associated Control Blocks
Application Program Structure
- IMS™ Corrections to Application Program
- IMS™ Application Environment
- A Subprogram of IMS
- Requesting IMS Processing
- Communicating Processing Requests-DL/I Calls
- Parm Count
- Call Function
- Program Communication Block (PCB) Mask
- PCB Mask Format
- Application Interface Block (AIB) Mask Format
- I/O Area
- Segment Search Argument (SSA)
- SSA Format
- Building an SSA
- SSA Coding Rules
- SSA Relational Operator
- SSA Example
- SSA Example: Vendor SSA
- Vendor SSA Qualification Example
- SSA’s Multiple Level Call
- Status Code
- Basic IMS Program Components
Database Processing - Add
- Positioning
- Status Code Checking
- Insert Call
- ISRT Call Format
- Inserting a New Segment Occurrence
- Using the Insert to Load a Database
- Insert Processing Exercise
Database Processing – Retrieve
- Unique Call
- Get Unique Call Format
- Get Unique Call Example
- Get Next Call
- Get Next Call Format
- Get Next Call Example
- Retrieval Processing Exercise
- Parentage
- Get Next Within Parent Call
- Get Next Within Parent Call Format
- Get Next Within Parent Call Example
- Parentage Processing Exercise
- Database Processing – Update
- Get Hold Calls
- Get Hold Call Format
- Get Hold Call Example
- Replace Call
- Replace Call Format
- Replace Call Example
- Delete Call
- Delete Call Format
- Delete Call Example
- Update Processing Exercise
- Sequential Processing Review
- Direct/Random Processing Review
Command Codes
- What is a Command Code?
- SSA Format
- Command Code Example
- ‘D’ Command Code
- ‘N’ Command Code
- ‘F’ Command Code
- ‘L’ Command Code
- ‘C’ Command Code
- ‘P’ Command Code
- ‘Q’ Command Code
- ‘U’ Command Code
- ‘V’ Command Code
Miscellaneous Topics
- Using Boolean Operators in SSAs
- Boolean SSA Structure
- Boolean SSA Examples
- Types of IMS Programs
- IMS™ Access Methods
- GSAM
- HSAM
- SHSAM
- HISAM
- IMS Access Methods
- SHISAM
- HDAM
- HIDAM
- Summary of Access Methods
- Level Sensitivity
- Field Level Sensitivity Example
- Secondary Indexing Overview
- Secondary Indexing Segments
- Secondary Indexing Example
- Secondary Indexing PSB’s
- Secondary Indexing Processing Requests
- Secondary Indexing Limitations
Testing Under BTS II
- Overview of BTS
- BTS System Flow
- BTS Output
- BTS Commands - ./T
- T - Call Trace Features
- Defining Output - ./O
- Other BTS II Commands
