IBM Support

PQ59835: IPR V2 SUPPORTS HALDB AND DBD DECODING.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • IPR V2 supports HALDB and DBD decoding.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of IMS Parallel Reorganization for *
    *                 z/OS Version 2 Release 1 (FMID=H25N210)      *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR provides two new functions:   *
    *                      1. Support of PHDAM and PHIDAM by IPR   *
    *                         Driver                               *
    *                      2. Support of DBD decoding by IPR       *
    *                         Driver, IPR Unload, and IPR Reload   *
    ****************************************************************
    * RECOMMENDATION: Apply the maintenance for this APAR.         *
    ****************************************************************
    This APAR provides the two new functions:
     1. Support of PHDAM and PHIDAM by IPR Driver
     2. Support of DBD decoding by IPR Driver, IPR Unload, and IPR
        Reload
    

Problem conclusion

Temporary fix

Comments

  • The documentation for the new functions are provided by
    the following series of APARs including this APAR:
       PQ59835  PQ59836  PQ60330  PQ60338  PQ60339
                               * * *
    ========================
    = DOCUMENTATION CHANGE =
    ========================
    IMS Parallel Reorganization for z/OS Version 2 Release 1 User's
    Guide (SC27-1180-00) should be changed as follows.
    Chapter 1. Introduction
    1.2 Processing Requirements
    1.2.1 Software Requirements
    |    IPR V2 requires the following products and maintenance:
    | 1. For basic functions of IPR Driver, IPR Unload, and IPR
    |  Reload, the following are required:
    |  - IMS High Performance Unload for OS/390 Release 1 (5655-E06)
    |    - The maintenance provided by APAR PQ50674 must be applied
    |  - IMS High Performance Load for OS/390 Release 1 (5655-E07)
    |    - The maintenance provided by APAR PQ50675 must be applied
    | 2. For INDEXBLD=YES function of IPR Driver, the following is
    |  required in addition to the products and the maintenance
    |  listed in item 1:
    |  - IMS Index Builder for OS/390 Version 2 Release 1 (5655-E24)
    |    - The maintenance provided by APAR PQ51252 must be applied
    | 3. If you are to reorganize HALDB by using IPR Driver or to
    |  use the DBD decoding function, following maintenance must be
    |  applied:
    |  - IMS High Performance Unload for OS/390 Release 1
    |    - APAR PQ59838
    |  - IMS High Performance Load for OS/390 Release 1
    |    - APAR PQ59841
    | 4. If you are to reorganize HALDB by using IPR Driver, the
    |  following maintenance must be applied to IMS Version 7:
    |  APARs PQ36991, PQ38822, PQ50606, and PQ59200
    | 5. If you are to use DBD decoding function of IPR Driver, IPR
    |  Unload, or IPR Reload, the following product is required in
    |  addition to the products and the maintenance listed in items
    |  1 and 3:
    |  - IMS Library Management Utilities for OS/390 Release 1
    |    (5655-E04)
    |    - The maintenance provided by APAR PQ58966 must be applied
    Chapter 2. IMS Parallel Reorganization Driver
    2.1 Overview
    |    By using IPR Driver, you can reorganize an HDAM, HIDAM,
    | PHDAM, or PHIDAM database in a single job step. For HDAM and
    | HIDAM, you can optionally reorganize their secondary indexes.
      IPR Driver starts ...
         You can keep the database online and allow read access to
      users during the reorganization, because IPR Driver
    | reorganizes the database or HALDB partition into a shadow
    | database or partition. The database and its indexes need to
      be offline ...
        ...
      IPR Driver renames the shadow data sets with the original data
      set names after a successful reorganization. This is called
      the data set name swapping or just name swapping. The name
    | swapping process can be automated for HDAM and HIDAM if the
    | database has no logical relationship. The name swapping
    | process can always be automated for HALDB even if the
    | database has a logical relationship.
         IPR Driver invokes the following sub tasks ...
    2.4 Overview of Parallel Reorganization Tasks
    ### The existing explanation in this section of User's Guide ###
    ### (SH27-1180-00) applies only to HDAM and HIDAM databases. ###
    ### The following two subsections should be added to explain ###
    ### the Parallel Reorganization tasks for HALDB.             ###
    | 2.4.1 Parallel Reorganization of a HALDB Partition <NEW>
    |    This section explains the steps required to reorganize a
    | single HALDB partition by a single IPR Driver job. This is the
    | recommended way to reorganize a HALDB by using IPR Driver.
    | Submitting several IPR Driver jobs to reorganize multiple
    | HALDB partitions concurrently can reduce the reorganization
    | time for HALDB than submitting a job to reorganize them
    | serially. The latter method is explained in the next section
    | although it is not recommended.
    |    Step 0. Setting up processing environments: This step is
    | same as Step 0 for HDAM and HIDAM.
    |    Step 1. Pre-reorganization processing: This step is
    | required if you do not specify IMSCMD=YES. If you do not
    | specify IMSCMD=YES, the HALDB partition to be reorganized must
    | be offline or in read-only mode in a separate step before the
    | IPR Driver job step starts. To do this, one of the following
    | commands must be issued for the HALDB partition to reorganize:
    | - /DBRECOVERY DATABASE part_name GLOBAL NOFEOV (for
    |   DBSHARE=NO in step 2): If you are going to specify
    |   DBSHARE=NO for the IPR Driver job in step 2, issue this
    |   command. This command prevents any authorization for the
    |   HALDB partition part_name during the reorganization.
    | - /DBDUMP DATABASE part_name GLOBAL NOFEOV (for DBSHARE=YES
    |   in step 2): If you are going to specify DBSHARE=YES for the
    |   IPR Driver job in step 2, issue this command. This command
    |   allows read access to the HALDB partition part_name during
    |   the reorganization.
    |    Step 2. Running a Parallel Reorganization job: Submit a
    | parallel reorganization JCL stream for the HALDB partition.
    | This is a required step. For details, see 2.6, "JCL
    | Requirements." The JCL stream for parallel reorganization
    | must include an IDCAMS step, before the IPR Driver job step,
    | to allocated the output (shadow) data sets. For the required
    | data sets, see 2.6.3, "Considerations for Database Data
    | Sets." The name of the partition must be specified by coding
    | the PARTITION control statement. For details, see "PARTITION
    | Control Statement." INDEXBLD=YES cannot be specified. If
    | ILDSBLD=NO is not specified, the output indirect list data
    | set (ILDS) for the partition must be allocated also in the
    | IDCAMS step. If you want any special processing for
    | Reorganization Manager, Unload, or Reload task, code the
    | control statements for each task in the HPSIN DD. For
    | details, see 2.7, "Control Statements."
    |    Step 3. Performing post-reorganization processing: The
    | post-reorganization processing includes the following:
    |  - Data set name swapping
    |  - DBRC notification processing
    | This is a required step. If you specified NAMESWAP=YES and
    | ILDSBLD=YES, Reorganization Manager of IPR Driver swaps the
    | data set names and notifies DBRC of the reorganization
    | automatically. If you did not specify NAMESWAP=YES, you must
    | swap the data set names and do DBRC notification processing
    | manually. ILDS is created by the Reload task by default.
    | But, if you specify ILDSBLD=NO, ILDS must be rebuilt in a
    | separated job step before the DBRC notification processing.
    | If ILDSBLD=NO is specified, the DBRC notification processing
    | is not done automatically even if NAMESWAP=YES is specified.
    | For details, see 2.9.1, "Post-Reorganization Processing."
    |    Step 4. Take an image copy of the partition: An image copy
    | of the reorganized HALDB partition must be taken before it is
    | used by application programs.
    |    Step 5. Start the HALDB partition: The partition must be
    | started explicitly by issuing /START DATABASE command for the
    | partition so that it can be used by online application
    | programs.
    | 2.4.2 Parallel Reorganization of Entire HALDB <NEW>
    |    You can reorganize all HALDB partitions in a single IPR
    | Driver job step by reorganizing each partition sequentially.
    | The required steps are explained below. It is recommended,
    | however, to create an IPR Driver job for each partition and to
    | submit the IPR Driver jobs concurrently.
    |    Step 0. Setting up processing environments: This step is
    | same as Step 0 for HDAM and HIDAM.
    |    Step 1. Pre-reorganization processing: This step is
    | required if you do not specify IMSCMD=YES. If you do not
    | specify IMSCMD=YES, the HALDB to be reorganized must be
    | offline or in read-only mode in a separate step before the
    | IPR Driver job step starts. To do this, one of the following
    | commands must be issued for both the HALDB master database
    | and all partitions of the HALDB:
    | - /DBRECOVERY DATABASE name GLOBAL NOFEOV (for DBSHARE=NO
    |   in step 2): If you are going to specify DBSHARE=NO for the
    |   IPR Driver job in step 2, issue this command. The command
    |   issued for the HALDB master database makes it offline. The
    |   command issued for each HALDB partition prevents any
    |   authorization for the HALDB partition during the
    |   reorganization.
    | - /DBDUMP DATABASE name GLOBAL NOFEOV (for DBSHARE=YES in
    |   step 2): If you are going to specify DBSHARE=YES for the
    |   IPR Driver job in step 2, issue this command. The command
    |   allows only read access to the HALDB during the
    |   reorganization.
    |    Step 2. Running a Parallel Reorganization job: This step
    | is same as step 2 in the preceding section except that the
    | PARTITION control statement is not specified.
    |    Step 3. Performing post-reorganization processing:
    | This step is same as step 3 in the preceding section except
    | that the processing must be done for all partitions.
    |    Step 4. Take an image copy of each partition: An image copy
    | must be taken for each partition of the HALDB before the HALDB
    | is used by application programs.
    |    Step 5. Start the HALDB: Each partition must be started
    | explicitly by issuing /START DATABASE command for each
    | partition. The HALDB master database must be started also so
    | that the HALDB can be used by online application programs.
    | Note: If you define a DBRC DB Group (database group) in which
    |       the HALDB master database and all HALDB partitions
    |       belong, starting the HALDB will be easier.
    2.5 Restrictions
      IPR Driver has the following restrictions:
    | - Parallel reorganization of multiple, but all, HALDB
    |   partitions in a single IPR Driver job is not supported.
    | - INDEXBLD=YES is not supported for PHDAM and PHIDAM
    |   databases. If you want to rebuild any partitioned secondary
    |   index (PSINDEX) of such a database, you must run an Index
    |   Builder job in a separate job step after the parallel
    |   reorganization job step.
      - Parallel reorganization of a database that has a shared
        secondary index is not supported.
    2.6 JCL Requirements
    2.6.2 DD Statements
      STEPLIB DD
       Points to the following library data sets:
       - IMS tools libraries:
         - IPR load module library (mandatory)
           ...
    |    - IMS Library Management Utilities load module library
    |      (optional)
    2.6.3 Considerations for Database Data Sets
    2.6.3.1 Database and Primary Index
      ...
         If the database contains multiple data set groups, each
      data set group requires two pairs of DD names and data set
      names, one for input and the other for output.
    |    A PHDAM database requires at least three unique DD names
    | and three unique data set names for each partition to be
    | reorganized: that is, a DD name and a data set name are
    | required for the input and output data sets of each data set
    | group of each partition and a DD name and a data set name are
    | required for the input ILDS for each partition.
    |    A PHIDAM database requires at least five DD names and five
    | data set names for each partition to be reorganized: that is,
    | a DD name and a data set name are required for the primary
    | index and each data set group of each input and output
    | partition and a DD name and a data set name are required for
    | the input ILDS for each partition.
    |    If a logical parent of a unidirectional logical
    | relationship, a bidirectional logical relationship, or a
    | partitioned secondary index (PSINDEX) is defined for HALDB,
    | and ILDSBLD=NO is not specified, a DD name and a data set name
    | are required for the output ILDS for each partition.
    |    If multiple data set groups are defined for PHDAM or
    | PHIDAM, each data set group of each partition requires two
    | pairs of DD names and data set names, one for input and the
    | other for output.
    |    By default, the original data sets and the shadow data sets
    | are allocated dynamically. For details, see 2.6.3.3, "Dynamic
    | Allocation of Input and Output Data Sets." IBM recommends
    | specifying that the input and output data sets be allocated
    | dynamically. The original data sets of a HALDB partition are
    | always allocated dynamically.
    |    On how the DD names for output shadow data sets for
    | non-HALDB are determined, see 2.7.6.3, "DDNMAP Control
    | Statement." The DD names for shadow data sets for a HALDB
    | partition is determined as indicated in the following table:
    |   +----------------------------------------------+
    |   | Table: DD name suffixes for shadow data sets |
    |   +----------------------------------------------+
    |   | Original data set    |A|B|C|D|E|F|G|H|I|J|L|X|
    |   +----------------------------------------------+
    |   | Shadow data set      |M|N|O|P|Q|R|S|T|U|V|Z|Y|
    |   +----------------------------------------------+
    2.6.3.2 Secondary Indexes
    |    Secondary Indexes can be created during the parallel
    | reorganization of a non-HALDB by specifying INDEXBLD=YES.
    | Partitioned secondary indexes for HALDB need not be rebuilt
    | in a usual reorganization that changes neither the database
    | definition nor the partition definition. The following
    | explanation applies to the parallel reorganization of a
    | non-HALDB and its secondary indexes.
         If the use of IMS Index Builder is designated by the
      INDEXBLD=YES option, ...
    2.6.3.3 Dynamic Allocation of Input and Output Data Sets
         The way in which input and output data sets for database
      and indexes are allocated is determined by the DYNALLOC
      control statement.
    |    By default, the data sets are allocated dynamically. For a
    | non-HALDB, the names for the output data sets are determined
      automatically from the data set names defined in the DFSMDA
    | members for the input database and indexes. For PHDAM and
    | PHIDAM, the names for the output data sets are determined from
    | the input data set names registered in RECON. The name of an
    | output database data set (or cluster) consists of the name of
    | the corresponding input data set (or cluster) followed by a
      suffix (the default is .Z). For example, suppose your original
    | data set (or cluster) is named IMS.TESTDB01. By default, the
    | output shadow data set (or cluster) is named IMS.TESTDB01.Z.
    | If you specify 'DYNALLOC=,A', the output data set (or cluster)
      is named IMS.TESTDB01.A. You can specify any alphabetic
      character except T as the suffix. The same rule also applies
    | to the output primary index for a HIDAM database, secondary
    | indexes, and indirect list data sets. The VSAM component names
    | for shadow cluster are need not be conforming to this rule
    | because the component names in the catalog entry are used. For
    | details, see 2.7.6.4, "DYNALLOC Control Statement."
    2.6.5 Considerations for Logical Relationships
    |    If the database to be reorganized is not HALDB and has a
      logical relationship, you must specify the following DDs:
         - DFSURCDS
         - DFSURWF1
    |    These data sets are not required for HALDB even if it has a
    | logical relationship or a partitioned secondary index.
    ### The documentation change continues on to APAR PQ59836.   ###
    

