Sqlcode
Intermediate
Joined: 15 Dec 2006
Posts: 157
Topics: 38
|
 Posted: Fri Aug 01, 2008 12:50 pm Post subject: SORT |
 |
|
I guess I have posted this question but I am really sorry I lost it halfways so posting it again.
I have an input file containing about 172 million records.
Now,My purpose is to split them into 20 different files based on key values and then I want those spilted files in to SORTED order.
When I use
OPTION COPY
OUTFIL INCLUDE=(1,15,CH,GE,C'ABC ',AND,
1,15,CH,LE,C'200209090909090'),FNAMES=OUT1
OUTFIL INCLUDE=(1,15,CH,GE,C'200209090909090',AND,
1,15,CH,LE,C'200309090909090'),FNAMES=OUT2
..
...
...
OUTFIL INCLUDE=(1,15,CH,GE,C'200709090909090',AND,
1,15,CH,LE,C'200809090909090'),FNAMES=OUT20
Job works fine but when I try to SORT this data using below mentioned card.
SORT FIELDS=(1,15,CH,A,16,2,FI,A,18,2,FI,A)
OUTFIL INCLUDE=(1,15,CH,GE,C'ABC ',AND,
1,15,CH,LE,C'200209090909090'),FNAMES=OUT1
OUTFIL INCLUDE=(1,15,CH,GE,C'200209090909090',AND,
1,15,CH,LE,C'200309090909090'),FNAMES=OUT2
..
...
...
OUTFIL INCLUDE=(1,15,CH,GE,C'200709090909090',AND,
1,15,CH,LE,C'200809090909090'),FNAMES=OUT20
The job abends saying RESOURCES WERE UNAVAILABLE FOR DYNAMIC ALLOCATION OF WORK DATASETS(064K).
Below is the exact error message.
| Code: | ICE201I E RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE083A D RESOURCES WERE UNAVAILABLE FOR DYNAMIC ALLOCATION OF WORK DATA SETS (064K)
ICE753I 0 FWK=(0,0) SWK=(0,0) TWK=(0,0) RWK=(0,0) TOTAL=(0,0) BLK=53216
ICE751I 0 C5-K26318 C6-K90007 C7-K90000 C8-K23476 E4-K90007 C9-BASE E5-K31980 E6-K18181
ICE750I 0 DC 0 TC 112958713400 CS DSVVV KSZ 23 VSZ 23
ICE752I 0 FSZ=179584600 RC IGN=0 E AVG=636 0 WSP=148346701 C DYN=0 53216
ICE052I 3 END OF DFSORT |
FYI... We are using DFSORT V1R5.
Thanks, |
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
