A fix is available
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
| 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