12320nam 2200661Ia 450 991081000070332120200520144314.0(CKB)1000000000243364(SSID)ssj0000278100(PQKBManifestationID)11192710(PQKBTitleCode)TC0000278100(PQKBWorkID)10245998(PQKB)11339078(Au-PeEL)EBL3306859(CaPaEBR)ebr10113017(OCoLC)137342298(CaSebORM)0738453439(MiAaPQ)EBC3306859(OCoLC)830001096(OCoLC)ocn830001096 (EXLCZ)99100000000024336420031206d2003 uy 0engurcn|||||||||txtccrThe complete IMS HALDB guide all you need to know to manage HALDBs /[Jouko Jantti ... et al.]1st ed.San Jose, CA IBM, International Technical Support Organization2003xvi, 306 p. illIBM redbooks"June 2003.""This book updates IMS Version 7 High Availability Large Database guide, SG24-5751"--Pref."SG24-6945-00."0-7384-5343-9 Includes bibliographical references (p. 299-300) and index.Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Part 1 HALDB overview -- Chapter 1. HALDB introduction and structure -- 1.1 An introduction to High Availability Large Databases -- 1.2 Features and benefits -- 1.3 Candidates for HALDB -- 1.4 HALDB definition process -- 1.4.1 Database Recovery Control (DBRC) -- 1.5 DL/I processing -- 1.6 Logical relationships with HALDB -- 1.7 Partition selection -- 1.7.1 Partition selection using key ranges -- 1.7.2 Partition selection using a partition selection exit routine -- 1.8 Database structure -- 1.8.1 Partition ID and reorganization number -- 1.8.2 Segment structure -- 1.8.3 Extended pointer set (EPS) -- 1.8.4 Indirect list data set (ILDS) -- 1.8.5 Number of data sets -- 1.8.6 Special considerations for secondary indexes -- 1.9 Naming conventions -- 1.9.1 Partition names -- 1.9.2 DD names -- 1.9.3 Data set names -- Chapter 2. Defining HALDB databases -- 2.1 Overview of HALDB definition -- 2.1.1 Design the logical structure of the database -- 2.1.2 Implement the logical structure with the DBDGEN process -- 2.1.3 Determine the partitioning scheme -- 2.1.4 Create the partitioning scheme -- 2.1.5 Database exit routines -- 2.1.6 System definition -- 2.1.7 Buffer pools -- 2.1.8 Dynamic allocation -- 2.2 DBDGEN differences for HALDB -- Chapter 3. HALDB and DBRC -- 3.1 RECON records for HALDB -- 3.1.1 Master database record -- 3.1.2 Partition database record -- 3.1.3 Partition record -- 3.1.4 Partition DBDS record -- 3.2 Dynamic allocation -- 3.3 Authorization processing -- 3.4 Partition initialization -- 3.5 DBRC commands -- 3.5.1 INIT commands -- 3.5.2 CHANGE commands -- 3.5.3 DELETE commands -- 3.5.4 LIST commands -- 3.5.5 GENJCL commands -- 3.6 DBRC groups for HALDB -- 3.6.1 Change accumulation groups.3.6.2 Database data set groups -- 3.6.3 Database groups -- 3.6.4 Recovery groups -- 3.7 Use of database names in DBRC commands -- 3.7.1 Commands that require a master database name -- 3.7.2 Commands that require a partition name -- 3.7.3 Commands that allow a master database or a partition name -- 3.7.4 DBRC commands that are not allowed with HALDB -- Chapter 4. Partition Definition utility -- 4.1 Using the PDU -- 4.1.1 Configuring the PDU -- 4.1.2 Selecting a database -- 4.1.3 Setting HALDB master DBD parameters -- 4.1.4 Setting processing options and global partition information -- 4.1.5 Creating your partitions manually -- 4.1.6 Creating your partitions automatically -- 4.1.7 Changing partition definitions -- 4.1.8 Deleting definitions -- Chapter 5. Batch definition of HALDB -- 5.1 Using the batch interface -- 5.2 DBRC initialization commands for HALDB -- 5.2.1 INIT.DB -- 5.2.2 INIT.PART -- 5.3 DBRC change commands for HALDB -- 5.3.1 CHANGE.DB -- 5.3.2 CHANGE.PART -- 5.3.3 CHANGE.DBDS -- 5.4 DBRC delete commands for HALDB -- 5.4.1 DELETE.DB -- 5.4.2 DELETE.PART -- Chapter 6. Partition initialization -- 6.1 Partition initialization function -- 6.2 DBRC flags used with partition initialization -- 6.2.1 Partition initialization required (PINIT) flag -- 6.2.2 Image copy needed flag -- 6.3 Database Prereorganization utility -- 6.4 Database Partition Data Set Initialization utility -- 6.4.1 Unconditional partition initialization -- Chapter 7. Partition selection -- 7.1 Choosing the type of partition selection -- 7.1.1 Key range partitioning -- 7.1.2 Partitioning with an exit routine -- 7.2 Writing partition selection exit routines -- 7.2.1 Partition selection exit routine functions -- 7.2.2 Information passed to and from the exit routine -- 7.2.3 Sample exit routine (DFSPSE00) -- Part 2 Migration -- Chapter 8. Migration from non-HALDB to HALDB.8.1 General migration considerations -- 8.1.1 DBD changes -- 8.2 HALDB Migration Aid utility (DFSMAID0) -- 8.2.1 Reports -- 8.2.2 Adjusting the sizes from the reports -- 8.2.3 Control statements -- 8.3 Migrating simple databases -- 8.3.1 Unloading the existing database -- 8.3.2 Saving existing database information -- 8.3.3 Changing the DBD -- 8.3.4 Deleting database information from the RECONs -- 8.3.5 Defining the partitions -- 8.3.6 Allocating database data sets -- 8.3.7 Initializing the partitions -- 8.3.8 Reloading the HALDB database -- 8.3.9 Image copying the database data sets -- 8.4 ILDS creation options -- 8.4.1 HD Reload with no control statement -- 8.4.2 HD Reload with an ILDSMULTI control statement -- 8.4.3 HD Reload with a NOILDS control statement -- 8.5 Migrating databases with secondary indexes -- 8.5.1 Changing DBDs for secondary indexes -- 8.5.2 Estimating the sizes of secondary index partitions -- 8.5.3 Unloading databases with secondary indexes -- 8.5.4 Allocating secondary index data sets -- 8.5.5 Loading databases and their secondary indexes -- 8.5.6 Secondary index pointers after the migration -- 8.5.7 Using MIGRATE=YES with secondary indexes -- 8.6 Migrating databases with logical relationships -- 8.6.1 Changing DBDs with logical relationships -- 8.6.2 Changing DBDs with logical relationships -- 8.6.3 Unloading logically related databases for migration -- 8.6.4 Loading logically related databases for migration -- 8.6.5 Logical relationship pointers after the migration -- 8.7 Migrating from PDB or PDF -- 8.7.1 Partition selection -- 8.7.2 DBD changes -- 8.7.3 Using standard IMS utilities for the migration -- 8.7.4 Using application programs for the migration -- 8.7.5 Using PSU Unload and application programs for the migration -- 8.8 Migrating from user partitioning -- 8.8.1 Using application programs for the migration.8.8.2 Using HD Unload and application programs for the migration -- 8.8.3 Warning on the use of HD Reload -- 8.9 Fallback to non-HALDB -- 8.9.1 Fallback with secondary indexes -- 8.9.2 Fallback with logical relationships -- Chapter 9. Migration examples -- 9.1 Migration of HIDAM database to PHIDAM -- 9.1.1 Image copy of non-HALDB database data sets -- 9.1.2 Running the Migration Aid utility -- 9.1.3 Unloading the HIDAM database -- 9.1.4 Saving database information -- 9.1.5 Deleting the database from the RECONs -- 9.1.6 Changing the DBD and running the DBDGEN -- 9.1.7 Defining partitions with PDU -- 9.1.8 Allocate HALDB data sets -- 9.1.9 Initializing HALDB partitions -- 9.1.10 Loading HALDB database -- 9.1.11 Image copy HALDB data sets -- 9.1.12 ACBGEN -- 9.2 Migration of a database with a secondary index -- 9.3 Migrating a PDB database -- Chapter 10. Using the HALDB Conversion and Maintenance Aid -- 10.1 HALDB Conversion and Maintenance Aid product -- 10.1.1 The conversion process overview -- 10.2 Activating the tool -- 10.2.1 Modifying the startup CLIST -- 10.2.2 Allocating the environment description data set -- 10.3 Migration example with HALDB Conversion tool -- 10.3.1 Define an IMS environment -- 10.3.2 Define a project -- 10.3.3 Process a conversion project -- 10.4 Additional functions -- Part 3 Application considerations -- Chapter 11. Application considerations -- 11.1 Initial loads -- 11.1.1 PHDAM considerations -- 11.1.2 PHIDAM considerations -- 11.1.3 Loading partitions in parallel -- 11.1.4 Initial loads of databases with secondary indexes -- 11.1.5 Initial loads of databases with logical relationships -- 11.2 Processing partitions in parallel -- 11.2.1 DBRC authorization of partitions -- 11.2.2 Parallel processing within an online system -- 11.2.3 Parallel processing with block level data sharing.11.2.4 Parallel processing without block level data sharing -- 11.2.5 Program modifications for parallel processing -- 11.3 Restricting a PCB to one partition -- 11.3.1 Processing a partition sequentially -- 11.3.2 Requesting segments outside of the partition -- 11.3.3 Secondary index and logical relationship considerations -- 11.4 Handling unavailable partitions -- 11.4.1 Database PCB status code priming -- 11.5 Processing secondary indexes as databases -- 11.5.1 Secondary indexes with /SX fields -- 11.5.2 Secondary indexes with symbolic pointers -- 11.6 Handling test environments -- 11.6.1 DBRC registration -- 11.6.2 Testing with non-HALDB databases -- 11.7 Copying databases to different environments -- 11.7.1 The partition ID -- 11.7.2 Using image copies -- 11.7.3 Using unloads -- 11.7.4 Copying part of the data -- 11.7.5 Copying partition definitions -- 11.7.6 Timestamp recoveries to a copy -- 11.7.7 Planned enhancement for copying partition definitions -- Part 4 Administration -- Chapter 12. HALDB online commands -- 12.1 Online commands with HALDB -- 12.2 /DISPLAY command -- 12.2.1 Display of a HALDB master database -- 12.2.2 Display of a HALDB partition -- 12.3 /DBRECOVERY command -- 12.3.1 DBR of a HALDB master database -- 12.3.2 DBR of a HALDB partition -- 12.4 /DBDUMP command -- 12.4.1 DBD of a HALDB master database -- 12.4.2 DBD of a HALDB partition -- 12.5 /START command -- 12.5.1 Start of a HALDB master database -- 12.5.2 Start of a HALDB partition -- 12.6 /STOP command -- 12.6.1 Stop of a HALDB master database -- 12.6.2 Stop of a HALDB partition -- 12.7 /LOCK command -- 12.7.1 Lock of a HALDB master database -- 12.7.2 Lock of a HALDB partition -- 12.8 /UNLOCK command -- 12.8.1 Unlock of a HALDB master database -- 12.8.2 Unlock of a HALDB partition -- 12.9 Using the ALL keyword with commands -- 12.10 Commands while databases are in use.12.11 Command examples.This IBM Redbooks publication describes the High Availability Large Database (HALDB) capability available with IMS. IMS HALDB was introduced with IMS Version 7. It allows IMS databases to grow to almost unlimited sizes while providing increased availability. This book updates IMS Version 7 High Availability Large Database Guide, SG24-5751, as well as adding topics that were not covered in the previous book. This publication provides a broad explanation of HALDB and its uses. Specific areas covered include: -HALDB overview, definition, and structure -Migration from non-HALDB databases -Application considerations -HALDB database administration This publication documents our hands-on experience in a test environment. It includes migration and administration examples. Some IBM Data Management Tools for IMS are also discussed in this publication. Special emphasis is given to the IMS HALDB Conversion and Maintenance Aid product. Examples of the use of these tools are provided.IBM redbooks.Database managementIMS (DL/I) (Computer system)Database management.IMS (DL/I) (Computer system)Jantti Jouko0International Business Machines Corporation.International Technical Support Organization.MiAaPQMiAaPQMiAaPQBOOK9910810000703321The complete IMS HALDB guide4068756UNINA