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
 

 

WER046A SORT CAPACITY EXCEEDED

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Wed May 12, 2010 4:19 pm    Post subject: WER046A SORT CAPACITY EXCEEDED
Reply with quote

Hi,

One of our Job is abended in a sort step saying, Sort Capacity exceeded, below are the details from sysout of failed job
Code:
WER276B  SYSDIAG= 2402249, 4848345, 4848345, 3146787                         
WER164B  23,424K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,           
WER164B     128K BYTES RESERVE REQUESTED, 23,328K BYTES USED                 
WER146B  20K BYTES OF EMERGENCY SPACE ALLOCATED                               
WER108I  SORTIN   : RECFM=VB   ; LRECL= 27008; BLKSIZE= 27998                 
WER110I  SORTOUT  : RECFM=VB   ; LRECL= 27008; BLKSIZE= 27998                 
WER410B  22,396K BYTES OF VIRTUAL STORAGE AVAILABLE ABOVE THE 16MEG LINE,     
WER410B     0 BYTES RESERVE REQUESTED, 22,396K BYTES USED                     
WER036B  G=3201,B=3160,SEGLEN=5696,BIAS=98                                   
WER162B  33,330 PREALLOCATED SORTWORK TRACKS, 225,000 DYNAMICALLY ALLOCATED, 
WER162B     1,717,740 ACQUIRED IN 246 SECONDARY EXTENTS, 0 RELEASED, TOTAL OF 1,976,070 TRACKS USED
WER046A  SORT CAPACITY EXCEEDED                                               
WER055I  INSERT          0, DELETE          0                                 
WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000                                 
WER449I  SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE                                 
WER066A  APROX RCD CNT        29892008                                       
I looked at what WER046A has to say in manuals, it says,
Quote:
SORT CAPACITY EXCEEDED EXPLANATION: All available intermediate storage is exhausted, including any secondary allocation allowed in this job set. Sort processing cannot continue.

ACTION: Supply more intermediate storage (see the SORTWK calculation formula) or use the MAXSORT technique.
ok, I'm working to convert to MAXSort application but the question which aries in mind is/are:

When I see the expanded JCL in JES JCL DD it tells me there were 12-sortwork files were used. In the JCL they have "hard-coded" 2 sort-work files but, probably , because of DYNALLOC was allowed 12 sort-work files were used. But when I look at default installation parmeters, it says,
Code:
  DYNALOC = SYSDA       
*           4           
            ON         
            ON         
            6000000     
            3000000     
            3390       
            SC      =   
*           RETRY   = 0
*                     0
            MAXNUM  = 32
that means, our sort jobs can be allowed to maximum of 32 sort-work files and four at a time. If so, why job could use only 12 sort-work files, it should have used 32!?

Any pointer will be highly appreciated, though i'm working with local-syncsort-representative, but due to time-zone difference i'm not able to follow them up with well... icon_sad.gif
Back to top
View user's profile Send private message

gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Wed May 12, 2010 4:38 pm    Post subject:
Reply with quote

Hi,

these links may shed some light

http://ibmmainframes.com/viewtopic.php?t=24292

http://ibmmainframes.com/viewtopic.php?t=39616


Gerry
Back to top
View user's profile Send private message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Thu May 20, 2010 9:50 pm    Post subject:
Reply with quote

Thanks for the pointers Gerry.

Though i'm still working to have a permanent solution for the problem, however, have you some idea about this too. I'm trying to reach the SyncSort representative at my shop, however it's a long channel icon_sad.gif:

When I see the expanded JCL in JES JCL DD it tells me there were 12-sortwork files were used. In the JCL they have "hard-coded" 2 sort-work files but, probably , because of DYNALLOC was allowed 12 sort-work files were used. But when I look at default installation parmeters, it says,
Code:
  DYNALOC = SYSDA       
*           4           
            ON         
            ON         
            6000000     
            3000000     
            3390       
            SC      =   
*           RETRY   = 0
*                     0
            MAXNUM  = 32
that means, our sort jobs can be allowed to maximum of 32 sort-work files and four at a time. If so, why job could use only 12 sort-work files, it should have used 32!?
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Fri May 21, 2010 9:56 pm    Post subject:
Reply with quote

DB2 Guy,

Please forward me your complete job listing, including the JES Log and messages, JCL, and SYSOUT. Feel free to send that to me at alissa.margulies@syncsort.com as a text attachment and I would be happy to further assist you.

In the meantime, you can try adding the following to the sort step in question:
Code:

//$ORTPARM DD *
 DYNALLOC=(SYSDA,100,RETRY=(5,3))

Please let us know whether or not that addresses the issue.

Regards,
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm


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