A fix is available
APAR status
Closed as program error.
Error description
Recovery plan generation for objects with referential integrity fails in some cases, especially if the option "Include RI related objects" is disabled or related table is explicitly excluded from the profile. Possible symptoms are abend S0C4 in module ARYLJGCR at offset 000003F8 and error messages: ARYW007E--Callable service invocation failed with return code = 12 and reason code = 00000011. ARYE002E--ABEND INTERCEPTED ARYW001E--A callable services abend S0C4 has occurred. ARYW005E-- PSW = 078D1400 B871B820. ARYW004E-- Active module = ARYLJGCR, load point = 3871B428, offset = 000003F8. ARYW002E-- GPRS 00-03: 00000008 000A0000 000A0000 386D6FF8. ...
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Recovery Expert for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Recovery plan generation for objects * * with referential integrity fails in * * some cases, especially if the option * * "Include RI related objects" is * * disabled or related table is explicitly * * excluded from the profile. * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** .
Problem conclusion
Apply the PTF
Temporary fix
Comments
APAR Information
APAR number
PH19583
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-11-22
Closed date
2019-11-29
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:
Modules/Macros
ARY#AAPI ARY#ALCT ARY#ALEX ARY#ALLC ARY#ALRN ARY#ALSL ARY#ALUP ARY#AUTH ARY#AUTL ARY#BIND ARY#BKUP ARY#BRS ARY#BSDS ARY#BSDU ARY#BUPD ARY#CBIN ARY#CDR ARY#CID2 ARY#CIO ARY#CSI ARY#CSI1 ARY#CSIA ARY#CSID ARY#CVAF ARY#DSUB ARY#GIO ARY#HCHK ARY#HSM ARY#IDIO ARY#MFL ARY#MGRT ARY#MIO ARY#MNT ARY#MOD ARY#OBEX ARY#OBIO ARY#OIO ARY#ONDX ARY#PDSN ARY#PEND ARY#PIO ARY#PTV7 ARY#PTVL ARY#RBA ARY#RBAC ARY#RE24 ARY#RIO ARY#RPTD ARY#SDB2 ARY#SGRP ARY#SMS ARY#STB2 ARY#STUB ARY#SUBS ARY#SUPD ARY#SVOL ARY#TBSP ARY#VOLS ARY#VPRO ARY#VTC2 ARY#VTOP ARY#YARC ARY#YCAL ARY#YCTL ARY#YDEL ARY#YMCA ARY#YMCR ARY$ADM1 ARY$ADM2 ARY$ADM3 ARY$ADM4 ARY$ADM5 ARY$ADMN ARY$ALLC ARY$APFT ARY$APMN ARY$ASTK ARY$ATGT ARY$AXIS ARY$BACD ARY$BBLD ARY$BDSN ARY$BJOB ARY$BLDI ARY$BLDJ ARY$BPAU ARY$BPND ARY$BPRC ARY$BPRD ARY$BPRS ARY$BPRT ARY$BPRU ARY$BPRV ARY$BPSU ARY$BREP ARY$BSAU ARY$BTCH ARY$BULJ ARY$BUTD ARY$CARD ARY$CG00 ARY$CGAD ARY$CGGL ARY$CGSL ARY$CGSS ARY$CGUP ARY$CGXD ARY$CMDS ARY$CORD ARY$CRMC ARY$CRMD ARY$CRMT ARY$CRMU ARY$CRPD ARY$CRPR ARY$CRQT ARY$CRST ARY$DELT ARY$DGRP ARY$DOF1 ARY$DPRU ARY$EQRY ARY$ERBA ARY$FQRY ARY$IBLD ARY$IC1 ARY$IC2 ARY$IC3 ARY$IC4 ARY$IC5 ARY$ICSB ARY$IDCM ARY$IMG2 ARY$IMG3 ARY$IMGO ARY$INEX ARY$MAIN ARY$MJOP ARY$MVOL ARY$OBJD ARY$OBJR ARY$OBLD ARY$OFF1 ARY$OFF2 ARY$OFF3 ARY$OFF4 ARY$OFF6 ARY$OPRC ARY$OPRD ARY$OPRE ARY$OPRI ARY$OPRT ARY$OPRU ARY$PARM ARY$POOL ARY$PRCL ARY$PRFD ARY$PRFN ARY$QSNP ARY$RBAD ARY$RECO ARY$RESO ARY$RIOP ARY$RPTD ARY$SBCV ARY$SCSI ARY$SQLD ARY$SSAA ARY$SSAL ARY$SSBB ARY$SSBM ARY$SSBU ARY$SSCT ARY$SSDV ARY$SSID ARY$SSRA ARY$SSUC ARY$SSVC ARY$SSVD ARY$SSVV ARY$STOG ARY$SYMN ARY$SYSL ARY$TBLD ARY$URBO ARY$VAL ARY@BACK ARY@BAKE ARY@BAKO ARY@BAKS ARY@BAKV ARY@BCHK ARY@BCKP ARY@BDB2 ARY@BHPG ARY@BLDB ARY@BULD ARY@CGBK ARY@CGOF ARY@CGOO ARY@CGOR ARY@CGOT ARY@CGPT ARY@CGRS ARY@CGRV ARY@CRCR ARY@CSIV ARY@DB2R ARY@DISC ARY@DISP ARY@DOOD ARY@DSCC ARY@DSNX ARY@HCHK ARY@IGGC ARY@IMCD ARY@IMCE ARY@IMCP ARY@IMCQ ARY@IMCR ARY@IVP ARY@IVP2 ARY@MAIN ARY@MJCR ARY@MSG ARY@MSGS ARY@NRPO ARY@OCK9 ARY@OCKO ARY@OCPE ARY@OCPR ARY@OCPY ARY@ODSD ARY@OFLD ARY@OFLE ARY@OFLP ARY@ORCT ARY@OREN ARY@ORPT ARY@ORSE ARY@ORST ARY@OSMS ARY@PARM ARY@PCRD ARY@PEND
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI66690
UP19/11/30 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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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"}]
Document Information
Modified date:
31 March 2021