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 |
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
you need to determine which utilities are being invoked by the unload, sort and load step. there are many 3rd party utilities that perform these functions in addition to IBM supplied utilities. So, once you know which utilities are being used, you need to research these utilities to determine how to fine tune them. |
|