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 the HALDB Online Reorganization process
- Describe the invocation and monitoring of HALDB Online Reorganization
- List the performance characteristics of HALDB Online Reorganization
0:00:36 Unit Objectives
0:02:02 Online Reorganization Overview
0:05:41 Online Reorganization Technique
0:07:48 HALDB Naming Conventions
0:11:52 Reorganization
0:22:57 Output Data Set Creation
0:30:51 Commands that show Reorg Status
0:32:20 Logging by Online Reorganization
0:33:35 Suspending and Restarting Online Reorg
0:35:00 Performance Considerations