PM68661: THIS APAR PROVIDES THE PRE-REORGANIZATION UTILITY AND THE POST-REORGANIZATION UTILITY.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR provides the Pre-reorganization utility and the
  Post-reorganization utility.  This APAR also enhances the Smart
  Reorg utility and IPR DB Scan utility to support the
  Post-reorganization utility.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IMS Database Reorganization     *
  *                 Expert for z/OS Version 4 Release 1          *
  *                 (FMID=H25N410) who are planning to use the   *
  *                 new Post-reorganization utility.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR Provides the                  *
  *                      Pre-reorganization utility, the         *
  *                      Post-reorganization utility, and the    *
  *                      Cleanup utility. These new utilities    *
  *                      can be used together with the Smart     *
  *                      Reorg utility for reorganizing          *
  *                      databases that have external logical    *
  *                      relationships.                          *
  ****************************************************************
  * RECOMMENDATION: Apply the maintenance for this APAR.         *
  ****************************************************************
  You can use the Pre-reorganization utility and the
  Post-reorganization utility to run pre-reorganization processing
  and post-reorganization processing steps that are required by
  the Smart Reorg utility to reorganize databases that have
  external logical relationships.
  
  The Pre-reorganization utility identifies the databases that
  need to be reorganized by the Smart Reorg utility and the
  databases that need to be scanned by the IPR DB Scan utility.
  To do so, the Pre-reorganization utility analyzes the DFSURCDS
  data set that is generated by the IMS Database Prereorganization
  utility (DFSURPR0).
  
  The Post-reorganization utility performs post-reorganization
  processing, which is required after running Smart Reorg utility
  and IPR DB Scan utility jobs, for all the databases that were
  reorganized or scanned. Post-reorganization processing includes
  name swapping, prefix resolution, and prefix update processes.
  You can optionally include image copy and HASH pointer check
  processes.
  
  The Pre-reorganization utility and the Post-reorganization
  utility use DBRC. Therefore, all the databases that will be
  reorganized or scanned, including secondary indexes, must be
  registered to DBRC. Both utilities issue each DBRC command and
  IMS command for all target databases at the same time.
  
  The Pre-reorganization utility and the Post-reorganization
  utility support HDAM and HIDAM databases.
  
  The work data sets that are used by the Pre-reorganization
  utility and the Post-reorganization utility are deleted
  automatically when the Post-reorganization utility ends
  successfully. However, if you want to rerun from the
  Pre-reorganization utility job without running the
  Post-reorganization utility, you can use the Cleanup utility
  to delete the work data sets.
  

Problem conclusion

Temporary fix

Comments

