mishra
New User
Joined: 21 Feb 2007 Posts: 3 Location: india
|
|
|
|
Require to sort 6 variable length input files (of LRECL=10004) and split it into 24 output files of (LRECL=10004). Also note that the input file is having a huge volume of data.
The sort card we use is as follows:
SYSIN :
Code: |
SORT FIELDS=COPY
OUTFIL FILES=01,
INCLUDE=(14,9,ZD,GE,000000000,AND,14,9,ZD,LE,012050607)
OUTFIL FILES=02,
INCLUDE=(14,9,ZD,GE,012050608,AND,14,9,ZD,LE,014166563)
OUTFIL FILES=03,
INCLUDE=(14,9,ZD,GE,014166564,AND,14,9,ZD,LE,016091718)
OUTFIL FILES=04,
INCLUDE=(14,9,ZD,GE,016091719,AND,14,9,ZD,LE,022050993)
OUTFIL FILES=05,
INCLUDE=(14,9,ZD,GE,022050994,AND,14,9,ZD,LE,026011858)
OUTFIL FILES=06,
INCLUDE=(14,9,ZD,GE,026011859,AND,14,9,ZD,LE,031057945)
OUTFIL FILES=07,
INCLUDE=(14,9,ZD,GE,031057946,AND,14,9,ZD,LE,033135740)
OUTFIL FILES=08,
INCLUDE=(14,9,ZD,GE,033135741,AND,14,9,ZD,LE,040020314)
OUTFIL FILES=09,
INCLUDE=(14,9,ZD,GE,040020315,AND,14,9,ZD,LE,046020577)
OUTFIL FILES=10,
INCLUDE=(14,9,ZD,GE,046020578,AND,14,9,ZD,LE,052061168)
OUTFIL FILES=11,
INCLUDE=(14,9,ZD,GE,052061169,AND,14,9,ZD,LE,054243904)
OUTFIL FILES=12,
INCLUDE=(14,9,ZD,GE,054243905,AND,14,9,ZD,LE,059011853)
OUTFIL FILES=13,
INCLUDE=(14,9,ZD,GE,059011854,AND,14,9,ZD,LE,063011296)
OUTFIL FILES=14,
INCLUDE=(14,9,ZD,GE,063011297,AND,14,9,ZD,LE,068030052)
OUTFIL FILES=15,
INCLUDE=(14,9,ZD,GE,068030053,AND,14,9,ZD,LE,076140837)
OUTFIL FILES=16,
INCLUDE=(14,9,ZD,GE,076140838,AND,14,9,ZD,LE,083061355)
OUTFIL FILES=17,
INCLUDE=(14,9,ZD,GE,083061356,AND,14,9,ZD,LE,090011828)
OUTFIL FILES=18,
INCLUDE=(14,9,ZD,GE,090011829,AND,14,9,ZD,LE,096011946)
OUTFIL FILES=19,
INCLUDE=(14,9,ZD,GE,096011947,AND,14,9,ZD,LE,204070595)
OUTFIL FILES=20,
INCLUDE=(14,9,ZD,GE,204070596,AND,14,9,ZD,LE,211010053)
OUTFIL FILES=21,
INCLUDE=(14,9,ZD,GE,211010054,AND,14,9,ZD,LE,215030637)
OUTFIL FILES=22,
INCLUDE=(14,9,ZD,GE,215030638,AND,14,9,ZD,LE,238015142)
OUTFIL FILES=23,
INCLUDE=(14,9,ZD,GE,238015143,AND,14,9,ZD,LE,261120413)
OUTFIL FILES=24,
INCLUDE=(14,9,ZD,GE,261120414,AND,14,9,ZD,LE,999999999) |
The sort card pasted above is a dynamically created sort card.
The sort utility which we use is SORT45GB.This utility does the dynamic allocation of the work space based on the input file size. The workspace is allocated will be 1.3 times of the input file size.
The issue we face is this step alone is taking 55 minutes , due to which the performance of the job is degraded. Is there anyway we can improve the performance.
Code'd |
|