Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Is my Syncsort job Optimal

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
chinnielr

New User


Joined: 11 Jul 2005
Posts: 87

PostPosted: Thu Jun 05, 2008 11:24 am    Post subject: Is my Syncsort job Optimal
Reply with quote

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
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Thu Jun 05, 2008 2:47 pm    Post subject:
Reply with quote

If you would post the sysouts, it might help us.....
Back to top
View user's profile Send private message
chinnielr

New User


Joined: 11 Jul 2005
Posts: 87

PostPosted: Thu Jun 05, 2008 6:33 pm    Post subject: Reply to: Is my SORT Optimal
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Jun 05, 2008 7:02 pm    Post subject:
Reply with quote

What exactly do you mean by optimal ?
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Thu Jun 05, 2008 8:33 pm    Post subject: Re: Is my Syncsort job Optimal
Reply with quote

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
View user's profile Send private message
chinnielr

New User


Joined: 11 Jul 2005
Posts: 87

PostPosted: Mon Jun 09, 2008 5:44 pm    Post subject: Reply to: Is my Syncsort job Optimal
Reply with quote

Alissa,

I am looking whether I can fine tune CPU time or not.

Please help.

Thanks.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Mon Jun 09, 2008 8:29 pm    Post subject: Re: Reply to: Is my Syncsort job Optimal
Reply with quote

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
View user's profile Send private message
chinnielr

New User


Joined: 11 Jul 2005
Posts: 87

PostPosted: Tue Jun 10, 2008 5:36 pm    Post subject: Reply to: Is my Syncsort job Optimal
Reply with quote

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
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Fri Jun 13, 2008 1:53 am    Post subject: Re: Reply to: Is my Syncsort job Optimal
Reply with quote

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
View user's profile Send private message
chinnielr

New User


Joined: 11 Jul 2005
Posts: 87

PostPosted: Mon Jun 16, 2008 4:29 pm    Post subject: Reply to: Is my Syncsort job Optimal
Reply with quote

Alissa,

Please find attach the complete job listing. Please let me know if you need any other information.

Thanks,
Chinni.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Mon Jun 16, 2008 7:43 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us