A fix is available
APAR status
Closed as program error.
Error description
Currently, when TOSITEST=(max,interval) is specified, TOSI DBRTEST command is issued repeatedly until no IMS dependent region is accessing database before IMS /DBD or /DBR command. However, it doesn't avoid the DFS0565I error completely. In case a BMP region starts slightly between DBRTEST and /DBR command, /DBR command fails. DFS0565I /DBR COMMAND NOT PROCESSED DB=xxxxxx IN USE BY PSB=xxxxxxxx After DFS0556I is issued by IMS, Reorg Expert issues these messages: HPSG2104I IMS COMMAND /DBR FAILED: DATABASE=GC2ACM8 HPSG0334I UNABLE TO OBTAIN EXCLUSIVE AUTHORIZATION FOR DATABASE xxxxxx ; USED BY xxxx This APAR enables TOSITEST control statement to retry /DBD or /DBR command after DFS0565I.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: IBM IMS Database Reorganization Expert for * * z/OS V4.1 (FMID=H25N410) users. * **************************************************************** * PROBLEM DESCRIPTION: This APAR enables the Smart Reorg * * utility to retry IMS /DBD or /DBR * * command if TOSITEST=(max,interval) * * control statement is specified and * * the target database is used by a * * BMP program. * **************************************************************** * RECOMMENDATION: Apply the maintenance for this APAR. * **************************************************************** If the target database is used by BMP program, IMS issues MSGDFS0565I and /DBD or /DBR command is not processed. DFS0565I /DBR COMMAND NOT PROCESSED DB=xxxxxx IN USE BY PSB=xxxxxxxx This APAR enables Reorganization Manager to issue /DBD or /DBR command repeatedly till the commands are processed, following the TOSITEST=(max,interval) control statements.
Problem conclusion
======================== = DOCUMENTATION CHANGE = ======================== The IBM IMS Database Reorganization Expert for z/OS User's Guide Version 4 Release 1 Suffix 4 (SC19-1137-05) should be changed as follows: --------------------------------------------------------------- > Control statements for the Smart Reorg Driver > TOSITEST control statement When IMSCMD=YES,TOSI is specified, before issuing IMS commands (/DBD or /DBR), Reorganization Manager verifies | whether the database is being used by any BMPs. TOSITEST control statement specifies the maximum number of attempts and the interval time for this verification. Use this control statement if you want Reorganization Manager | to wait for a certain amount of time for BMPs to end. +-1---+ +-1--------+ >>-TOSITEST=-+-(-+-max-+-,+-interval-+-)--+------------->< +-----max--------------------+ : ================ End of Documentation Change ==================
Temporary fix
Comments
APAR Information
APAR number
PI97030
Reported component name
IMS DB REORG EX
Reported component ID
5655F7400
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-04-20
Closed date
2018-06-12
Last modified date
2018-08-07
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI56494
Modules/Macros
HPSGRP40 HPSGRT00
Fix information
Fixed component name
IMS DB REORG EX
Fixed component ID
5655F7400
Applicable component levels
R410 PSY UI56494
UP18/06/16 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.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSVL5Q","label":"IMS Database Reorganization Expert for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.1.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
06 January 2023