PH19583: RECOVERY PLAN GENERATION FOR OBJECTS WITH REFERENTIAL INTEGRITY FAILS WITH ABEND S0C4 IN MODULE ARYLJGCR

Obtain the fix for this APAR.

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 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.