A fix is available
APAR status
Closed as program error.
Error description
This PTF is planned to the October 2019. Miscellaneous internal improvements: 1) Ad-hoc specifications for incorrect SSID are shown at the 'Ad-hoc Specification Display' ISPF panel. 2) Miscellaneous problems occur during the Redirected Recovery if a storage group or VCAT is translated. 3) PCF print module ignores records filled by binary zeros. 4) Fields for unspecified Db2 loadlibs are not cleared by the PCF update module. 5) Miscellaneous problems may occur for profiles created by the batch utility. 6) RECOVER SCOPE ALL is generated for 'Recover unchanged objects' = Y on Db2 V12. 7) Dropped auxiliary tables may be incorrectly reported as unrecoverable. 8) Miscellaneous problems of the 'Explode' ISPF command for different object types. 9) Other minor problems in the ISPF UI. 10) Abend U0050 during the log based recovery of dropped triggers. 11) DDL generation improvements for aliases and roles. 12) Duplicate DDL statements are not generated if several databases are translated to the same target name. 13) Sort work parameters specified on the 'Log Read and Log Apply Defaults' panel were ignored in generated JCLs. 14) Performance of the recovery plan generation is improved if many SYSCOPY records with ICTYPE=L STYPE=M exist for recovered object.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Recovery Expert for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Miscellaneous internal improvements: * * 1. Ad-hoc specifications for incorrect * * SSID are shown at the 'Ad-hoc * * Specification Display' ISPF panel. * * * * 2. Miscellaneous problems occur during * * the Redirected Recovery if a storage * * group or VCAT is translated. * * * * 3. PCF print module ignores records * * filled by binary zeros. * * * * 4. Fields for unspecified Db2 loadlibs * * are not cleared by the PCF update * * module. * * * * 5. Miscellaneous problems may occur for * * profiles created by the batch * * utility. * * * * 6. RECOVER SCOPE ALL is generated for * * 'Recover unchanged objects' = Y on * * Db2 V12. * * * * 7. Dropped auxiliary tables may be * * incorrectly reported as * * unrecoverable. * * * * 8. Miscellaneous problems of the * * 'Explode' ISPF command for different * * object types. * * * * 9. Other minor problems in the ISPF UI. * * * * 10. Abend U0050 during the log based * * recovery of dropped triggers. * * * * 11. DDL generation improvements for * * aliases and roles. * * * * 12. Duplicate DDL statements are not * * generated if several databases are * * translated to the same target name. * * * * 13. Sort work parameters specified on * * the 'Log Read and Log Apply * * Defaults' panel were ignored in * * generated JCLs. * * * * 14. Performance of the recovery plan * * generation is improved if many * * SYSCOPY records with ICTYPE=L * * STYPE=M exist for recovered object. * **************************************************************** .
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH18667
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
2019-10-30
Closed date
2019-10-31
Last modified date
2020-04-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI66201
Modules/Macros
ARY#A001 ARY#ACIR ARY#ACRD ARY#ADIS ARY#AEXT ARY#AFMT ARY#AMIN ARY#AUMX ARY#CARD ARY#CLLS ARY#DCAC ARY#DYNL ARY#ICAI ARY#ICAL ARY#ICCC ARY#ICCI ARY#IDCF ARY#IDSA ARY#IKPN ARY#ILGP ARY#INIT ARY#IPIE ARY#IPPB ARY#IPPC ARY#IPPD ARY#IPPH ARY#IPPN ARY#IRPL ARY#ISPC ARY#ISPL ARY#ISPV ARY#LBID ARY#LGAF ARY#LGAI ARY#LGAP ARY#LNDF ARY#LOGR ARY#LRD6 ARY#LSQL ARY#MAIN ARY#MDRV ARY#MMGR ARY#MREP ARY#OS ARY#PCF ARY#QTCL ARY#RESM ARY#RUNT ARY#SPRM ARY#STAT ARY#SUBD ARY#SVCF ARY#SYSC ARY#SYSP ARY#UTIL ARY#UTLS ARY#WRD8 ARY#WRDC ARY#WRDS ARY#WRIT ARY#XMLI ARY#XMLJ ARY#XMLS ARY#XMLU ARY3MEPI ARY4DLL ARY4MVSF ARY4SAXB ARY4SERV ARY@IVP2 ARYACONN ARYALOG2 ARYAPOST ARYBAADM ARYBABCK ARYBABIP ARYBABOB ARYBABOI ARYBABOS ARYBABTS ARYBACSA ARYBADCS ARYBADMA ARYBAICG ARYBAMRR ARYBAODM ARYBAOVD ARYBAPBP ARYBAPLM ARYBAPPL ARYBARPD ARYBARPS ARYBASEI ARYBASGD ARYBASIM ARYBASRC ARYBATAS ARYBATDS ARYBATRM ARYBATSM ARYBAVDM ARYBAVOM ARYBBCDM ARYBBCLS ARYBBCNS ARYBBCOS ARYBBDBS ARYBBDTS ARYBBERS ARYBBGOA ARYBBINS ARYBBIPM ARYBBISL ARYBBJOB ARYBBOBS ARYBBOCN ARYBBOCR ARYBBODM ARYBBOPS ARYBBOSC ARYBBOSV ARYBBPAC ARYBBPAS ARYBBPCA ARYBBPCO ARYBBPLM ARYBBQTA ARYBBQTJ ARYBBRA ARYBBRLS ARYBBRMA ARYBBRPC ARYBBSAM ARYBBSCM ARYBBSDM ARYBBSES ARYBBSGD ARYBBSQS ARYBBSSL ARYBBSST ARYBBSYM ARYBBSYS ARYBBTBS ARYBBTPM ARYBBTPS ARYBBTRM ARYBBTRS ARYBBTSL ARYBBTSS ARYBBUCL ARYBBUGC ARYBBULA ARYBBURC ARYBBURP ARYBBURV ARYBBUSR ARYBBUTM ARYBBVAS ARYBBVDM ARYBBVSL ARYBCOAS ARYBDSF ARYBDSUT ARYBDTCS ARYBDTRS ARYBGRCA ARYBGRDD ARYBGRGR ARYBGRGU ARYBGRMD ARYBGRML ARYBGRMT ARYBGRPL ARYBGRRI ARYBGRSF ARYBGRSR ARYBIPDS ARYBIPRS ARYBJGBC ARYBJGDA ARYBJGNT ARYBJGSB ARYBJGSD ARYBJGWD ARYBLAQ ARYBLEJ ARYBOOAS ARYBOPLS ARYBORDS ARYBOROD ARYBOVAS ARYBOVBS ARYBPLDS ARYBPLOS ARYBPPCS ARYBRDCS ARYBRMOQ ARYBRMRS ARYBRODC ARYBRORC ARYBSADS ARYBSARS ARYBSCBS ARYBSDSR ARYBSERS ARYBSGDS ARYBSGRS ARYBSLJ ARYBSLRJ ARYBTRAS ARYBTRVS ARYBTSDS ARYBTSJ ARYBUSGJ ARYBVCCR ARYBVEXN ARYBVGCR ARYBVICS ARYBVIDS ARYBVLRT ARYBVODS ARYBVRSE ARYCAPST ARYCAUTH ARYCF1UP ARYCFIDC ARYCFIDF ARYCFIDT ARYCFIFT ARYCFIMX ARYCFIOR ARYCFIRB ARYCFISF ARYDB2ST ARYECD02 ARYEGNSN ARYEGNTB ARYEGNTS ARYEQUAL ARYGBBJP ARYGBCJO ARYGBCOL ARYGBSCJ ARYGCCOL ARYGCDSN
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI66201
UP19/11/05 P F911
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":"BU048","label":"IBM Software"},"Product":{"code":"SSCVQTW","label":"Db2 Recovery Expert"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
20 April 2020