MVSFORUMS.com

Arun · Posted: Tue Apr 01, 2003 10:58 pm Post subject: ABEND=S04E REASON=00E40018

Hi all,
I'm getting an ABEND=S04E REASON=00E40018, when i'm trying to load data to a DB2 table using DSNUTILB. I have searched in the web, it gives me a pointer about corrupted index etc.
Can you plz tell me the exact problem and recovery for this.

Thanks!

kolusu · Posted: Wed Apr 02, 2003 8:15 am Post subject:

Arun,

As per the messages it states that you have restarted the LOAD uitlity, but the disposition of the work datasets is coded wrong.

Check this link for a detailed explanation of the reason code 00E40018

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/4.17.23?SHELF=&DT=20010718150520

Hope this helps...

cheers

kolusu

Arun · Posted: Wed Apr 02, 2003 9:35 am Post subject:

Thank You Very Much Kolusu !
You are right, i was trying to restart the job with 'MOD' disp for the work files. Now i changed the disp to 'NEW' and i restarted the job with UTPROC='RESTART(PHASE)'once and with UTPROC='RESTART' next time, but Still i'm facing the same abend, with the following message.

- OUTPUT START FOR UTILITY, UTILID = SMG
- UTILITY 'LOAD' INCONSISTENT WITH LAST INVOCATION
- UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40018'

Plz help me to solve this.

Thank You!

kolusu · Posted: Wed Apr 02, 2003 10:40 am Post subject:

Arun,

The LOAD utility can be restarted with either RESTART or RESTART(PHASE). However, the utility can be re-executed From the last internal checkpoint. This is dependent on the Data sets used and whether any input data sets have been rewritten.

LOAD RESUME YES cannot be restarted in the BUILD or SORTBLD phase.If report is required and this is a load without discard processing, SYSMAP is required to complete the report phase.

So to avoid all this just TERMINATE the utility using the following JCL and resubmit the load job from the top with proper disposition of the datasets.

Arun · Posted: Wed Apr 02, 2003 12:09 pm Post subject:

Thatz wonderful Exclamation

It worked ..

Thank You Very much Kolusu Smile