View previous topic :: View next topic
|
Author |
Message |
chinnielr
New User
Joined: 11 Jul 2005 Posts: 87
|
|
|
|
Hi,
Can somebody tell me whether my below sort is optimal.
Code: |
OMIT COND=(16,4,CH,EQ,C'6000',OR,
16,4,CH,EQ,C'5000')
SORT FIELDS=(16,4,CH,A,20,CH,A)
OUTFIL FILES=01,
INCLUDE=(16,4,CH,EQ,C'8000')
OUTILF FILES=02,
INCLUDE=(31,1,CH,NE,C' ')
OUTFIL FILES=03,
INCLUDE=(31,1,CH,EQ,C' ')
|
Its an FB file with LRECL=350.
Please let me know whether my sort is optimal or not. If not please let me know what needs to be changed.
The reason behind this is the sort takes 1 minute to complete. I know it depends on the number of records and sort conditions. But to ensure it's an optimal one. |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
If you would post the sysouts, it might help us..... |
|
Back to top |
|
|
chinnielr
New User
Joined: 11 Jul 2005 Posts: 87
|
|
|
|
Can you please tell me how SYSOUT messages will be used to check whether the sort is optimal or not?
Please find below the SYSOUT
93,060K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
0 BYTES RESERVE REQUESTED, 93,024K BYTES USED
32K BYTES OF EMERGENCY SPACE ALLOCATED
SORTIN : FB ; LRECL= 350; BLKSIZE=27650
SORTOF01 : FB ; LRECL= 350; BLKSIZE=27650
SORTOF02 : FB ; LRECL= 350; BLKSIZE=27650
SORTOF03 : FB ; LRECL= 350; BLKSIZE=27650
92,032K BYTES OF VIRTUAL STORAGE AVAILABLE ABOVE THE 16MEG LI
0 BYTES RESERVE REQUESTED, 92,032K BYTES USED
G=92464,B=160,BIAS=00
0 PREALLOCATED SORTWORK TRACKS, 45,000 DYNAMICALLY ALLOCATED,
etc... |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
What exactly do you mean by optimal ? |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
chinnielr wrote: |
Can somebody tell me whether my below sort is optimal. |
Are you looking to tune CPU time or wall clock Elapsed time Performance? |
|
Back to top |
|
|
chinnielr
New User
Joined: 11 Jul 2005 Posts: 87
|
|
|
|
Alissa,
I am looking whether I can fine tune CPU time or not.
Please help.
Thanks. |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
chinnielr wrote: |
I am looking whether I can fine tune CPU time |
Please rerun the sort step in question with the following JCL added:
Code: |
//$ORTPARM DD *
MSG=AP,LIST,BMSG,GMSG,DEBUG
//SPYSET DD SYSOUT=* |
This will produce additional messages and diagnostic output that will assist me in tuning your application. Feel free to send me the complete job listing offline and I would be happy to assist you further. You can email it to me as a text attachment to alissa.margulies@syncsort.com.
Once I have reviewed the listing, I can then post any recommendations. |
|
Back to top |
|
|
chinnielr
New User
Joined: 11 Jul 2005 Posts: 87
|
|
|
|
Alissa,
Are you looking to tune CPU time or wall clock Elapsed time Performance?
I have sent the details to your email ID.
If we can reduce either CPU or total elapsed time is good.
But are there anyways to reduce total elapsed time in SORT?
Please suggest!!
Thanks in advance. |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
chinnielr wrote: |
If we can reduce either CPU or total elapsed time is good. |
Based on the listing you provided, I think you are performing optimally if you are focusing on elapsed time.
However, you initially indicated to me that you were looking to improve CPU time. If you are still interested in pursuing this, then you need to provide me with the output I originally requested. You will need to rerun the job with the following JCL added to the sort step in question:
Code: |
//$ORTPARM DD *
MSG=AP,LIST,BMSG,GMSG,DEBUG
//SPYSET DD SYSOUT=* |
Once I have the output from that job, I will be able to see if this application can be tweaked to perform any better in regards to CPU time.
Thank you. |
|
Back to top |
|
|
chinnielr
New User
Joined: 11 Jul 2005 Posts: 87
|
|
|
|
Alissa,
Please find attach the complete job listing. Please let me know if you need any other information.
Thanks,
Chinni. |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
This is still not what I requested. There are no 'G' messages and no DEBUG listing. I cannot help you if you do not provide me with the requested output. Also, please do not post the output as a download on the forum. All the formatting is lost and it makes it very difficult to review. Please forward the complete and unedited output with all the requested components as a text attachment to me at alissa.margulies@syncsort.com. Thank you. |
|
Back to top |
|
|
|