A fix is available
APAR status
Closed as program error.
Error description
If a dropped table is recovered using log-based recovery foreign keys are not recreated
Local fix
Problem summary
If a dropped table is recovered using log-based recovery foreign keys are not recreated.
Problem conclusion
Apply the PTF.
Temporary fix
Comments
APAR Information
APAR number
PH47407
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
2022-06-21
Closed date
2022-08-02
Last modified date
2022-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
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#CHKR ARY#CLLS ARY#CMTS ARY#CNTL ARY#CPNT ARY#CPOL ARY#DSAF ARY#DSPL ARY#DYNL ARY#ENCR 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#LGAA ARY#LGAC ARY#LGAF ARY#LGAI ARY#LGAP ARY#LOGR ARY#LRD6 ARY#MAIN ARY#MDRV ARY#MLOG ARY#MMGR ARY#MREP ARY#MTIO ARY#NREC ARY#OBRP ARY#OS ARY#PRNG ARY#QSAM ARY#RANG ARY#RESM ARY#RPRP ARY#RUNT ARY#STAT ARY#SUBD ARY#SUBX ARY#SYSC ARY#TUTL ARY#UTLS ARY#VERS ARY#VSM ARY#WRIT ARY#XMLD ARY#XMLI ARY#XMLJ ARY#XMLS ARY#XMLU ARY$ACCS ARY3MEPI ARY3MEPL ARYACONN ARYALL99 ARYAPOST ARYARYST ARYASQLE ARYAVRSN ARYBBCK ARYBBGLO ARYBCRA ARYBCRAS ARYBDT@ ARYCAL9C ARYCAL9D ARYCAL9L ARYCAL9S ARYCALNC ARYCAPST ARYCAQ1C ARYCAQ1D ARYCAQ1L ARYCAQ1S ARYCAQNC ARYCAT01 ARYCATNC ARYCCT9C ARYCCT9D ARYCCT9L ARYCCT9S ARYCCTNC ARYCD001 ARYCDB9C ARYCDB9D ARYCDB9L ARYCDB9S ARYCDPNC ARYCDPND ARYCDPNL ARYCDPNS ARYCDT0C ARYCDT0D ARYCDT0L ARYCDT0S ARYCDT1C ARYCDT1D ARYCDT1L ARYCDT1S ARYCDT9C ARYCDT9D ARYCDT9L ARYCDT9S ARYCDTNC ARYCDTND ARYCDTNL ARYCDTNS ARYCFN0C ARYCFN0D ARYCFN0L ARYCFN0S ARYCFN9C ARYCFN9D ARYCFN9L ARYCFN9S ARYCFNNC ARYCFNND ARYCFNNL ARYCFNNS ARYCIX0C ARYCIX0D ARYCIX0L ARYCIX0S ARYCIX1S ARYCIX2C ARYCIX2D ARYCIX2L ARYCIX2S ARYCIX9C ARYCIX9D ARYCIX9L ARYCIX9S ARYCIXNC ARYCIXND ARYCIXNL ARYCIXNS ARYCMT0C ARYCMT0D ARYCMT0L ARYCMT0S ARYCMTNC ARYCPK0C ARYCPK0D ARYCPK0L ARYCPK0S ARYCPK1C ARYCPK1D ARYCPK1L ARYCPK1S ARYCPK9C ARYCPK9D ARYCPK9L ARYCPK9S ARYCPKNC ARYCPKND ARYCPKNL ARYCPKNS ARYCPL0C ARYCPL0D ARYCPL0L ARYCPL0S ARYCPL1C ARYCPL1D ARYCPL1L ARYCPL1S ARYCPL9C ARYCPL9D ARYCPL9L ARYCPL9S ARYCPLNC ARYCPLND ARYCPLNL ARYCPLNS ARYCRL2C ARYCRL2D ARYCRL2L ARYCRL2S ARYCRL9C ARYCRL9D ARYCRL9L ARYCRL9S ARYCRO9C ARYCRO9D ARYCRO9L ARYCRO9S ARYCRTNC ARYCRTND ARYCRTNL ARYCRTNS ARYCSG9C ARYCSG9D ARYCSG9L ARYCSG9S ARYCSN9C ARYCSN9D ARYCSN9L ARYCSN9S ARYCSNNC ARYCSP9C ARYCSP9D ARYCSP9L ARYCSP9S ARYCSPNC ARYCSPND ARYCSPNL
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI81771
UP22/08/03 P F208
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":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 September 2022