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
 
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 3270 Data stream error Benchwarmer CICS 4 Tue Apr 17, 2018 12:06 am
No new posts VSAM file NOT Found error while proce... SumaReva CICS 5 Wed Apr 11, 2018 9:54 pm
No new posts IMS error U4038 while executing my PL... abdulrafi IMS DB/DC 2 Thu Feb 08, 2018 1:05 pm
No new posts -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm

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