Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 Table Load Error & receiving S04E

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
chinnaraj

New User


Joined: 01 Nov 2007
Posts: 17
Location: Chennai

PostPosted: Thu Oct 01, 2009 4:15 pm    Post subject: DB2 Table Load Error & receiving S04E
Reply with quote

Hi,

I am trying to load a table with the data from a sequential file thru the program DSNUTILB and getting the below error.
what could be the issue ?
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = STEPXXX.YYYYYYY
DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU018I < DSNUGASU - JOB IS NOT RESTARTABLE DUE TO -START DATABASE ACCESS FORCE COMMAND
DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40018

Please help me to resolve this error.
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu Oct 01, 2009 4:41 pm    Post subject:
Reply with quote

search DSNU018I in DB2 Messages (or google) and do what it says there
Back to top
View user's profile Send private message
nagesh54

New User


Joined: 20 Jun 2008
Posts: 30
Location: Hyderabad

PostPosted: Mon Oct 05, 2009 10:11 am    Post subject:
Reply with quote

Hi,

The reason is that , in the middle of the utility execution the TS or DB is force started and you are trying to restart the same job. so it is throwing the error. Ask your DBA to terminate the utility using term command at at the Db2 command promt . and submit the job gain.
Back to top
View user's profile Send private message
amrita.chatterjee

New User


Joined: 27 Apr 2006
Posts: 48
Location: Bangalore, India

PostPosted: Mon Oct 05, 2009 11:08 pm    Post subject: Reply to: DB2 Table Load Error & receiving S04E
Reply with quote

hi chinnaraj,
I have faced this S04E error several times. Actually during loading the data to table through JCL - if the load doesn't happen properly then S04E error comes. Please check whether any of the table is in CHECK PENDING / COPY PENDING state or not by DB2 COMMANDS. then restart the job from the top.
Not sure whether this will help you or not.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us