Page 1 of 1

Sorting Data on Tape

PostPosted: Thu Jul 14, 2011 10:43 pm
by ritikasingh
Hi Dick,

I also need information to copy Tape dataset(9 tape ).It has ome 100 million records.
While loading the table i am getting issue. Now i wantto try presorting the tape dataset and then load.
Not sure is it possible to sort tape dataset .Please advice.

Re: Sequential TAPE dataset

PostPosted: Thu Jul 14, 2011 11:18 pm
by Robert Sample
Not sure is it possible to sort tape dataset .
Why would you NOT think it possible to sort a tape dataset? As long as the mainframe can ACCESS the data, it can SORT the data. IIRC, the SORT can even use tape for work files (although it's been a lot of years since I needed to do that, so it may have been changed in the meantime).

Re: Sorting Data on Tape

PostPosted: Fri Jul 15, 2011 12:09 am
by dick scherrer
Hello,

You posted a reply to a completely unrelated topic. Your question has been split into a new topic.

Consider Robert's reply and let us know if you still have any questions. As i don't know which sort product is in use, i put your new topic in the JCL part of the forum. Your questn is rather generic and the way to do this will be quite similar regardless of product/utility used.

Re: Sorting Data on Tape

PostPosted: Fri Jul 15, 2011 1:01 am
by Frank Yaeger
Not sure is it possible to sort tape dataset


Yes, it is. You can sort a tape data set the same you sort a disk data set.

the SORT can even use tape for work files (although it's been a lot of years since I needed to do that, so it may have been changed in the meantime).


Although tape work data sets are supported, it's highly discouraged as it significantly degrades performance.