MVSFORUMS.com

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

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.

Frank Yaeger · Posted: Fri Aug 01, 2008 2:31 pm Post subject:

Sigh. Did you look up the ICE083A error message you received in the DFSORT Messages, Codes and Diagnosis Guide, or use LookAt to look it up?

Here's link to the ICE083A information:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CM20/2.2.82?SHELF=&DT=20060721170811&CASE=

Here's what it says about the 064K case:

Explanation: Critical.

If xxxx is 064K:
The work space needed for each work data set exceeds the limit of 64K tracks for a single, physical data set. Dynamic allocation could not be attempted

Programmer Response:

If xxxx is 064K:
Use the DYNALLOC=(,n) parameter to increase the maximum number of work data sets (n) such that the work space needed for each work data set does not exceed 64K tracks.

I don't know what your site has for the default number of dynamically allocated work data sets (you can find out by running a DEFAULTS job or looking at a successful sort run), but you need to override it with a larger number. I'd suggest you start with 32 work data sets and increase from there if you need to. You can do the override like this:

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

Frank,

Thanks a lot.

The job ran with OPTION DYNALLOC=(,126).

I still didnt completely understood meaning of below mentioned statement.

If xxxx is 064K:
The work space needed for each work data set exceeds the limit of 64K tracks for a single, physical data set. Dynamic allocation could not be attempted

Thanks,

Frank Yaeger · Posted: Fri Aug 01, 2008 4:40 pm Post subject:

Prior to z/OS 1.7, the system limit for the number of tracks for a single data set was 64K, so that's the most DFSORT could use. On z/OS 1.7 and above, the system allows the use of larger data sets, so DFSORT can and does use them.

Are you on z/OS 1.7 or below?
_________________
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