A fix is available
APAR status
Closed as program error.
Error description
Plan generation and Redirected Recovery issues: 1) 'Use SQLID for DDL' option is not honored for EXCEPTION tables. 2) DSNUKINP - DUPLICATE TABLESPACE in CHECK DATA ...FOR EXCEPTION... 3) Redirected Recovery issues if Sort Data Pages is set to 'No'. 4) Recovery plan 'Using DDL only (Drop)' is deprecated, objects are marked unrecoverable with reason ARYJ080I instead. 5) Message "The method does not support this object type" is incorrectly generated for some objects during LBDR recoveries. 6) Error message "ARYX093S--An unexpected error occurred (./DB2CurrentLogPoint.cpp,226)" is generated for data sharing groups. 7) Minor performance improvements.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Recovery Expert for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Plan generation and Redirected Recovery * * issues: * * 1. 'Use SQLID for DDL' option is not * * honored for EXCEPTION tables. * * 2. DSNUKINP - DUPLICATE TABLESPACE in * * CHECK DATA ...FOR EXCEPTION... * * 3. Redirected Recovery issues if Sort * * Data Pages is set to 'No'. * * 4. Recovery plan 'Using DDL only * * (Drop)' is deprecated, objects are * * marked unrecoverable with reason * * ARYJ080I instead. * * 5. Message "The method does not support * * this object type" is incorrectly * * generated for some objects during LBDR * * recoveries. * * 6. Error message * * "ARYX093S--An unexpected error * * occurred * * (./DB2CurrentLogPoint.cpp,226)" is * * generated for data sharing groups. * * 7. Minor performance improvements. * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** .
Problem conclusion
Apply the PTF
Temporary fix
Comments
APAR Information
APAR number
PH24550
Reported component name
DB2 REC EXPERT
Reported component ID
5697H7400
Reported release
320
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-04-17
Closed date
2020-05-06
Last modified date
2020-06-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI69353
Modules/Macros
ARY#LBID ARY#LNDF ARY#QTCL ARYACCP0 ARYAPPL0 ARYAPPL1 ARYAPPL2 ARYAPPL3 ARYAPPL4 ARYAPPL5 ARYB ARYBAADM ARYBABAL ARYBABAQ ARYBABCK ARYBABDB ARYBABDT ARYBABHE ARYBABIP ARYBABOB ARYBABOI ARYBABOP ARYBABOS ARYBABPK ARYBABPL ARYBABRL ARYBABRO ARYBABRT ARYBABSC ARYBABSG ARYBABSN ARYBABSQ ARYBABTB ARYBABTP ARYBABTS ARYBABUR ARYBABUT ARYBABVA ARYBACDM ARYBACSA ARYBADCS ARYBADMA ARYBADTM ARYBAICG ARYBAIDM ARYBAIPM ARYBALA ARYBAMRR ARYBAOBM ARYBAODM ARYBAOEN ARYBAORD ARYBAOVD ARYBAPBB ARYBAPBP ARYBAPDM ARYBAPLM ARYBAPPL ARYBARCE ARYBARCS ARYBARDM ARYBAROM ARYBARPA ARYBARPD ARYBARPS ARYBASAM ARYBASDM ARYBASEI ARYBASGD ARYBASIM ARYBASRC ARYBASYM ARYBATAS ARYBATDM ARYBATDS ARYBATPM ARYBATRM ARYBATSM ARYBAVDM ARYBAVIM ARYBAVOM ARYBBADM ARYBBALS ARYBBASL ARYBBBOS ARYBBCAI ARYBBCDM ARYBBCK ARYBBCLS ARYBBCNS ARYBBCOM ARYBBCOS ARYBBCSL ARYBBDBS ARYBBDDM ARYBBDES ARYBBDSG ARYBBDSL ARYBBDTM ARYBBDTS ARYBBERS ARYBBGLO ARYBBGOC ARYBBGRJ ARYBBGRP ARYBBIDM ARYBBINS ARYBBIPM ARYBBIPS ARYBBISL ARYBBIST ARYBBJOB ARYBBKSG ARYBBLRJ ARYBBOBM ARYBBOBS ARYBBOCN ARYBBOCR ARYBBODM ARYBBOPS ARYBBOSC ARYBBOSV ARYBBPAC ARYBBPAS ARYBBPCJ ARYBBPCO ARYBBPCV ARYBBPDM ARYBBPI ARYBBPLM ARYBBPLN ARYBBPLS ARYBBPRS ARYBBPSL ARYBBPSO ARYBBQTA ARYBBQTJ ARYBBRA ARYBBRDM ARYBBRDS ARYBBRLS ARYBBRMA ARYBBROM ARYBBROS ARYBBRPC ARYBBRPN ARYBBRSL ARYBBRTS ARYBBSAM ARYBBSAS ARYBBSCM ARYBBSDM ARYBBSES ARYBBSGD ARYBBSGS ARYBBSQS ARYBBSRC ARYBBSSL ARYBBSST ARYBBSYM ARYBBSYS ARYBBTBS ARYBBTDM ARYBBTPM ARYBBTPS ARYBBTRG ARYBBTRM ARYBBTRS ARYBBTSJ ARYBBTSL ARYBBTSM ARYBBTSO ARYBBTSS ARYBBUCD ARYBBUCI ARYBBUCL ARYBBUCO ARYBBUCR ARYBBUDC ARYBBUES ARYBBUGC ARYBBULA ARYBBULD ARYBBUPR ARYBBUPV ARYBBUQU ARYBBURB ARYBBURC ARYBBURD ARYBBURL ARYBBURP ARYBBURV ARYBBUSR ARYBBUSS ARYBBUTH ARYBBUTM ARYBBVAS ARYBBVDM ARYBBVDS ARYBBVRP ARYBBVSL ARYBCDCS ARYBCOA ARYBCOAS ARYBCRAS ARYBDAMA ARYBDCLP ARYBDDCS ARYBDPLS ARYBDRAS ARYBDSF ARYBDSUT ARYBDT@ ARYBDTCS ARYBDTRS ARYBGRAR ARYBGRCA ARYBGRDD ARYBGRDG ARYBGRDL ARYBGRGR ARYBGRGU ARYBGRMD ARYBGRML ARYBGRMR ARYBGRMT ARYBGRPL ARYBGRRI ARYBGRRR ARYBGRSF ARYBGRSR ARYBGUS ARYBIDCS ARYBIPDS ARYBIPRS ARYBIRAS ARYBJGBC ARYBJGCS ARYBJGDA ARYBJGID ARYBJGIM ARYBJGNT ARYBJGSB ARYBJGSD ARYBJGWD
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI69353
UP20/05/08 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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021