• APAR PM68663 for IMS High Performance Unload for z/OS Version 1
  Release 2 (FMID: H1IN120) is required to activate the
  Post-reorganization utility.
  
  APAR PM68659 for IMS High Performance Prefix Resolution for z/OS
  Version 3 Release 1 (FMID: H1IP310) is required if you want to
  store reports produced by IMS HP Prefix Resolution in the ITKB
  Output repository.
  
  Following is a JCL example of the Pre-reorganization utility.
  The HPSIN data set defines the data set that contains
  statements that specify options for the Pre-reorganization
  utility, the Smart Reorg utility, and the Post-reorganization
  utility.
  
  //RGEPRE   EXEC PGM=HPSCMAIN,PARM='FUNC=PR'
  //STEPLIB  DD DISP=SHR,DSN=IMSTOOLS.SHPSLMD0
  //         DD DISP=SHR,DSN=IMSTOOLS.SFOILOAD   /* TOSI */
  //         DD DISP=SHR,DSN=IMS.SDFSRESL
  //IMSDALIB DD DISP=SHR,DSN=IMS.MDALIB
  //IMS      DD DISP=SHR,DSN=IMS.DBDLIB
  //DFSURCDS DD DISP=SHR,DSN=IMS.DFSURCDS
  //HPSGCTL  DD DSN=USER.HPSGCTL,DISP=(NEW,CATLG),
  //            UNIT=SYSALLDA,SPACE=(TRK,(1,1))
  //HPSIN    DD *
  (REORG)
   IMSCMD=YES,TOSI
   TOSIXCFGRP=REORG
   DBSHARE=YES
   IC=YES
   STARTDB=YES
   DISPOLDDS=DELETE
  (PREFIXRES)
   ALLOWLC=NO
   ALLOWLP=YES
  /*
  
  By running this job, the Pre-reorganization utility:
   - Issues /DBD commands to all the target databases because
     IMSCMD=YES,TOSI and DBSHARE=YES were specified in
     Pre-reorganization utility JCL.
   - Creates a control data set (HPSGCTL data set) to be used by
     the Smart Reorg utility, the IPR DB Scan utility, and the
     Post-reorganization utility.
  
  Following is a JCL example of the Post-reorganization utility.
  
  //RGEPOST  EXEC PGM=HPSCMAIN,PARM='FUNC=PO'
  //STEPLIB  DD DISP=SHR,DSN=IMSTOOLS.SHPSLMD0
  //         DD DISP=SHR,DSN=IMSTOOLS.SFOILOAD   /* TOSI */
  //         DD DISP=SHR,DSN=IMS.SDFSRESL
  //IMSDALIB DD DISP=SHR,DSN=IMS.MDALIB
  //DFSRESLB DD DISP=SHR,DSN=IMS.SDFSRESL
  //IMS      DD DISP=SHR,DSN=IMS.DBDLIB
  //HPSGCTL  DD DISP=SHR,DSN=USER.HPSGCTL
  //ICEIN    DD *
    GLOBAL   HDPC=Y,
             ICHLQ=IMSICA,
             UNIT=SYSALLDA,
             SPACE=(CYL,100,100)
  /*
  
  By running this job, the Post-reorganization utility:
   - Issues /DBR commands before swapping the data set names
     because IMSCMD=YES,TOSI and DBSHARE=YES were specified in
     Pre-reorganization utility JCL.
   - Invokes the IMS HP Image Copy utility after the prefix
     resolution and update processing because IC=YES was specified
     in Pre-reorganization utility JCL.
   - The IMS HP Image Copy utility invokes the HD Pointer Checker
     utility because HDPC=Y is specified in the ICEIN data set of
     Post-reorganization utility JCL.
   - Deletes the original input database data sets after creating
     image copies because DISPOLDDS=DELETE was specified in
     Pre-reorganization utility JCL.
   - Issues /STA commands after deleting the original input
     database data sets because STARTDB=YES was specified in
     Pre-reorganization utility JCL.
  
  ========================
  = DOCUMENTATION CHANGE =
  ========================
  The IBM IMS Database Reorganization Expert for z/OS User's Guide
  Version 4 Release 1 Suffix 2 (SC19-1137-02)
  
  See http://www-304.ibm.com/support/docview.wss?uid=swg27024423
  for the documentation change by this APAR.
  

APAR Information

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

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

  UK80514

Modules/Macros

• HPSCMAIN HPSGCM00 HPSGCM10 HPSGCM20 HPSGCSC0
  HPSGCSC1 HPSGDATE HPSGDI00 HPSGGIO0 HPSGGRG0 HPSGGVT0 HPSGIDA0
  HPSGLINK HPSGMAIN HPSGMPA0 HPSGMPE0 HPSGMSGS HPSGMSGT HPSGODA0
  HPSGOM10 HPSGPRC0 HPSGRA00 HPSGRA10 HPSGRA50 HPSGRA60 HPSGRB00
  HPSGRC00 HPSGRD00 HPSGRD20 HPSGRE00 HPSGRI10 HPSGRM10 HPSGRP00
  HPSGRP10 HPSGRP20 HPSGRP30 HPSGRP40 HPSGRS00 HPSGRS10 HPSGRS20
  HPSGRS30 HPSGRS40 HPSGRTE0 HPSGRTM0 HPSGRX00 HPSGSTMT HPSGTE00
  HPSGTJ00 HPSGTM00 HPSGTM20 HPSGTU00 HPSGTU2A HPSGTU2B HPSGTU2C
  HPSGTU29 HPSGUDD0 HPSPCL00 HPSPMAIN HPSPRM00 HPSPRM10 HPSPRM20
  HPSPRM30 HPSPRP00 HPSPTM00 HPSPTM10 HPSPTM20 HPSPTM30 HPSPTU00
  HPSPTY00 H25N410J
  

Fix information

• Fixed component name

  IMS DB REORG EX

• Fixed component ID

  5655F7400

Applicable component levels

• R410 PSY UK80514

     UP12/07/27 P F207

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.