APAR Information

  • APAR number

    PQ59835

  • Reported component name

    IMS PARALLEL RE

  • Reported component ID

    5655F7400

  • Reported release

    210

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2002-04-05

  • Closed date

    2002-04-24

  • Last modified date

    2002-05-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UQ65489

Modules/Macros

  •    HPSCLAC0 HPSCLA00 HPSCLA10 HPSCMSGT HPSCOPT
    HPSCOPTS HPSGBBL6 HPSGBBL7 HPSGCM00 HPSGCM10 HPSGCM20 HPSGCSC0
    HPSGGDIB HPSGGDLB HPSGGHPE HPSGGHPT HPSGGIOB HPSGGIO0 HPSGGRGB
    HPSGGRG0 HPSGGRMB HPSGGRM0 HPSGHDT0 HPSGLINK HPSGMSGT HPSGOM00
    HPSGOM10 HPSGPCHG HPSGPMA0 HPSGPMC0 HPSGPME0 HPSGPMFT HPSGPMF0
    HPSGPMGR HPSGPMI0 HPSGPMO0 HPSGPMSG HPSGPMT0 HPSGPMX0 HPSGRA00
    HPSGRA10 HPSGRA20 HPSGRA30 HPSGRC00 HPSGRDD0 HPSGRD00 HPSGRM00
    HPSGRM10 HPSGRP00 HPSGRP10 HPSGRP20 HPSGRR00 HPSGRS00 HPSGRS10
    HPSGRS30 HPSGSTMT HPSGTM00 HPSGTR00 HPSGTU00 HPSGUBBL H25N210J
    

Publications Referenced
SC27118000    

Fix information

  • Fixed component name

    IMS PARALLEL RE

  • Fixed component ID

    5655F7400

Applicable component levels

  • R210 PSY UQ65489

       UP02/04/27 P F204

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Line of Business":{"code":"LOB35","label":"Mainframe SW"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSVL5Q","label":"IMS Database Reorganization Expert for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"210"}]

Document Information

Modified date:
06 January 2023