Performace Tunning - SORT is taking around 5 CPU mints.



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Performace Tunning - SORT is taking around 5 CPU mints.

Postby usp343 » Wed May 15, 2013 1:36 am

Hi,

We have one job which sort a big file which is in tape and taking almost 5 CPU mints to complete that.

Do we have any parameters which can improve the performance? In our job we are using below SORT:-

S20Z0270 EXEC PGM=SORT,REGION=0M,
PARM='RELEASE=OFF,VSCORET=12M'
SORTIN DD DSN=#########.#######.DISKOA.D13APR,
DISP=(SHR,KEEP)
SORTOUT DD DSN=##########.######.SORT1.D13APR,
DISP=(NEW,CATLG),
UNIT=TAPE,VOL=(,,,15),
RETPD=&RETPD,
RETPD=30,
DCB=(RECFM=VB,LRECL=28793,BLKSIZE=28797)

SYSIN DD SUBSYS=(CCSS,
' OMIT COND=((17,6,CH,EQ,C''000002''))',
' SORT FIELDS=(5,10,BI,A,17,6,BI,A,27,17,BI,A,',
' 46,1,BI,A,44,2,BI,A,15,2,BI,A)',
' END')
usp343
 
Posts: 4
Joined: Thu Jan 03, 2013 9:32 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Performace Tunning - SORT is taking around 5 CPU mints.

 

Re: Performace Tunning - SORT is taking around 5 CPU mints.

Postby Akatsukami » Wed May 15, 2013 1:38 am

What is the amount of data that you are sorting?
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: Performace Tunning - SORT is taking around 5 CPU mints.

Postby dick scherrer » Wed May 15, 2013 2:03 am

Hello,

Is the entire record needed for the output or only part of it?

If the process can fill up to 15 tape volumes, it will probably take a while.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Performace Tunning - SORT is taking around 5 CPU mints.

Postby usp343 » Wed May 15, 2013 2:21 am

yes Dick we need entire records in output........
usp343
 
Posts: 4
Joined: Thu Jan 03, 2013 9:32 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Performace Tunning - SORT is taking around 5 CPU mints.

Postby dick scherrer » Wed May 15, 2013 2:40 am

Hello,

As Akatsukami asked - How much data is being sorted?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Performace Tunning - SORT is taking around 5 CPU mints.

Postby BillyBoyo » Wed May 15, 2013 3:24 am

How about showing the sysout from a completed step?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Performace Tunning - SORT is taking around 5 CPU mints.

Postby usp343 » Wed May 15, 2013 6:31 am

Hi all,

its qtr end production job so sysout is not available but what I remember it processed 50GB data I believe....
usp343
 
Posts: 4
Joined: Thu Jan 03, 2013 9:32 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Performace Tunning - SORT is taking around 5 CPU mints.

Postby NicC » Wed May 15, 2013 5:47 pm

Well, without SYSOUT we cannot advance any further. And why do you not keep the last execution of a production job? That is just criminal (and possiby illegal).
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post