Previous Topic: Database Load (Step 2)Next Topic: Prefix (Concatenated Key) Resolution (Step 4)


Workfile Sort/Merge (Step 3)

The JCL to merge/sort the logical workfiles produced by the load step is shown below:

Workfile Sort/Merge (Step 3) (z/OS)

// SORT  EXEC  SORT
//SORTIN DD DSN=step2.workfile,DISP=OLD,UNIT=TAPE
//SORTOUT DD DSN=step3.workfile,DISP=OLD,UNIT=TAPE
//SORTWK01 DD UNIT=DISK,SPACE=(CYL,(n),,CONTIG)
//SORTWK02 DD UNIT=DISK,SPACE=(CYL,(n),,CONTIG)
//SORTWK03 DD UNIT=DISK,SPACE=(CYL,(n),,CONTIG)
//SYSIN  DD *
SORT  FIELDS=(25,5,BI,A)
/*
//

n

number of cylinders for space allocation

step2.workfile

the workfile output from Step 2

step3.workfile

the sorted workfile output by this step

Note: This step requires that you use your own sort/merge facility.

Workfile Sort/Merge (Step 3) (z/VSE)

// TLBL  SORTIN1,'logical.workfile'
// ASSGN  SYS001,nnn
// TLBL  SORTOUT,'sorted.workfile'
// ASSGN  SYS002,nnn
// DLBL  SORTWK1,'work.file1'
// EXTENT  SYS003,1,0,ssss,llll
// ASSGN  SYS003,DISK,VOL=nnnnnn,SHR
// DLBL  SORTWK2,'work.file2'
// EXTENT  SYS004,1,0,ssss,llll
// ASSGN  SYS004,DISK,VOL=nnnnnn,SHR
// DLBL  SORTWK3,'work.file3'
// EXTENT  SYS005,ERES00,1,,ssss,llll
// ASSGN  SYS005,DISK,VOL=nnnnnn,SHR
// EXEC SORT
   SORT FIELDS=(25,5,BI,A),FILES=1,WORK=3
   RECORD TYPE=F,LENGTH=288
   INPFIL BLKSIZE=32544
   OUTFIL BLKSIZE=32544
/*

logical.workfile

data set name of the logical workfile produced by LOAD processing

sorted.workfile

data set name of the sorted workfile produced by this SORT set

nnn

cuu address of the tape unit

nnnnnn

volume serial number of the disk unit

work.file1

file-id of the first SORT work file

work.file2

file id of the second SORT work file

work.file3

file id of the third SORT work file

ssss

starting track in disk extent

llll

number of tracks in disk extent