A fix is available
APAR status
Closed as program error.
Error description
Error message:ARYJ101E SPACE NOT ACCESSIBLE in step CRST#### can occur when recovering an RI object to last IC using LOAD option. . This fix will also resolve the following errors: . TRUNCATE TABLE SQL statement is generated as part of LOAD plans. It is invalid for parent tables, and recovery plan execution fails with: TRUNCATE TABLE "Creator"."Table"; DSNT408I SQLCODE = -20356, ERROR: THE TABLE WITH DBID=### AND OBID=# CANNOT BE TRUNCATED BECAUSE DELETE TRIGGERS EXIST FOR THE TABLE, OR THE TABLE IS THE PARENT TABLE IN A REFERENTIAL CONSTRAINT . "DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C900A3, TYPE OF RESOURCE 00000200, AND RESOURCE NAME db.ts" when recovering parent or child table of an RI set.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM DB2 Recovery Expert z/OS. * **************************************************************** * PROBLEM DESCRIPTION: ARYJ101E SPACE NOT ACCESSIBLE IN * * STEP CRST#### * **************************************************************** * RECOMMENDATION: * **************************************************************** Error message: MSYSPLEX/N can occur when recovering an RI object to last IC using LOAD option. This fix will also resolve the following errors: TRUNCATE TABLE SQL statement is generated as part of LOAD plans It is invalid for parent tables, and recovery plan execution fails with: TRUNCATE TABLE "Creator"."Table"; DSNT408I SQLCODE = -20356, ERROR: THE TABLE WITH DBID=### AND OBID=# CANNOT BE TRUNCATED BECAUSE DELETE TRIGGERS EXIST FOR THE TABLE, OR THE TABLE IS THE PARENT TABLE IN A REFERENTIAL CONSTRAINT . "DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C900A3, TYPE OF RESOURCE 00000200, AND RESOURCE NAME db.ts" when recovering parent or child table of an RI set.
Problem conclusion
Code has been added to correct the above issues.
Temporary fix
Comments
APAR Information
APAR number
PI50227
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
2015-10-08
Closed date
2016-07-13
Last modified date
2016-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
002PC07 UI39358
Modules/Macros
ARY$$SEQ ARY$ACCS ARY$ADMS ARY$APMN ARY$BCPY ARY$BGDG ARY$BJBC ARY$BJBN ARY$BMSD ARY$BMSG ARY$BULD ARY$BUTA ARY$BUTB ARY$BUTC ARY$BUTE ARY$BUTG ARY$BUTH ARY$BUTI ARY$BUTJ ARY$BUTK ARY$BUTM ARY$BUTP ARY$BUTQ ARY$BUTR ARY$BUTS ARY$BUTT ARY$BUTU ARY$BUTV ARY$BUTX ARY$BUTZ ARY$BUT2 ARY$CALL ARY$CHAR ARY$CRID ARY$CTCM ARY$DCVT ARY$DLOG ARY$DSET ARY$EDIT ARY$EDTI ARY$EDTT ARY$EDT2 ARY$EPUX ARY$ERRS ARY$ETRG ARY$EXCP ARY$EXPB ARY$EXPD ARY$EXPF ARY$EXUX ARY$FCOL ARY$IMPD ARY$IMPE ARY$IMPF ARY$JBRK ARY$JOBD ARY$JOBR ARY$JOPT ARY$JOTM ARY$JOVR ARY$JPRC ARY$JPRD ARY$JPRJ ARY$JPRU ARY$LJBO ARY$LOBJ ARY$LPRD ARY$LSTP ARY$OPVA ARY$OPVR ARY$OPVS ARY$OPVV ARY$PITS ARY$PRFR ARY$QBLD ARY$RCFS ARY$RCTL ARY$REPT ARY$RICB ARY$RICC ARY$RIFN ARY$RIFO ARY$SCOP ARY$SINF ARY$SV26 ARY$TASK ARY$TSKO ARY$TSKS ARY$TVOL ARY$UDOP ARY$URBD ARY$URCB ARY$URCC ARY$URCE ARY$URCF ARY$URCL ARY$URCV ARY$URPR ARY$VIEW ARY$VIE2 ARY#AMIN ARY#ASYS ARY#BCLR ARY#BCTC ARY#BPRI ARY#BRS ARY#BSTS ARY#BST7 ARY#BST8 ARY#BTMP ARY#BULD ARY#CARD ARY#CHKR ARY#CL ARY#CL64 ARY#CL7 ARY#CL8 ARY#CMTS ARY#CNTL ARY#CPM ARY#CPNT ARY#CPOL ARY#DB2V ARY#DCMD ARY#DISP ARY#DSAF ARY#DSPL ARY#ECDS ARY#ECIC ARY#EDAY ARY#EDSP ARY#EMCS ARY#EMIC ARY#EMID ARY#ENQS ARY#ENVF ARY#EPRI ARY#ERSH ARY#ERSI ARY#ERSU ARY#ERTA ARY#ERTI ARY#ERT8 ARY#ERT9 ARY#ESCP ARY#ETGI ARY#EXCS ARY#EXUX 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#ILOB ARY#ILRA ARY#ILRS ARY#ILSA ARY#IOPF ARY#IPIE ARY#IPPB ARY#IPPC ARY#IPPD ARY#IPPH ARY#IPPL ARY#IPPN ARY#IPPS ARY#IRPL ARY#ISNA ARY#IX ARY#IXN8 ARY#IXPT ARY#IXP7 ARY#IXP8 ARY#IXP9 ARY#IX10 ARY#IX7 ARY#IX8 ARY#IX9 ARY#JPRI ARY#LDEP ARY#LGAA ARY#LGAC ARY#LGAF ARY#LGAI ARY#LGAP ARY#LOBC ARY#LOB7 ARY#LOB8 ARY#LOGR ARY#LPIO ARY#LRDR ARY#LRD6 ARY#LRPT ARY#MAIN ARY#MLOG ARY#MPRI ARY#MREP ARY#OBRP ARY#OPCL ARY#OPRI ARY#PDEP ARY#PITS ARY#PLOG ARY#POST ARY#PRE ARY#PRNG ARY#PRSE ARY#RANG ARY#RCFS ARY#RESM ARY#RI ARY#RIV7 ARY#RIV8 ARY#RIX ARY#RM24 ARY#RPRP ARY#RUNT ARY#SCHD ARY#SCPY ARY#SETP ARY#SETR ARY#SQLE ARY#STAT ARY#SUBD ARY#SUBX ARY#SYSC ARY#TABL ARY#TB ARY#TBPT ARY#TB7 ARY#TB8 ARY#TS ARY#TSS ARY#TSSA ARY#TS10 ARY#TS7 ARY#TS8 ARY#TS9 ARY#UPRI ARY#UTED ARY#UTLL ARY#UTOB ARY#UTOP ARY#VERT ARY#VSAM ARY#WRIT ARY#XMLC ARY#XMLD ARY#XMLS ARY@CARD ARY@CCUP ARY@DATA ARY@EBCV ARY@EFDR ARY@EMCQ ARY@EMCS ARY@ENDQ ARY@EOPJ ARY@EQRY ARY@ERST ARY@ESPT ARY@ETFU ARY@FHDR ARY@MVCR ARY@PASS ARY@PEXC ARY@PMRG ARY@POBJ ARY@PROF ARY@PRSS ARY@PTBL ARY@PTRG ARY@SBCV ARY@SDSC ARY@SMAP ARY@UREP ARY@VDPG ARY@VHDR ARYACTRT ARYAPOST ARYBLNKT ARYCAPST ARYCD001 ARYCD002 ARYCHART ARYCOMAT ARYCOMM ARYDALT3 ARYDASHT ARYDDL1 ARYDEREG ARYFTRT ARYGCOLS ARYGGDDL ARYGGRPS ARYGRPJS ARYGRPSL ARYGSSID ARYGWARN ARYHEXT ARYIALI ARYIDB2C ARYIDCAM ARYIENQS ARYIEXCP ARYIGIDX ARYIGRS ARYIHFP ARYIHLI2 ARYIICW2 ARYIIDPH ARYIIKS ARYIIKSA ARYILOCK ARYIMAIN ARYIMSGS ARYIMUTX ARYINCRD ARYIPAGE ARYIPROT ARYIPSRW ARYIRBLT ARYIROWK ARYISMPR ARYISORT ARYISOR1 ARYISOR2 ARYISOR3 ARYISOR5 ARYISTDB ARYISYSP ARYITHRD ARYIUCB ARYIUTLB ARYIVSAD ARYIVSAM ARYIVSAS ARYIXCON ARYIXDEC ARYIXIND ARYIXMAT ARYIXMLR ARYIXNOD ARYIXREC ARYJCCRQ ARYJCLER ARYJCLGR ARYJCLRQ ARYJCMN ARYJDDDG ARYJDDT@ ARYJDMN ARYJDT@ ARYJECPV ARYJFLPC ARYJGDT@ ARYJGRST ARYJGRSU ARYJICMU ARYJICSP ARYJIMGM ARYJIMGX ARYJMDT@ ARYJMIGC ARYJMIGU ARYJMO@ ARYJMSGS ARYJODT@ ARYJOGEN ARYJOMN ARYJOPU ARYJRDT@ ARYJRGEN ARYJRGJU ARYJRMN ARYJSM@ ARYJSTAT ARYJXDT@ ARYLGRD ARYLJECP ARYLJEGC ARYLJELA ARYLJEPV ARYLJEXI ARYLJFIM ARYLJGOB ARYLJGPL ARYLJGTP ARYLJGTS ARYLJGUT ARYLJ9TB ARYLPART ARYLVALT ARYMAIN ARYMMGR ARYNBLKT ARYNNUMT ARYNXZRT ARYOPGEN ARYPABPR ARYPARET ARYPARSE ARYPDSEL ARYPDT@ ARYPERIT ARYPHCON ARYPHTPS ARYPHTTP ARYPLHDL ARYPMAIN ARYPOPTS ARYPRNTT ARYPSRSP ARYPWSPR ARYPXSHN ARYPXSPR ARYQMGR ARYRECOV ARYREGST ARYRESM ARYROPT ARYRPARS ARYRPCR1 ARYRPGEN ARYR79 ARYR793E ARYSJOBD ARYS99 ARYTAGNT ARYTAGT ARYTCFG ARYTDD ARYTDT@ ARYTLOC ARYTOPTS ARYTQ ARYTQADS ARYTQJOB ARYTQSHU ARYTQWF ARYTRCRD ARYTRESP ARYTRPT ARYTRQRF ARYTTCMD ARYTTHRD ARYTTREQ ARYTTSEL ARYUTERM ARYUTIM ARYUTIMO ARYUTIM9 ARYVCMDT ARYVDT@ ARYVEVTS ARYVSED ARYVSI ARYVSM ARYVSRV ARYVSRVR ARYXAAPP ARYXADT@ ARYXAOPT ARYXCCMN ARYXDCON ARYXDDB2 ARYXDDT@ ARYXNDT@ ARYXNNET ARYXNSCF ARYXNSLC ARYXNSOC ARYXNSSC ARYXNTCL ARYXNTII ARYXYDD ARYXYDT@ ARYXYJOB ARYXYMVU ARYXYSAP ARYYAASI ARYYACSI ARYYAGRP ARYYAHTS ARYYAJMM ARYYAMSG ARYYAOST ARYYAPTL ARYYAPTT ARYYAPVT ARYYARHF ARYYASDT ARYYASJT ARYYASMR ARYYASMT ARYYASOP ARYYASPS ARYYASRO ARYYASRV ARYYASST ARYYASTT ARYYATFY ARYYATSK ARYYCADS ARYYCALT ARYYCCTT ARYYCDMT ARYYCDRP ARYYCDRT ARYYCDSR ARYYCDST ARYYCGCJ ARYYCGCT ARYYCGIJ ARYYCGJR ARYYCGJT ARYYCGLJ ARYYCGLS ARYYCGLT ARYYCGL1 ARYYCGL2 ARYYCGOP ARYYCGPT ARYYCGQT ARYYCGRB ARYYCGRD ARYYCGRH ARYYCGRP ARYYCGRR ARYYCGSJ ARYYCGSL ARYYCGSR ARYYCGST ARYYCGTT ARYYCLRP ARYYCLST ARYYCOST ARYYCPTT ARYYCPVT ARYYCQTT ARYYCRBS ARYYCRBT ARYYCRCU ARYYCRDN ARYYCRET ARYYCRFT ARYYCRST ARYYCRWT ARYYCSGR ARYYCSJT ARYYCSMT ARYYCSRJ ARYYCSRV ARYYCSST ARYYCSTK ARYYCSTT ARYYCST1 ARYYCST2 ARYYCTSK ARYYCTST ARYYCVQT ARYYCVRP ARYYCWFT ARYYDB2C ARYYDOLT ARYYDT@ ARYYGOLT ARYYGPOT ARYYGUSJ ARYYGUSQ ARYYLOC ARYYLOCT ARYYLRM ARYYMAIN ARYYMO@ ARYYMSGS ARYYMTHD ARYYSCFG ARYYSILM ARYYSM@ ARYYSPID ARYYSRV ARYYTOLT ARYYTONT ARYYTPGY ARYYTSK ARYYTSKF ARYYTSKS ARYZAGNT ARYZAGT ARYZARRM ARYZASAG ARYZBBKP ARYZCIO ARYZCSI ARYZDT@ ARYZJBC ARYZJOB ARYZLGP ARYZMHQT ARYZOBJ ARYZOSB ARYZOSC ARYZPGOJ ARYZPGQT ARYZPGRJ ARYZPGRP ARYZPIT ARYZPJBE ARYZPJBS ARYZPJCL ARYZPLN ARYZPLRP ARYZPPLN ARYZPQTJ ARYZPSLJ ARYZPSUB ARYZPVQT ARYZPWG ARYZPWR ARYZQCTL ARYZQDRP ARYZQDSR ARYZQGCJ ARYZQGOJ ARYZQGQT ARYZQGRH ARYZQGRJ ARYZQGRP ARYZQGRU ARYZQGSJ ARYZQJCL ARYZQLRP ARYZQORJ ARYZQPLN ARYZQQTJ ARYZQSAV ARYZQSJR ARYZQSLJ ARYZQSUB ARYZQT ARYZQTS ARYZQVAL ARYZQVQT ARYZRBCU ARYZRBRJ ARYZRECI ARYZRES ARYZRESI ARYZRGOL ARYZRGPO ARYZRPL ARYZRPLC ARYZRPLS ARYZRQUQ ARYZRQUS ARYZRSUQ ARYZRSUS ARYZRTON ARYZSS ARYZTRNS ARYZTTOP ARYZUOPT ARY6312 H30R320J
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI39358
UP16/07/27 P F607
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:
02 August 2016