Baskaran Warnings : 1 New User
Joined: 24 Oct 2006 Posts: 32 Location: India
|
|
|
|
I have request to do a performance tuning of a exixting batch job:
Function of this job:
unload a data from a VIEW then sort it and load to a different table.
unload step :
//UI66UNL1 EXEC PROC=PLPUNLOD,
// OUTDSN=PLP.INFODB.DATA1066.EXTRACT(+1),
// SYSIN=UI66UNL1, * VLP_TXNHIST_EXT1066
// UNLDTME=60
//UNLOAD.SYSREC00 DD DSN=PLP.INFODB.DATA1066.EXTRACT(+1),
// DISP=(NEW,CATLG),
// UNIT=PROD,DATACLAS=MULTIVOL,
// SPACE=(CYL,(1500,15),RLSE),BUFNO=30,
// DCB=(PTS.MODEL,RECFM=FB,LRECL=223)
sort step:
FIELDS=(7,2,CH,A,19,2,CH,A,39,10,CH,A,27,7,PD,A,1,6,PD,A)
load step:
//LOAD9015 EXEC PROC=PLPLOAD1,
// COND.LOAD=(0,NE,PLPDLI28.SORT1015),
// INDD=PLP.INFODB.DATA1015.SORTED(+1),
// MEMBER=IFPL9015,
// SYSTEM=PDB2,
// UTPROC='',
// SPACE1='(CYL,(200,20),RLSE)', * WORKING SPACE(INDEX)
// UID='PLPNGEC0'
My question:
What i should do to fine tune this job so it take less time to complete |
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Quote: |
// DCB=(PTS.MODEL,RECFM=FB,LRECL=223) |
CODE RECFM=FB,LRECL=223
As I have said many times on help boards, a model / pattern DSCB is not required for ANY GDG being created. Go talk to your storage people and ask them to set up a dummy DATACLAS to be allocated to ALL GDG datasets being created, DASD, Tape, SMS, NONSMS.
Makes life so much easier. Your model DSCB may have a BLKSIZE of 233 which would be a performance pain. |
|