IBM Support

PK09796: IPR DRIVER SHOULD TURN OFF DBRC FLAGS BEFORE ABORTING REORG

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If IMSCMD=YES or DBRCAUTHCMD=YES is specified, the appropriate
    command is issued internally and then DBRC turns on the READ
    ONLY flag or the PROHIBIT AUTHORIZATION flag for the database
    and the indexes.
    
    If any error is detected in the control statements in ICEIN DD,
    IPR currently ends with RC=16 with the flag on.  IPR should
    issue the DBRC CHANGE.DB command to turn off the flag before
    aborting the reorganization.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of IPR Driver of IMS Parallel      *
    *                 Reorganization for z/OS Version 3 Release 1  *
    *                 (FMID=H25N310)                               *
    ****************************************************************
    * PROBLEM DESCRIPTION: If any error is detected in the reorg   *
    *                      processing, IPR Driver currently ends   *
    *                      with RC=16 with the READ ONLY flag or   *
    *                      the PROHIBIT AUTHORIZATION flag on.     *
    *                      IPR should issue the DBRC CHANGE.DB     *
    *                      command to turn off the flag            *
    *                      before aborting the reorganization.     *
    ****************************************************************
    * RECOMMENDATION: Apply the maintenance for this APAR.         *
    ****************************************************************
    If any error is detected in the reorg processing, IPR Driver
    currently aborts with the READ ONLY flag or
    the PROHIBIT AUTHORIZATION flag on.
    
    This APAR enables IPR Driver to restore the DBRC flag
    by issuing DBRC CHANGE.DB command before aborting
    when all of the following conditions are met:
     - IMSCMD=YES or DBRCAUTHCMD=YES is specified.
     - IPR Driver issues the IMS command or the DBRC command
       at the beginning of the reorganization and no failure
       occurs in the DBRC authorization.
     - IPR Driver detects one or more errors in the main task
       or a subtask before starting the post processing.
    
    When this processing starts, the HPSG0410I message is issued:
     HPSG0410I DBRC PROCESSING FOR RESTORING AUTHORIZATION FLAGS
               STARTS
    and the results of the CHANGE.DB commands are printed in
    the new report titled as
      "DBRC PROCESSING FOR RESTORING AUTHORIZATION FLAGS."
    This report is produced in the HPSOUT2 data set.
    

