PM12505: SUPPORT HPSGDBRC DD STATEMENT TO ISOLATE DBRC NOTIFICATION COMMAND STREAM REPORT. FITS MR110309416.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Support optional output data set HPSGDBRC DD that prints the
  DBRC Notification Command Stream report, which is contained in
  the HPSOUT2 data set.  The HPSGDBRC data set is intended to be
  used as the SYSIN data set for the DSPURX00 utility in another
  job step. This is the request for FITS MR110309416.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IMS Database Reorganization     *
  *                 Expert for z/OS Version 4 Release 1          *
  *                 (FMID=H25N410)                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Support HPSGDBRC DD statement to        *
  *                      isolate DBRC Notification Command       *
  *                      Stream. The command stream can be used  *
  *                      as the input for the DSPURX00 utility.  *
  ****************************************************************
  * RECOMMENDATION: Apply the maintenance for this APAR.         *
  ****************************************************************
  A new DD statement HPSGDBRC can be used.
  
  If the HPSGDBRC DD is specified, Reorg Expert produces the DBRC
  Notification Command Stream report to the HPSGDBRC data set
  without report header.
  The DBRC Notification Command Stream report is produced only
  when NAMESWAP=NO is specified, and when reorganization ends
  successfully.
  
  The data set is intended to be used as the SYSIN data set for
  the DSPURX00 utility in another job step.
  
  A JCL example for the manual post processing using the HPSGDBRC
  data set will be added in the User's Guide of Reorg Expert.
  
  This enhancement is being implemented for the FITS requirement
  MR110309416.
  

Problem conclusion

Temporary fix

Comments

