This is an intermediate level unit for DBAs that manage IMS DB. It is assumed the student has some knowledge about how databases are organized. This unit was recorded from a webinar given in December 2018
After completing the unit you should be able to:
- Describe application programming differences with HALDB
- Describe the method to limit a PCB to a set of partitions
- Describe the database availability information available to programs using HALDB
- Describe the updating of EPSs
- Describe the logging of HALDB updates
- Describe the use of OSAM Sequential Buffering with HALDB
- Describe the use of data set groups with HALDB
- Describe the use of database exit routines with HALDB
- Describe the use of dynamic allocation with HALDB
- Describe the HALDB support for data sharing and RSR
0:00:22 Unit Objectives
0:01:55 Processing a Secondary Index as a Database
0:07:09 Initial Loads
0:10:15 Initial Loads with Logical Relationships
0:14:02 Initial Loads with Secondary Indexes
0:17:32 Using the HALDB Control Statement
0:25:26 DL/I Calls with HALDB
0:27:43 Extended Pointer Set (EPS) Adjustments
0:31:05 Logging
0:33:48 OSAM Sequential Buffering
0:34:41 Data Set Groups
0:37:25 Database Exit Routines
0:38:56 Data Set Allocation
0:39:27 Data Sharing