|
View previous topic :: View next topic
|
| Author |
Message |
thesumitk
Active User
Joined: 24 May 2013
Posts: 156
Location: INDIA
|
|
|
|
Hi All,
Need your help in below scenario !!
I have a job runing daily in the system .. job is taking 10 mins at below sort step
| Code: |
PS010 EXEC PGM=SORT
//SORTLIB DD DSN=SORTLIB,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTIN DD DISP=SHR,DSN=&MODE..&SRCCUR.&GDG0
// DD DISP=SHR,DSN=&MODE..&SRCCUR1.&GDG0
// DD DISP=SHR,DSN=&MODE..&SRCCUR2.&GDG0
// DD DISP=SHR,DSN=&MODE..&SRCCUR3.&GDG0
//SORTOUT DD DSN=&MODE..SBO01T00.SRCCUR.&JOBNOD,
// DISP=(NEW,CATLG,DELETE),
// UNIT=&UNIT1,
// SPACE=&SPACE,
// DCB=(MODEL,RECFM=FB,LRECL=1600,BLKSIZE=0)
//SORTWK01 DD UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK02 DD UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK03 DD UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK04 DD UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK05 DD UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK06 DD UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK07 DD UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK08 DD UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK09 DD UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK10 DD UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SYSIN DD *
SORT FIELDS=(8,20,CH,A,313,8,CH,A,387,6,PD,A)
//* |
Input records are almost 35000000 each day .. I was wondering if can tune this step by anyway..
Please provide your inputs on this .. Many thanks in advance !!! |
|
| Back to top |
|
 |
prino
Senior Member
Joined: 07 Feb 2009
Posts: 1322
Location: Vilnius, Lithuania
|
|
|
|
| Sort all input files when they are created and do a merge in this procedure. |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2482
Location: @my desk
|
|
|
|
| Quote: |
| job is taking 10 mins at below sort step |
Is this the elapsed time? If so, what about the CPU mins? |
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
| Why are yuou specifying a MODEL DCB when you are not creating a GDG? Why are you specify DCB at all? Why are you specifying SORTWK? |
|
| Back to top |
|
|
thesumitk
Active User
Joined: 24 May 2013
Posts: 156
Location: INDIA
|
|
|
|
Elapsed time is -11.09
CPU mins are -1.455
SORT work files are added when the job was created I am not sure if they are the reason of long run.. PLease sugegst
we are using DCB because creating a new output file with diffrent rules than input file.
Thanks |
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
| Sort will create the file with the correct DCB information for you. As to the sort work files - try running with dynamc allocation and compare the results. There may be no difference but sort will allocated only what it needs. It would also help if you give sort the estimated number of records to be processed. |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
|
|
|
|
| 10 minutes elapsed time to sort 35 million 1600-byte records does not sound too bad. You will find as you progress in your career that you cannot do much tuning on sort -- whether you are using DFSORT or SyncSort or another sort package, they are typically pretty much tuned by the vendor. Some changes, such as dynamic allocation instead of coding SORTWK files, may help somewhat but you're not going to make a few changes and cut 90% of the elapsed time out of the sort. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
Why does someone believe that 10 minutes elapsed time is "too much"? |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
| dick scherrer wrote: |
| Why does someone believe that 10 minutes elapsed time is "too much"? |
Ditto, specially when the number of records involved in are 35M+... |
|
| Back to top |
|
|
thesumitk
Active User
Joined: 24 May 2013
Posts: 156
Location: INDIA
|
|
|
|
Ok..Thanks all for your inputs !!..
I will leave this job as is then and move forward to see some other opportunity for batch run tyime reduction.. Thanks |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2482
Location: @my desk
|
|
|
|
| Quote: |
| move forward to see some other opportunity for batch run tyime reduction |
Yes, the ones which are running for hours  |
|
| Back to top |
|
|
thesumitk
Active User
Joined: 24 May 2013
Posts: 156
Location: INDIA
|
|
| Back to top |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
