IMS Database Design & Implemenation

Objectives
On successful completion of this course, attendees will be able to:

• define the IMS control blocks PSB and DBD
• describe the characteristics of HISAM, HDAM and HIDAM
• match the above organisations to a particular application
• describe GSAM and Secondary Indexes
• implement secondary indexes and logical relationships
• implement database housekeeping
• describe DBRC.

Who Should Attend
All staff who are responsible for the design and implementation of IMS Full Function databases, including systems analysts, database administrators and designers, performance analysts and system programmers.
Prerequisites
Knowledge of IMS fundamentals, gained through attendance of the course 'IMS Essentials', or experience of DL/1 programming. Familiarity with z/OS access methods, especially VSAM, an advantage.
Duration
5 days

Course Code
DISD
Contents
IMS Control Blocks
IMS - the Hierarchical Data Base Management System; Hierarchical terminology summary; Program Specification Block (PSB); PSB statements; PROCOPTs (1); PROCOPTs (2); PSB generation; ACB generation; PSB / program relationship; DBD; Database macro function; DBD handling; Application definition macro function; PSB handling; Dynamic PSB option.


IMS DB Organisations and Access Methods
DL/1 organisations and access methods: Full-function organisations: Fastpath organisations; HISAM: Insertion, Deletion; HISAM database definition; Hierarchical direct: Logical record, Free space; HIDAM (1): Characteristics , Available options, When to use; HIDAM (2): Database, Index; HIDAM database definition:Index database; HIDAM (3); HIDAM DBD: The Index DBD, The Body DBD; HDAM (1): Characteristics, Available options, When to use; HDAM (2); HDAM database definition; HDAM (3); Space management for HIDAM and HDAM; Hierarchic pointers; Physical child pointers; Physical twin pointers; Pointers in HIDAM and HDAM; Prefix format; Hybrid - SHISAM; Hybrid - GSAM; Examples.


IMS Advanced DB Design
Secondary indexing; Secondary data structure; Stand-alone processing; Things to consider; Secondary indexes; Secondary index DBDs; XDFLD statement; Logical relationships; Logical databases; DBDs; Logical rules; Logical databases and utilities; Backup and recovery; Logging; Log data sets; Online Log Data Sets (OLDS); Write-Ahead Data Sets (WADS); System Log Data Sets (SLDS); Recovery Log Data Set (RLDS); Restart Data Set (RDS); Archiving; Contents of the log; Backup; Image copy; Image copy; Change accumulation; Recovery; Time stamp recovery; Track recovery; Database Recovery Control (DBRC); Log control; Database recovery; Reorganisation; HISAM reorganisation; HD reorganisation; Additional reorganisation utilities; Reorganisation with secondary index; Reorganisation with logical relationships; Image copy; Change accumulation; Database recovery; Unload and reload.


IMS Data Base Recovery Control (DBRC)
DBRC overview; RECON initialization and structure; RECON records; Maintaining the RECONs; Migrating RECONs to new release; Skeletal JCL; Log maintenance JCL; Entering commands online; Batch command support; Database registration; RECON maintenance; Problems; Database Recovery Control; DBRC log control; DBRC database control.


IMS DB Implementation
Stages; DFSDDLT0; Using DFSDDLT0.


IMS DB Monitoring
Performance; DB performance; Program I/O report; Program summary report; Data base buffer pool report; VSAM buffer pool report; Data base failures; Write errors; Read errors; Examples.


Database Locking
8.1 Database locking; What is locked?; Rules for locking; PROCOPT = GOx; PROCOPT = E; Deadlocks.


High Availability Large Databases (HALDB)
Problem; Solutions; Partitioned Data Structure; Logical DB and Secondary Index Considerations.