| View previous topic :: View next topic |
| Author |
Message |
Sterling Price
Beginner
Joined: 30 Aug 2004
Posts: 19
Topics: 8
|
 Posted: Tue Oct 12, 2004 11:16 am Post subject: DFSort error: ICE046A 0 SORT CAPACITY EXCEEDED |
 |
|
I'm posting this on behalf of a colleague who is having problems with a splice using an extremely large dataset. She has already tried adding more sortwork files. What else might she try to overcome this problem?
Here is her question:
| Quote: | I am trying to write an ICETOOL Splice step that takes in a file with approximately 85 million records and matches it based on the first four bytes with another file.
I keep getting this message:
ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT 85208051
I have added multiple sort work datasets to the job.
Does anyone have an example of how I can get this splice operation to run?
|
|
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Tue Oct 12, 2004 11:28 am Post subject: |
|
|
Sterling price,
Try Removing all your Sortwork datasets and code this parm in control cards
| Code: |
OPTION FILSZ=E99999999,DYNALLOC=(,32)
|
Hope this helps...
Cheers
kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Frank Yaeger
Sort Forum Moderator
Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
|
| Posted: Tue Oct 12, 2004 11:44 am Post subject: |
|
|
If you use JCL SORTWKdd DD statements, then they must have enough space available for the SORT (SPLICE does a SORT). As a guideline,you need about 1.3 times the SORTIN space for the SORTWKs. You can increase the SPACE for the specified JCL SORTWKs or add more SORTWKs to get more space, but if you don't specify enough space or the space is not available, you will get the ICE046A. Note that you can specify up to 255 JCL SORTWKs.
An alternative is to remove the JCL SORTWKs and let DFSORT use dynamic allocation. Again, you can use up to 255 dynamically allocated work data sets. You can increase the number of dynamically allocated work data sets above your site default by specifying:
| Code: |
//DFSPARM DD *
OPTION DYNALLOC=(,n)
/*
|
But you still need to have enough space available to do the sort.
If the volumes you use for work space are pretty full, you may need to clean them off or use other volumes that have more available space.
FILSZ=En is NOT normally needed for SPLICE. The only time it is needed is when you're using tape input, and don't have DFSMSrmm or a tape management system that uses DFSORT's ICETPEX interface.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|
| Back to top |
|
|
Sterling Price
Beginner
Joined: 30 Aug 2004
Posts: 19
Topics: 8
|
| Posted: Tue Oct 12, 2004 12:53 pm Post subject: |
|
|
| Thanks Frank and Kolusu. I will pass these suggestions on to my colleague and report back with the results after she tries them. |
|
| Back to top |
|
|
Sreejith
Intermediate
Joined: 02 Dec 2002
Posts: 155
Topics: 25
Location: N.Ireland
|
| Posted: Wed Sep 19, 2007 2:40 am Post subject: |
|
|
Hi,
A cobol program using an internal sort is giving me the same error. Any idea how can I pass DYNALLOC in this case.
Thanks
Sreejith |
|
| Back to top |
|
|
CICS Guy
Intermediate
Joined: 30 Apr 2007
Posts: 292
Topics: 3
|
| Posted: Wed Sep 19, 2007 5:36 am Post subject: |
|
|
From the COBOL Programming Guide, maybe this will help:
| Quote: | Allocating space for sort files
If you use NOFASTSRT or an input procedure, DFSORT does not know the size of the file that you are sorting. This can lead to an out-of-space condition when you are sorting large files or to overallocation of resources when you are sorting small files. If this occurs, you can use the SORT-FILE-SIZE special register to help DFSORT determine the amount of resource (for example, workspace or hiperspace) needed for the sort. Set SORT-FILE-SIZE to a reasonable estimate of the number of input records. This value is passed to DFSORT as its FILSZ=En value. |
|
|
| Back to top |
|
|
Bill Dennis
Advanced
Joined: 03 Dec 2002
Posts: 579
Topics: 1
Location: Iowa, USA
|
| Posted: Wed Sep 19, 2007 9:24 am Post subject: |
|
|
You can also add //$ORTPARM DD * to your step and override options for an invoked sort.
_________________
Regards,
Bill Dennis
Disclaimer: My comments on this foorum are my own and do not represent the opinions or suggestions of any other person or business entity. |
|
| Back to top |
|
|
CICS Guy
Intermediate
Joined: 30 Apr 2007
Posts: 292
Topics: 3
|
| Posted: Wed Sep 19, 2007 9:28 am Post subject: |
|
|
| Bill Dennis wrote: | | You can also add //$ORTPARM DD * to your step and override options for an invoked sort. |
I kind of thought so too, but I failed to find the spot in the manual where it specified that it was possible.....Frank has made it clear that if you can't prove it, don't post it...  |
|
| Back to top |
|
|
Sreejith
Intermediate
Joined: 02 Dec 2002
Posts: 155
Topics: 25
Location: N.Ireland
|
| Posted: Wed Sep 19, 2007 10:17 am Post subject: |
|
|
| Thanks for all the replies. I will give it a try |
|
| Back to top |
|
|
Frank Yaeger
Sort Forum Moderator
Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
|
| Posted: Wed Sep 19, 2007 10:18 am Post subject: |
|
|
DFSPARM is applicable to any invocation of DFSORT including COBOL programs. So you can specify DYNALLOC in DFSPARM (as mentioned in my previous post) for a COBOL program.
| Code: |
//DFSPARM DD *
OPTION DYNALLOC=(,n)
/*
|
DFSORT supports $ORTPARM as well as DFSPARM so if you like you can use this instead:
| Code: |
//$ORTPARM DD *
OPTION DYNALLOC=(,n)
/*
|
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|
| Back to top |
|
|
Frank Yaeger
Sort Forum Moderator
Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
|
|
| Back to top |
|
|
CICS Guy
Intermediate
Joined: 30 Apr 2007
Posts: 292
Topics: 3
|
| Posted: Wed Sep 19, 2007 1:22 pm Post subject: |
|
|
Thanks Frank, I seemed to have gotten sidetracked into "Providing Program Control Statements" in the Chapter 5 topic of "Invoking DFSORT With The Extended Parameter List".....  |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
