Reorganizing Databases Using IMS Tools : A Detailed Look at the IBM IMS High Performance Tools.

Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Overview of IMS tools provided by IBM -- 1.1 IBM DB2 and IMS Tools for IMS overview and strategy -- 1.2 IMS Tools portfolio -- 1.3 Positioning the reorganization utilities and tools -- 1.3.1 IMS standard base utilities -- 1.3.2 IMS High Performance utilities set of products -- 1.3.3 IMS Parallel Reorganization -- 1.3.4 IMS HALDB online reorganization function of IMS Version 9 -- 1.4 Find out more about the current IMS Tools -- 1.5 Installation information -- Chapter 2. Database reorganization process -- 2.1 Why is reorganization necessary? -- 2.1.1 When to reorganize -- 2.1.2 Tuning guidelines -- 2.1.3 Monitoring the databases -- 2.1.4 Finding tuning information in HPPC reports -- 2.2 Reorganization processing overview -- 2.3 The reorganization process -- 2.3.1 Database unload processing -- 2.3.2 Defining databases -- 2.3.3 Prereorganization -- 2.3.4 Database scan -- 2.3.5 Database reload processing -- 2.3.6 Prefix resolution -- 2.3.7 Prefix update -- 2.3.8 Unload secondary index -- 2.3.9 Reload secondary index -- 2.4 Reorganization process using high performance tools -- 2.4.1 IMS High Performance Unload -- 2.4.2 Defining data sets -- 2.4.3 Prereorganization -- 2.4.4 IMS High Performance Load -- 2.4.5 IMS High Performance Prefix Resolution -- 2.4.6 Prefix update -- 2.4.7 IMS Index Builder -- 2.5 Reorganization process using IMS Parallel Reorganization -- 2.5.1 Prereorganization -- 2.5.2 Defining shadow databases -- 2.5.3 IMS parallel reorganization -- 2.5.4 Perform data set name swapping -- 2.5.5 IMS High Performance Prefix Resolution -- 2.5.6 Prefix update -- 2.5.7 IMS Index Builder -- Chapter 3. IMS High Performance Unload -- 3.1 IMS High Performance Unload overview.

3.2 Benefits of IMS HP Unload -- 3.2.1 Unload formats -- 3.3 Using IMS High Performance Unload -- 3.3.1 Unloading an HDAM database using FABHURG1 -- 3.3.2 Using IMS High Performance Unload with HALDB -- 3.3.3 Unloading a single partition of a PHDAM database using FABHURG1 -- 3.4 Unloading corrupted databases -- 3.4.1 Useful options and keywords in unloading corrupted databases -- 3.4.2 FABHURG1 options for unloading corrupted databases -- 3.4.3 FABHFSU options for unloading corrupted databases -- 3.4.4 Using the pointer bypass option for FABHFSU -- Chapter 4. IMS High Performance Load -- 4.1 IMS High Performance Load functions -- 4.2 Benefits of IMS High Performance Load -- 4.3 Reloading a non-HALDB database -- 4.3.1 Reloading a HDAM or HIDAM database -- 4.3.2 Reloading a HDAM or HIDAM database with output for Prefix Resolution -- 4.4 Reloading a HALDB database -- 4.4.1 Reloading a PHDAM or PHIDAM database -- 4.4.2 Re-partitioning a PHDAM or PHIDAM database -- 4.4.3 Initializing partitions -- 4.5 Reloading a corrupted database -- 4.5.1 Reloading a corrupted HIDAM or PHIDAM database -- 4.5.2 Reloading a corrupted HDAM or PHDAM database -- Chapter 5. IMS Index Builder -- 5.1 IMS Index Builder functions -- 5.2 Benefits of IMS Index Builder -- 5.3 Rebuilding a primary index -- 5.3.1 Rebuilding a primary index for non-HALDB -- 5.3.2 Rebuilding a primary index for HALDB -- 5.4 Creating and rebuilding secondary indexes -- 5.4.1 Creating new secondary indexes for non-HALDB -- 5.4.2 Rebuilding secondary indexes for non-HALDB -- 5.4.3 Rebuilding primary and secondary indexes for non-HALDB in one step -- 5.4.4 Rebuilding a secondary index during database reorganization -- 5.4.5 Rebuilding a secondary index using DFSURIDX input -- 5.4.6 Creating new secondary indexes for HALDB -- 5.4.7 Rebuilding secondary indexes for HALDB.

5.4.8 Rebuilding primary and secondary indexes for HALDB in one step -- Chapter 6. IMS High Performance Prefix Resolution -- 6.1 IMS High Performance Prefix Resolution overview -- 6.2 Benefits of IMS High Performance Prefix Resolution -- 6.3 Using IMS HPPR in reorganization processing -- 6.3.1 Use of IMS HPPR with IMS Index Builder -- 6.4 Executing IMS HPPR in a reorganization process -- 6.5 Recommendations to improve performance -- Chapter 7. IMS Parallel Reorganization -- 7.1 IMS Parallel Reorganization overview -- 7.2 Benefits of IPR Driver -- 7.3 IMS Parallel Reorganization interface -- 7.4 Using the IPR Driver for database reorganization -- 7.5 The steps to run a reorganization for a non-HALDB -- 7.5.1 Create the shadow database data sets -- 7.5.2 Set the correct DBRC authorization status -- 7.5.3 Run the IPR Driver step to reorganize the database -- 7.5.4 Run an image copy -- 7.5.5 Delete the old source database data sets -- 7.6 The steps to run a reorganization for a HALDB partition -- 7.6.1 Create the shadow database data sets -- 7.6.2 Set the correct DBRC authorization status -- 7.6.3 Run the IPR Driver step to reorganize a HALDB partition -- 7.6.4 Run an image copy -- 7.6.5 Delete the old source database data sets -- 7.7 Using the IMS Parallel Reorganization interface -- 7.7.1 Unload processing using the IMS Parallel Reorganization interface -- 7.7.2 Reload processing using the IPR interface -- 7.7.3 Reloading an empty HALDB partition -- 7.7.4 Reloading an empty HALDB -- Chapter 8. IMS Database Control Suite -- 8.1 IMS Database Control Suite functions -- 8.2 Benefits of IMS Database Control Suite -- 8.3 Overview of IMS Database Control Suite -- 8.4 Setting up IMS Database Control Suite -- 8.5 Using the installation verification procedure -- 8.6 Setting up the IMS DB Control Suite ISPF environment.

8.6.1 Adding a new CS ID or updating an existing one -- 8.6.2 Adding or removing IMS tools -- 8.6.3 Defining IMS DB Control Suite environment -- 8.6.4 Collecting and updating DBDS group data -- 8.7 Invoking utility and tool functions -- 8.7.1 Creating JCL and running jobs -- 8.7.2 Using IMS DB Control Suite for database space monitoring -- 8.7.3 Other main menu options -- 8.8 Examples -- Appendix A. IMS High Performance Pointer Checker -- Hierarchical Direct (HD) Pointer Checker -- Functions -- HD Tuning Aid -- Functions -- Typical uses -- DB Historical Data Analyzer -- Functions -- Space Monitor -- Functions -- Typical uses -- Database Segment Restructure -- Functions -- Appendix B. IMS Image Copy Extensions -- IMS Image Copy Extensions functions -- Benefits of IMS Image Copy Extensions -- Appendix C. IMS Database Recovery Facility -- IMS Database Recovery Facility functions and benefits -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover.

Description based on publisher supplied metadata and other sources.

Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.