IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

WER046A SORT CAPACITY EXCEEDED


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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: 1702
Location: Australia

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

Hi,

these links may shed some light

ibmmainframes.com/viewtopic.php?t=24292

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
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: 496
Location: USA

PostPosted: Fri May 21, 2010 9:56 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
Search our Forums:

Back to Top