Phantom
Data Mgmt Moderator
Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet
|
 Posted: Fri Dec 09, 2005 2:09 am Post subject: |
 |
|
SR22,
You do have few options with Syncsort but that depends on the version of sort you are using. Check out which one suits your needs. If your input file is a multi-volume dataset then you can go for PARASORT (in case you don't have Syncsort v 1.2).
To see the version of sort you are using, just create a dummy sort job and check the first line of sysout.
1. PARASORT - Available in Syncsort v 1.1 & earlier (Not sure which is the first version that supports this feature)
| Code: |
It uses specially designed parallel techniques to reduce the elapsed time of sorts with large multi-volume and/or concatenated tape input datasets. This breakthrough technology allows Syncsort to read data from two, three or four tape drives simultaneously. PARASORT can improve elapsed time up to 20% when two volumes are processed in parallel and up to 33% when four volumes are processed.
|
2. PIPESORT - Available only in the latest version v 1.2
| Code: |
While PARASORT processes multiple volumes in parallel, PIPESORT divides a huge input file into a maximum of 8 chunks and executes multiple sorts simultaneously. PipeSort reads the input data only once to produce differently sorted output datasets. PipeSort is expected to cut total elapsed time by more than 50% compared to running consecutive sorts.
PipeSort performs up to eight simultaneous sorts and outputs a file for each set of sort keys (SORT Control statements). The complete range of SyncSort Control statements and PARMs is available for the individual sort operations. Thus, in addition to difference sequencing, the records in each output file can be uniquely selected and reformatted (with Include/Omit and Inrec/Outrec control statements).
|
Hope this helps,
Cheers,
Phantom |
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