Problem conclusion

  • *======================*
    * DOCUMENTATION CHANGE *
    *======================*
    The IMS Parallel Reorganization for z/OS Version 3 Release 1
    User's Guide (Document Number: SC18-9228-00) will be modified
    as follows.
                                 * * *
    ===============================================================
     2. IMS Parallel Reorganization Driver
     2.1.4 Reorganization Manager
    
      Reorganization Manager provides the IPR Driver with full DBRC
      support. If you are using IMS Version 8 or later, see "Setup
      for DBRC" in topic 2.5.1.
    
      This section describes the major functions provided by
      Reorganization Manager.
    
      Subtopics:
    
      - 2.1.4.1 Dynamic Allocation of Database Data Sets
      - 2.1.4.2 Allowing DBD Change During Reorganization
      - 2.1.4.3 Automated IMS Command Processing
      - 2.1.4.4 Automated DBRC Authorization and Unauthorization
                Processing
      - 2.1.4.5 Automated Data Set Name Swapping
      - 2.1.4.6 Automated DBRC Notification Processing
    | - 2.1.4.7 Automated DBRC Processing for Restoring
    |           Authorization Flags
      :
      :
    ================================================================
    | 2.1.4.7 Automated DBRC Processing for Restoring Authorization
    |         Flags
    |
    | When one or more errors are detected in the main task or
    | the subtasks, IPR Driver issues the CHANGE.DB command
    | to restore the READ ONLY flag or the PROHIBIT AUTHORIZATION
    | flag in RECON before aborting the reorganization processing.
    |
    | IPR issues the CHANGE.DB command when all of the following
    | conditions are met:
    | - IMSCMD=YES or DBRCAUTHCMD=YES is specified.
    | - IPR Driver issues the IMS command or the DBRC command
    |    at the beginning of the reorganization and no failure
    |    occurs in the DBRC authorization.
    | - IPR Driver detects one or more errors in the main task
    |   or a subtask before starting the post processing.
    ================================================================
     2.5.1.1 Setup for DBRC Command Authorization
        :
        :
      +-----------------------------------------------------------+
      |Table 1. DBRC Command Authorization for the IPR Driver     |
      +-------------+---------------------------------------------+
      |DBRC command | Description                                 |
      +-------------+---------------------------------------------+
      |CHANGE.DB    | Is issued only when either NAMESWAP=YES or  |
    | |             | DBRCAUTHCMD=YES or IMSCMD=YES is specified. |
      +-------------+---------------------------------------------+
      |  :          |                                             |
      +-------------+---------------------------------------------+
    
    ================================================================
     2.7.8.3 DBRCAUTHCMD Control Statement
        :
      The CHANGE.DB READON command changes the READ ONLY flag of
      the database in RECON, and the database can be authorized
      only for read processing. The CHANGE.DB NOAUTH command
      changes the PROHIBIT AUTHORIZATION flag of the database in
      RECON. Therefore, authorization processing is prohibited for
      the database.
    
    | If one or more errors are detected during Reorg Processing,
    | IPR Driver issues CHANGE.DB command to restore
    | the READ ONLY flag or the PROHIBIT AUTHORIZATION flag
    | before aborting. For details, "2.1.4.7 Automated DBRC
    | Processing for Restoring Authorization Flags"
    
      The IPR Driver must have exclusive access to the database
      before doing data set name swapping. If you specify
      DBRCAUTHCMD=YES, Reorganization Manager automatically
      issues a CHANGE.DB NOAUTH command just before data set name
      swapping.
        :
    ================================================================
     2.7.8.14 IMSCMD Control Statement
        :
      Issuing the /DBD command against a non-HALDB or a HALDB
      partition places the database or the partition in read-only
      (INQONLY) mode for all IMS online systems. Issuing the /DBR
      command against a non-HALDB or a HALDB partition places the
      database or the partition in the STOPPED, NOT OPEN status,
      and further authorization is prohibited in all IMS online
      systems.
    
    | If one or more errors are detected during Reorg Processing,
    | IPR Driver issues CHANGE.DB command to restore
    | the READ ONLY flag or the PROHIBIT AUTHORIZATION flag
    | before aborting. For details, "2.1.4.7 Automated DBRC
    | Processing for Restoring Authrization Flags"
    
      Before the name swapping of data sets, the IPR Driver must
      have exclusive access to the database. If you specify
      IMSCMD=YES, Reorganization Manager automatically issues a
      /DBR command just before the data set name swapping.
    
    ================================================================
     2.8.2 HPSOUT2 Data Set
        :
      If you are attempting to delete old original data sets by
      DELOLDDS=YES, the Result of Deleting Old Data Sets report is
      produced.
    |
    | If one or more errors are detected in the reorganization
    | processing and IPR driver attempts to restore
    | the authorization flags in RECON, the DBRC Processing
    | for Restoring Authorization Flags report is produced.
        :
        :
    ================================================================
    (The chapter 2.8.2.12 is added.)
    |2.8.2.12 DBRC Processing for Restoring Authorization Flags.
    |
    | Figure xx shows the report that is produced when Database
    | Recovery Control Utility (DSPURX00) is called by
    | Reorganization Manager at DBRC processing for restoring
    | authorization flags in RECON. For details of the processing,
    | see "2.1.4.7 Automated DBRC Processing for Restoring
    | Authrization Flags."
    |
    | Figure XX. DBRC Processing for Restoring Authorization Flags
    
    (Here, a sample of the new report will be added.)
    
    ================================================================
     E.0 Appendix E. Messages and Codes
     E.3.4 HPSG Messages
    ----------------------------------------------------------------
      HPSG0316I CHANGE.DB DBD(dbdname) parameter
      Explanation: The CHANGE.DB command has been successfully
      completed for the database or HALDB partition dbdname.
       parameter is one of the following:
       - OLRDBDS(A)
       - READON
       - NOAUTH
       - AUTH READOFF
    |  - NOAUTH READOFF
    |  - AUTH READON
    |  - NOAUTH READON
      System Action: The IPR Driver continues processing.
      Programmer Response: None.
    ----------------------------------------------------------------
      HPSG0316E CHANGE.DB DBD(dbdname) parameter --- ERROR (CC=xx)
    
     Explanation: An error occurred when the IPR Driver issued the
      CHANGE.DB command for the database or a HALDB partition
      dbdname. The condition code returned from DSPURX00 is xx.
       parameter        Report of Reference
       OLRDBDS(A)       DBRC AUTHORIZATION PROCESSING FOR NAME
                        SWAPPING
       READON           DBRC AUTHORIZATION PROCESSING FOR
                        REORGANIZATION
       NOAUTH           DBRC AUTHORIZATION PROCESSING FOR
                        REORGANIZATION
                        or
                        DBRC AUTHORIZATION PROCESSING FOR NAME
                        SWAPPING
       AUTH READOFF     DBRC NOTIFICATION PROCESSING
    
    | If the preceding HPSG0410I message was issued, see the report
    | titled DBRC PROCESSING FOR RESTORING AUTHORIZATION FLAGS.
    |
      System Action: The IPR Driver ends with a return code of 8.
      Programmer Response: Refer to the messages issued from the
      DBRC utility, and identify the cause of the error. The
      messages are printed in the HPSOUT2 data set.
    ----------------------------------------------------------------
    | HPSG0410I DBRC PROCESSING FOR RESTORING AUTHORIZATION FLAGS
    |           STARTS
    | Explanation: This is an information message that tells you
    | that the DBRC processing for restoring authorization
    | flags has started. In this process, the READ ONLY flag or
    | the PROHIBIT AUTHORIZATION flag is restored.
    | System Action: The IPR Driver continues processing.
    | Programmer Response: None.
    ----------------------------------------------------------------
    | HPSG0411I DBRC PROCESSING FOR RESTORING AUTHORIZATION FLAGS
    |           COMPLETED
    | Explanation: The DBRC processing for restoring authorization
    | flags has been completed successfully.
    | System Action: The IPR Driver continues processing.
    | Programmer Response: None.
    ----------------------------------------------------------------
    | HPSG0412E DBRC PROCESSING FOR RESTORING AUTHORIZATION FLAGS
    |           FAILED
    | Explanation: The DBRC processing for restoring authorization
    | flags has been attempted, however, failed on one or more DBRC
    | command.
    | System Action: The IPR Driver continues processing.
    | Programmer Response: Check the condition code returned
    | from DSPURX00 in the DBRC Processing for the Restoring
    | Authorization Flags report and issue the CHANGE.DB command
    | to retore the authorization flags.
    ----------------------------------------------------------------
    | HPSG0413W DBRC PROCESSING FOR RESTORING AUTHORIZATION FLAGS
    |           IS SKIPPED
    | Explanation: IPR Driver skips the DBRC processing for
    | restoring authorization flags, because the DBRC authorization
    | failure occurred at the beginning of the reorganization.
    |
    | System Action: The IPR Driver continues processing.
    | Programmer Response: Issue the CHANGE.DB command to restore
    | the authorization flags.
    ----------------------------------------------------------------
    
    ======================= End of Doc-Change ======================
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK09796

  • Reported component name

    IMS PARALLEL RE

  • Reported component ID

    5655F7400

  • Reported release

    310

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / Serviceability / Xsystem

  • Submitted date

    2005-08-02

  • Closed date

    2005-08-29

  • Last modified date

    2005-09-02

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

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

    UK06711

Modules/Macros

  •    HPSGGDIB HPSGGIOB HPSGGIO0 HPSGGRGB HPSGGRG0
    HPSGGRMB HPSGGRM0 HPSGLINK HPSGMSGT HPSGRE00 HPSGRM00 HPSGRP10
    HPSGRP20 HPSGRS00 HPSGRS30 HPSGTM00 H25N310J
    

Publications Referenced
SC18922800    

Fix information

  • Fixed component name

    IMS PARALLEL RE

  • Fixed component ID

    5655F7400

Applicable component levels

  • R310 PSY UK06711

       UP05/09/01 P F508

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":"310"}]

Document Information

Modified date:
06 January 2023