A fix is available
APAR status
Closed as program error.
Error description
Dropped object recovery may receive SQLCODE = -904 if recovering a child table in a RI relationship.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM DB2 Recovery Expert z/OS. * **************************************************************** * PROBLEM DESCRIPTION: Dropped object recovery may receive * * SQLCODE = -904 if recovering * * a child table in a RI relationship. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI87293
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
2017-09-13
Closed date
2017-12-14
Last modified date
2018-01-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI52715
Modules/Macros
ARY$$PRM ARY$MREP ARY#CMET ARY#DSA ARY#HSA ARY#LSQL ARY#TRS ARY#YCTL ARY@BULD ARY@FSP ARY@MNT ARY@YDRM ARYAC ARYAFER ARYAFPS ARYAFVL ARYAFWC ARYAFWR ARYALOG ARYBDCT ARYBHDR ARYBLNKT ARYBPC ARYBSDM ARYBSDR ARYBSDS ARYBSQL ARYCAF ARYCATF ARYCATR ARYCDC ARYCDICT ARYCFG ARYCFGRP ARYCFREP ARYCFRR ARYCF1UP ARYCHKD ARYCMDR ARYCREP ARYCRRF ARYCSQL ARYCTAU ARYCUOW ARYCUOW6 ARYCURR ARYDB2S ARYDCNV ARYDCTP ARYDEBAQ ARYDEBSS ARYDEBVA ARYDECP ARYDELER ARYDEXRL ARYDEXTR ARYDE8AN ARYDE8DB ARYDE8DT ARYDE8IC ARYDE8IP ARYDE8IX ARYDE8K0 ARYDE8K1 ARYDE8P0 ARYDE8P1 ARYDE8P2 ARYDE8SG ARYDE8SR ARYDE8SS ARYDE8SY ARYDE8TB ARYDE8TP ARYDE8TS ARYDE8TV ARYDFLT ARYDSNM ARYDSPG ARYDSUM ARYDSUMR ARYDTLF ARYDTL1 ARYDTL2 ARYDTL3 ARYDTL4 ARYDTL6 ARYDTR ARYDTS ARYDYN ARYEDIT ARYERR ARYERRIN ARYETV ARYEXP ARYEXPI ARYEXTF ARYEXTFD ARYFA ARYFCP ARYFFV ARYFLD ARYFLDR ARYFRMTR ARYFR1F ARYFR1V ARYFR12 ARYFR2M ARYFR2V ARYFR6 ARYFR6A ARYFR6D ARYFR6I ARYFR6PR ARYFR6T ARYFR6TV ARYFR6X ARYFR64 ARYFTC ARYGAL ARYGCOLS ARYGEND ARYGENR ARYGEN1 ARYGFLT ARYGFL2 ARYGIC ARYGMR ARYGMT ARYGRWRT ARYGUIW ARYHLI2 ARYHSM ARYIDCM ARYIDRP ARYIF ARYIOEX ARYIR2 ARYIXP ARYLBC1 ARYLBC2 ARYLBC3 ARYLB1 ARYLB2 ARYLB3 ARYLCC ARYLFP ARYLF1 ARYLF1A ARYLF1B ARYLF2 ARYLF3 ARYLF3W ARYLF4 ARYLJECD ARYLJELA ARYLJFSE ARYLJXNX ARYLLB ARYLOGP ARYLOGR ARYLOX00 ARYLOX01 ARYLPC ARYLPD ARYLVALT ARYLXP ARYMAINT ARYMDTL ARYMGR ARYMLS ARYMLSWR ARYMMIF ARYMPRT ARYMPR2 ARYMSP ARYM64PP ARYNBLKT ARYNNUMT ARYOBD ARYPEXP ARYPGR ARYPGR2 ARYPH ARYPRI ARYPSB ARYQT ARYQTL ARYQTP ARYRDR ARYREC ARYREC2 ARYREC3 ARYREC3W ARYRE64 ARYRM ARYRMW ARYRM64 ARYRRFC ARYRTT ARYRXML ARYSA ARYSBDB ARYSBDF ARYSI ARYSKLR ARYSKL2 ARYSLOG ARYSLX ARYSPLL ARYSQL ARYSQLE ARYSQL0 ARYSQL0A ARYSQL0B ARYSQL1 ARYSQL1A ARYSQL1B ARYSQL1C ARYSQL2 ARYSQL2A ARYSQL2B ARYSQL9 ARYSQL9A ARYSQL9B ARYSQL9C ARYSQ1CA ARYSQ1CB ARYSQ9CA ARYSREP ARYSRPT ARYSTOR ARYSTYPE ARYSUBC ARYSUBG ARYTC ARYTV ARYTVF ARYTVRP ARYTV2 ARYTZC ARYUDDF ARYUES ARYUEX ARYUNCRE ARYUNI ARYUNRE ARYURC ARYURID ARYURRE ARYVRD ARYWARN ARYWITF ARYWITF2 ARYWL1 ARYXDRP ARYXREP ARYXSLX ARYZAGT ARYZDT@ ARYZOAL ARYZOAQ ARYZODB ARYZODT ARYZOIX ARYZOPK ARYZOPL ARYZORO ARYZORT ARYZOSC ARYZOSG ARYZOSN ARYZOSQ ARYZOTB ARYZOTR ARYZOTS ARYZOVR ARYZOVW ARYZQCHL ARYZSCHD ARYZSRB1 ARYZSRB2 H30R320J
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI52715
UP17/12/28 P F712
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:
03 January 2018