MVSFORUMS.com

Krishb · Beginner Joined: 19 Jul 2007 Posts: 2 Topics: 2

Hi ,
I am pulling huge production records ( around 3 million) and storing them in datasets. Since the datset is relatively small, what should be done to split the datasets or write them to multiple datasets.

Thanks
Kris

CICS Guy · Intermediate Joined: 30 Apr 2007 Posts: 292 Topics: 3

Why are the datasets relatively small?
Why split them?
Sort has several ways to "split" an input file into several outputs, but why?

Frank Yaeger · Posted: Tue Sep 18, 2007 5:49 pm Post subject:

Kris,

It depends on how you want to split them.

Take a look at the "Split a file to n output files dynamically" and "Five ways to split a data set" Smart DFSORT Tricks at:

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

If that doesn't give you the solution you want, describe what you want to do in detail.
_________________
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

vivek1983 · Intermediate Joined: 20 Apr 2006 Posts: 222 Topics: 24

Krishb,

My suggestion:

1. Use sort to copy the original file and specify UNIT=CART so that you do not need to worry about space required to accomodate the huge file since the dataset would be copied to TAPE.

2. You can use this copied file the same way as u wud use a dataset copied in DISK except that you cannot view the file in 3.4 option. You need to use sort technique to view a sample of the data.

Hope that I have not confused you.

By the way, by "datasets" did you mean PDS?

Vivek G
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay)