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 Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am
No new posts Row not found Sql error GaganGarg DB2 7 Tue Mar 07, 2017 6:29 am
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am


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