Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to solve S04E error

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
sanjayis01
Warnings : 1

New User


Joined: 13 Jun 2007
Posts: 55
Location: banaglore

PostPosted: Thu Jan 10, 2008 2:22 pm    Post subject: How to solve S04E error
Reply with quote

Hi

I am trying to load data into DB2 table and got the error S04E (because SORT CAPACITY EXCEEDED). I checked the status of the utility and terminated the utility. Now since the issue is resolved I can run the utility again. Now my question is this time how can I make sure that don’t get SORT issue. Please let me know.
Back to top
View user's profile Send private message

jaspal

New User


Joined: 22 May 2007
Posts: 68
Location: mumbai

PostPosted: Fri Jan 11, 2008 6:01 pm    Post subject: Re: How to solve S04E error
Reply with quote

Hi Sanjay,
Is this a sort error i think not ,if i am not wrong this error you have got during running DSNUPROC utility for loading DB2 database,
this error i once got because my job got abended in between due to which table got locked,please check once more.......?

second time when we run we have to unlock tables..........it is not sure that every time table got locked.
Back to top
View user's profile Send private message
jaspal

New User


Joined: 22 May 2007
Posts: 68
Location: mumbai

PostPosted: Fri Jan 11, 2008 6:07 pm    Post subject: Re: How to solve S04E error
Reply with quote

Sanjay,

i think you may be sorting file before loading into table ,please try to increase the number of workfiles in sort card if records are more.

if you are not sorting before loading the table ,then please include sort card before DSNUPROC step to make it faster.


regards,
Jaspal
+919833814479
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 -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm
No new posts Error IEC161I 052(009,XXXRS00)-084 wh... amitc23 JCL & VSAM 10 Wed Oct 12, 2016 5:00 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us