IBM Support

PK66221: IPR DRIVER SHOULD RESTORE DBRC AUTH FLAGS AFTER 'CANCEL' REPLY

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • IPR Driver does not restore DBRC authorization flags just before
    aborting the job-step because of DB Authorization failure
    
       HPSG0334I UNABLE TO OBTAIN EXCLUSIVE AUTHORIZATION FOR
         DATABASE xxxx   ; USED BY xxxx
       HPSG0336A EXCLUSIVE AUTHORIZATION REQUIRED. REPLY 'RETRY' OR
         'CANCEL'
    This APAR enables IPR Driver to restore DBRC authorization flags
    in such a case.  To restore the flags in the post-processing,
    NAMESWAPFAIL=BACKOUT is needed.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of IPR Driver of IMS Parallel      *
    *                 Reorganization for z/OS, Version 3 Release 2 *
    *                 (FMID=H25N320)                               *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR fixes certain problems        *
    *                      when DBRCAUTHCMD=YES or IMSCMD=YES,TOSI *
    *                      control statement of IPR Driver is      *
    *                      specified.                              *
    ****************************************************************
    * RECOMMENDATION: Apply the maintenance for this APAR.         *
    ****************************************************************
    This APAR fixes the following problems of IPR Driver:
    
    1. IPR Driver does not restore DBRC authorization flags
    when aborting the IPR Driver job due to the DBRC DB
    Authorization failure:
    
       HPSG0334I UNABLE TO OBTAIN EXCLUSIVE AUTHORIZATION
                 FOR DATABASE xxxx   ; USED BY xxxx
    
    After applying this APAR, IPR Driver issues
    the CHANGE.DB AUTH READOFF command to restore the DBRC flag
    just before aborting the IPR Driver job.
    For the failure in the post-processing, NAMESWAPFAIL=BACKOUT
    is needed.
    
    2. When IMSCMD=YES,TOSI is specified and the database is
    in used by CICS with DBCTL environment, IPR Driver issues
    MSGHPSG2102I:
    
       HPSG2102I UNABLE TO ISSUE /DBR BECAUSE DATABASE=xxxxxxxx
                 IS IN USE:ssid
    
    After applying this APAR, IPR Driver issues the IMS command
    to the online subsystem without MSGHPSG2102I.
    
    3. When IMSCMD=YES,TOSI and AUTHFAIL=WTOR are specified and
    another batch job keeps the DBRC DB authorization,
    IPR Driver does not issue /DBR command to each IMS online
    subsystem correctly.
    
    After applying this APAR, IPR Driver issues /DBR command
    to each subsystem.
    

Problem conclusion

  • ========================
    = Documentation Change =
    ========================
    IBM IMS Parallel Reorganization for z/OS, V3R2, User's Guide
    (SC18-9228-03) should be changed as follows:
    ================================================================
     2.0 IMS Parallel Reorganization Driver
     2.1 Overview
     2.1.4 Reorganization Manager
     2.1.4.4 Automated DBRC authorization and unauthorization
             processing
    
     If you specify DBRCAUTHCMD=YES, Reorganization Manager does
     the following automatically:
     - At the beginning of the reorganization, Reorganization
       Manager issues either a CHANGE.DB READON command or
       a CHANGE.DB NOAUTH command depending on the DBSHARE option.
       The CHANGE.DB READON command changes the READ ONLY flag
       of the database in RECON and the CHANGE.DB NOAUTH command
       changes the PROHIBIT AUTHORIZATION flag of the database
       in RECON. Further authorization for the database is
       prohibited.
     - During data set name swapping, Reorganization Manager
       automatically issues a CHANGE.DB NOAUTH command.
     - After post-reorganization processing ends successfully,
       Reorganization Manager automatically issues
       the CHANGE.DB AUTH READOFF command.
    |- Before the IPR Driver job terminates abnormally due to
    |  an error, issue CHANGE.DB AUTH READOFF command.
    |  For details, see "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, the IPR Driver issues the CHANGE.DB command
     to restore the READ ONLY flag or the PROHIBIT AUTHORIZATION
     flag in RECON before ending the reorganization processing
     abnormally.
    
     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.
    D  and no failure occurs in the DBRC authorization.
     - IPR Driver detects one or more errors in the main task
    |  or a subtask before the completion of the data set name
    |  swapping. For the error in the post-processing,
    |  NAMESWAPFAIL=BACKOUT is needed.
    ----------------------------------------------------------------
     2.7 Control statements
     2.7.8 Description of control statements for Reorganization
           Manager
     2.7.8.1 AUTHFAIL control statement
    
      :
      The AUTHFAIL keyword applies when authorization is checked
      during initialization processing and before the data set name
      swapping. Authorization level that is required during
      the initialization processing depends on the DBSHARE option.
      Exclusive authorization is required during the data set name
      swapping.
    
    | When the IPR Driver job aborts because the DBRC authorization
    | fails, IPR Driver restores the DBRC flags automatically.
    | For details, see "2.1.4.7 Automated DBRC processing for
    | restoring authorization flags".
    
    ----------------------------------------------------------------
     10.0 Messages and codes
     10.3 Messages
     10.3.2 HPSG messages
    
      HPSG0413W DBRC PROCESSING FOR RESTORING AUTHORIZATION FLAGS
                IS SKIPPED
    
      Explanation: The IPR Driver skips the DBRC processing for
    | restoring authorization flags, because the post-reorganization
    | processing failed and NAMESWAPFAIL=BACKOUT is not specified.
      System Action: The IPR Driver continues processing.
      Programmer Response: Issue the CHANGE.DB command to restore
      the authorization flags.
    | If NAMESWAPFAIL=BACKOUT is specified, the flags will be
    | restored automatically.
    ================= End of Documentation Change ==================
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK66221

  • Reported component name

    IMS PARALLEL RE

  • Reported component ID

    5655F7400

  • Reported release

    320

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2008-05-16

  • Closed date

    2008-06-12

  • Last modified date

    2008-07-01

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

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

    UK37316

Modules/Macros

  •    HPSGGRGB HPSGGRG0 HPSGRE00 HPSGRP10 HPSGRP20
    HPSGRS00 HPSGRT00
    

Publications Referenced
SC18922803    

Fix information

  • Fixed component name

    IMS PARALLEL RE

  • Fixed component ID

    5655F7400

Applicable component levels

  • R320 PSY UK37316

       UP08/06/14 P F806

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

Document Information

Modified date:
06 January 2023