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 IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 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
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm
No new posts Reply MQ open error Vignesh Sid COBOL Programming 6 Thu Sep 07, 2017 6:02 pm

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