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
PH16246
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-08-29
Closed date
2019-10-31
Last modified date
2019-11-30
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
PH18667 UI66200
Modules/Macros
ARY#A001 ARY#ACIR ARY#ACIW ARY#ACON ARY#ACRD ARY#ACUP ARY#ADIS ARY#ADSC ARY#AEXT ARY#AFMT ARY#AFRR ARY#ALLO ARY#AMIN ARY#ASYS ARY#AUMX ARY#CARD ARY#CCUP ARY#CHKR ARY#CLLS ARY#CMTS ARY#CNTL ARY#CPNT ARY#CPOL ARY#DCAC ARY#DCAF ARY#DHLI ARY#DSAF ARY#DSPL ARY#DYNL ARY#ENQ ARY#ENQS ARY#ENVF ARY#FCPY ARY#ICAI ARY#ICAL ARY#ICCC ARY#ICCI ARY#IDCF ARY#IDSA ARY#IERR ARY#IHSA ARY#IKPL ARY#IKPN ARY#ILGP ARY#ILRA ARY#ILRS ARY#ILSA ARY#INIT ARY#IPIE ARY#IPPB ARY#IPPC ARY#IPPD ARY#IPPH ARY#IPPL ARY#IPPN ARY#IPPS ARY#IRPL ARY#ISNA ARY#ISPC ARY#ISPL ARY#ISPS ARY#ISPV ARY#LBID ARY#LGAA ARY#LGAC ARY#LGAF ARY#LGAI ARY#LGAP ARY#LNDF ARY#LOGR ARY#LRD6 ARY#LSQL ARY#MAIN ARY#MDRV ARY#MLOG ARY#MMGR ARY#MREP ARY#MSGR ARY#MTIO ARY#OBRP ARY#OS ARY#PCF ARY#PRNG ARY#QSAM ARY#QTCL ARY#RANG ARY#RESM ARY#RPRP ARY#RPSC ARY#RUNT ARY#SPRM ARY#STAT ARY#SUBD ARY#SUBX ARY#SVCF ARY#SVCI ARY#SYSC ARY#SYSP ARY#TUTL ARY#UTIL ARY#UTLS ARY#VERS ARY#WRD8 ARY#WRDC ARY#WRDS ARY#WRIT ARY#XMLD ARY#XMLI ARY#XMLJ ARY#XMLS ARY#XMLU ARY$ACCS ARY3MEPI ARY3MEPL ARY4DLL ARY4IOHR ARY4MVSF ARY4SAXB ARY4SAXC ARY4SERV ARY4SOCK ARY@CFUP ARY@IVP2 ARY@MSGS ARY@RDCL ARYACD02 ARYACONN ARYAGNSN ARYAGNTB ARYAGNTS ARYALOG2 ARYAPOST ARYBAADM ARYBABCK ARYBABHE ARYBABIP ARYBABOB ARYBABOI ARYBABOS ARYBABSC ARYBABTB ARYBABTP ARYBABTS ARYBABUR ARYBABUT ARYBACDM ARYBACSA ARYBADCS ARYBADDM ARYBADMA ARYBADTM ARYBAICG ARYBAIDM ARYBAIPM ARYBALA ARYBAMRR ARYBAOBM ARYBAODM ARYBAOEN ARYBAORD ARYBAOVD ARYBAPBB ARYBAPBP ARYBAPDM ARYBAPLM ARYBAPPL 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 ARYBBDEA ARYBBDES ARYBBDSG ARYBBDSL ARYBBDTM ARYBBDTS ARYBBERS ARYBBGLO ARYBBGOA ARYBBGOC ARYBBGRJ ARYBBGRP ARYBBIDM ARYBBINS ARYBBIPM ARYBBIPS ARYBBISL ARYBBIST ARYBBJOB ARYBBKSG ARYBBLRJ ARYBBOBM ARYBBOBS ARYBBOCN ARYBBOCR ARYBBODM ARYBBOPS ARYBBOSC ARYBBOSV ARYBBPAC ARYBBPAS ARYBBPCA ARYBBPCJ ARYBBPCO ARYBBPCV ARYBBPDM ARYBBPLM ARYBBPLN ARYBBPLS ARYBBPRS ARYBBPSL ARYBBPSO ARYBBQTA
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI66200
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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
30 November 2019