• ========================
  = DOCUMENTATION CHANGE =
  ========================
  The IBM IMS Database Reorganization Expert for z/OS User's Guide
  Version 4 Release 1 (SC19-1137-00)
  (Revision bar shows the part of change)
  
  
  1.1 IMS Database Reorganization Expert overview
    1.1.7 Functional changes
      1.1.7.1 Changes in IMS Database Reorganization Expert
              Version 4 Release 1
  
  *The following description should be added in the section "The
  Smart Reorg utility".
  
  The following function was added to the Smart Reorg utility in
  IMS Database Reorganization Expert Version 4 Release 1:
  
  Generation of DSPURX00 control statements for manual post
  processing
    The Smart Reorg Driver was enhanced by APAR PM12505 to support
    the generation of the DSPURX00 control statements for manual
    post processing. The HPSGDBRC data set can be used as SYSIN
    for the succeeding DSPURX00 job step. For more information,
    see the following topics:
     - The description of the HPSGDBRC DD in "DD names common to
       all processing options" in topic 3.5.1.2.1
     - "Performing manual name swapping" in topic 3.8.2.1
  
  
  1.1 IMS Database Reorganization Expert overview
    1.1.7 Functional changes
      1.1.7.2 Changes made to IMS Parallel Reorganization Version
              3 Release 2
  
  *The following description should be added in the section "The
  IPR Driver (Smart Reorg utility)".
  
  Better handling of the PIPEWAIT option
    The IPR Driver was enhanced by APAR PM02596 to support a third
    parameter (OPEN or RDWR) of the PIPEWAIT control statement. By
    this enhancement, the PIPEWAIT control statement can specify
    different time periods for the opening and reading/writing
    wait states.
  
  Enabling GLOBAL option for IMS commands that are issued by TOSI
    The IPR Driver was enhanced by APAR PM06846 to support the
    IMSCMDOPT control statement. This control statement allows you
    to change the options of the IMS commands that are issued by
    IMS Tools Online System Interface (IMS TOSI).
    By using the new control statement, IPR Driver can issue /DBD,
    /DBR, and /STA commands with the GLOBAL option through IMS
    TOSI.
  
  
  3.5 Smart Reorg JCL statements
    3.5.1 JCL requirements for Smart Reorg
      3.5.1.2 DD statements
  
  *The description of HPSGDBRC DD statement should be added in the
  table 3 as follows:
  
    --------------------------------------------------------------
    DDNAME     Use       Format               Need
    --------------------------------------------------------------
       :         :          :                   :
    HPSGSWAP   Output    LRECL=80, RECFM=FB   Optional
  | HPSGDBRC   Output    LRECL=80, RECFM=FB   Optional
    HPSSNAP    Output    LRECL=133            Optional(6)
    SYSUDUMP   Output    LRECL=133            Optional
  
  
  3.5 Smart Reorg JCL statements
    3.5.1 JCL requirements for Smart Reorg
      3.5.1.2 DD statements
        3.5.1.2.1 DD names common to all processing options
  
  *The following description of HPSGDBRC DD statement should be
  added.
  
  HPSGDBRC DD
    Defines the optional output data set that contains the DBRC
    Notification Command Stream report. The command stream is
    produced only when manual name swapping is needed. The data
    set is intended to be used as the SYSIN data set for the
    DSPURX00 utility in another job step.
  
  
  3.6 JCL examples for Smart Reorg
  
  *A new section "3.6.11 Example 11: Performing a manual post
  processing after a Smart Reorg utility job" should be added.
  
  3.6.11 Example 11: Performing a manual post processing after a
  Smart Reorg utility job
  
  In this example, the database to be reorganized is a HIDAM
  database that has two secondary indexes but has no logical
  relationship.
  
  This example shows two JCL streams.
  
  The first JCL stream reorganizes a database with NAMESWAP=NO. In
  this case, manual post processing must be done after the
  reorganization. This JCL specifies HPSGSWAP and HPSGDBRC DD
  statements, so the IDCAMS Command Stream for Name Swapping
  report and the DBRC Notification Command Stream report are
  generated in the HPSGSWAP and HPSGDBRC data sets.
  
  The second JCL stream performs the name swapping and DBRC
  notification processing by using the command streams that were
  generated in the HPSGSWAP and HPSGDBRC data sets by the first
  JCL stream.
  
  //REORG    EXEC PGM=HPSGMAIN,PARM='DBD=SAMPLEDB,DBRC=Y'
  //STEPLIB  DD DISP=SHR,DSN=IMSTOOLS.SHPSLMD0
  //         DD DISP=SHR,DSN=IMS.SDFSRESL
  //         DD DISP=SHR,DSN=USER.PGMLIB
  //DFSRESLB DD DISP=SHR,DSN=IMS.SDFSRESL
  //IMSDALIB DD DISP=SHR,DSN=IMS.MDALIB
  //IMS      DD DISP=SHR,DSN=IMS.DBDLIB
  //HPSIN    DD *
  (REORG)
    DBRCAUTHCMD=YES
    INDEXBLD=YES
    NAMESWAP=NO
    DELOLDDS=YES
    STATRL=YES
  (INDEXBLD)
    SORTID=T
  //HPSGSWAP DD  DSN=SAMPLEDB.HPSGSWAP,
  //             DISP=(NEW,CATLG),SPACE=(TRK,(1,1)),UNIT=SYSDA,
  //             DCB=(RECFM=FB,LRECL=80,BLKSIZE=4000)
  //HPSGDBRC DD  DSN=SAMPLEDB.HPSGDBRC,
  //             DISP=(NEW,CATLG),SPACE=(TRK,(1,1)),UNIT=SYSDA,
  //             DCB=(RECFM=FB,LRECL=80,BLKSIZE=4000)
  
  Figure nn. Sample JCL stream to reorganize a database without
  name swapping
  
  //IDCAMS   EXEC PGM=IDCAMS
  //SYSPRINT DD SYSOUT=*
  //SYSIN    DD DISP=SHR,DSN=SAMPLEDB.HPSGSWAP
  //DSPURX00 EXEC PGM=DSPURX00
  //STEPLIB  DD DISP=SHR,DSN=IMS.SDFSRESL
  //SYSPRINT DD SYSOUT=*
  //IMS      DD DISP=SHR,DSN=IMS.DBDLIB
  //RECON1   DD DISP=SHR,DSN=IMS.RECON1
  //RECON2   DD DISP=SHR,DSN=IMS.RECON2
  //RECON3   DD DISP=SHR,DSN=IMS.RECON3
  //SYSIN    DD DISP=SHR,DSN=SAMPLEDB.HPSGDBRC
  
  Figure nn. Sample JCL stream to perform manual post processing
  after the reorganization
  
  
  3.8 Preparing and completing reorganization
    3.8.2 Post-reorganization processing
      3.8.2.1 Performing manual name swapping
  
  *The description of HPSGDBRC DD statement should be added in the
  step 2 as follows:
  
    2. Create IDCAMS ALTER statements to swap the database data
       set names.
    Refer to the sample ALTER commands that are written in the
  | HPSOUT2 data set. If you have specified the HPSGSWAP DD
  | statement, the HPSGDBRC DD statement, or both, the same
    command stream is written in the data set that is specified on
    the DD statement. The data set that is specified on the
    HPSGSWAP DD statement is intended to be used as the SYSIN for
  | IDCAMS, and the data set that is specified on the HPSGDBRC DD
  | statement is intended to be used as the SYSIN for DSPURX00.
    You can use the command stream without change, or you can
    modify it to suit to your requirements. For a sample command
    stream, see "IDCAMS Command Stream for Name Swapping report"
  | in topic 3.9.4.8 and "DBRC Notification Command Stream report"
  | in topic 3.9.4.11.
  
    For VSAM data sets, you must rename the cluster and component
    names together.
  
  
  8.2 Messages and codes
    8.2.3 Messages
      8.2.3.3 HPSG messages
        8.2.3.3.50 HPSG0213E
  
  *The Explanation of HPSG0213E message should be changed as
  follows:
  
  HPSG0213E UNSUPPORTED PIPE-ID IS SPECIFIED
  
  Explanation: The pipe ID specified in the control statement is
  incorrect.
  
  
  8.2 Messages and codes
    8.2.3 Messages
      8.2.3.3 HPSG messages
        8.2.3.3.200 HPSG0440I
  
  *The description of HPSG0440I message should be changed as
  follows:
  
  | HPSG0440I report_name IS PRODUCED IN ddname DATA SET
  
    Explanation:
  |  For the manual processing, the Smart Reorg utility produces
  |  the command stream in the ddname data set.
  |  report_name can be one of the following texts:
  |   - IDCAMS COMMAND STREAM
  |   - DBRC COMMAND STREAM
    System Action:
     The Smart Reorg utility continues processing.
    User Response:
     Run the command stream after the Smart Reorg utility job.
  

APAR Information

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

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

  UK57055

Modules/Macros

•    HPSGCSC1 HPSGGIOB HPSGGIO0 HPSGMSGT HPSGRM00
  HPSGRS00 HPSGRS10
  

Fix information

• Fixed component name

  IMS DB REORG EX

• Fixed component ID

  5655F7400

Applicable component levels

• R410 PSY UK57055

     UP10/05/21 P F005

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.