Sorting Data on Tape



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Sorting Data on Tape

Postby ritikasingh » Thu Jul 14, 2011 10:43 pm

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.
ritikasingh
 
Posts: 39
Joined: Wed Sep 01, 2010 9:12 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Sorting Data on Tape

 

Re: Sequential TAPE dataset

Postby Robert Sample » Thu Jul 14, 2011 11:18 pm

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).
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 222 times

Re: Sorting Data on Tape

Postby dick scherrer » Fri Jul 15, 2011 12:09 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Sorting Data on Tape

Postby Frank Yaeger » Fri Jul 15, 2011 1:01 am

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.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post