You should complete:
- Physical Organization of Databases (CM220)
- or IMS Physical Organization of Databases Workshop - Web
the six to twelve months experience with the IMS database system needed to
understand IMS Database design choices.
includes being able to:
the physical storage and processing characteristics of Hierarchical
Indexed Sequential Access Method (HISAM), Hierarchical Indexed Direct
Access Method (HIDAM), and Hierarchical Direct Access Method (HDAM) access
the Data Base Definitions (DBD) and Program Specification Blocks (PSB)
macros to implement secondary indexing, HISAM, HIDAM, and HDAM physical
the physical storage characteristics of secondary indexes.
the PSB and programming requirements and processing characteristics when
using a secondary index.
the IMS utilities to load and reorganize logically related databases with
Virtual Storage Access Method (VSAM)s access method services to delete and
define the Key-Sequenced Data Set (KSDS) and Entry-Sequenced Data Set
(ESDS) data sets needed to support the database environment.
reports created by the database tool's program, DBD/PSB/ACB Mapper
buffers for VSAM data set supported databases