Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
how calculate time spended in a sort

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
elmister

New User


Joined: 27 Nov 2005
Posts: 14

PostPosted: Tue Dec 12, 2006 9:38 pm    Post subject: how calculate time spended in a sort
Reply with quote

Hi, i need know how to do the calculation of time that spend one sort. There is some formula?.
Thanks
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Dec 12, 2006 10:07 pm    Post subject:
Reply with quote

No, there's no formula. The amount of time for a sort run depends on many factors including the sort product used, number of records, RECFM and LRECL of the file, resources available, etc.
Back to top
View user's profile Send private message
elmister

New User


Joined: 27 Nov 2005
Posts: 14

PostPosted: Tue Dec 12, 2006 10:30 pm    Post subject: Re: how calculate time spended in a sort
Reply with quote

Thanks. Take a look to the following jcl. Maybe you can talk me how improve it for to run more quick.


//**********************************************************************
//*B.SD SORT OF CTLQMAE1 PARTITION *
//**********************************************************************
//STEP030 EXEC PGM=ICEMAN,COND=(0,LT)
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTWK01 DD SPACE=(CYL,(1,5),RLSE)
//SORTWK02 DD SPACE=(CYL,(1,5),RLSE)
//SORTWK03 DD SPACE=(CYL,(1,5),RLSE)
//SORTWK04 DD SPACE=(CYL,(1,5),RLSE)
//SORTWK05 DD SPACE=(CYL,(1,5),RLSE)
//SORTWK06 DD SPACE=(CYL,(1,5),RLSE)
//*
//*B.IF PARTIT.FILES OF THE ACCOUNTS TO BE SETTLED ON THE CURRENT DAY.
//SORTIN DD DSN=&HLQ..BAT1SBAS.CTLQMAE1.PART1.D%%ODATE,DISP=SHR
// DD DSN=&HLQ..BAT1SBAS.CTLQMAE1.PART2.D%%ODATE,DISP=SHR
// DD DSN=&HLQ..BAT1SBAS.CTLQMAE1.PART3.D%%ODATE,DISP=SHR
// DD DSN=&HLQ..BAT1SBAS.CTLQMAE1.PART4.D%%ODATE,DISP=SHR
// DD DSN=&HLQ..BAT1SBAS.CTLQMAE1.PART5.D%%ODATE,DISP=SHR
// DD DSN=&HLQ..BAT1SBAS.CTLQMAE1.PART6.D%%ODATE,DISP=SHR
// DD DSN=&HLQ..BAT1SBAS.CTLQMAE1.PART7.D%%ODATE,DISP=SHR
// DD DSN=&HLQ..BAT1SBAS.CTLQMAE1.PART8.D%%ODATE,DISP=SHR
//*B.OF MAEAUX FILE OF THE ACCOUNTS TO BE SETTLED ON THE CURRENT DAY.
//SORTOUT DD DSN=&HLQ..BAT1SBAS.CTLQMAE1.D%%ODATE,
// DISP=(,CATLG,DELETE),VOL=(,,,20),
// SPACE=(CYL,(70,100),RLSE)
//SYSIN DD *
SORT FIELDS=COPY
END
/*


Thanks for you help.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Dec 12, 2006 11:32 pm    Post subject:
Reply with quote

It's a simple COPY so it should run fine as is. However, you should remove the //SORTWKdd DD statements as they are NOT used for a COPY, so they are just causing the system to do needless allocations.

Adding more storage might make it run faster, depending on how much storage you're allowing it to use now.

If you're using DFSORT and you want me to take a look, add the following to the job so I can see the diagnostic messages:

//SORTDIAG DD DUMMY

and show me the //SYSOUT messages. (Remove the SORTDIAG statement afterwards since it produces extra messages you don't normally need.)
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Dec 13, 2006 4:11 am    Post subject:
Reply with quote

Hello,

Could adding BUFNO to the input and output DDs help?
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Dec 13, 2006 6:26 am    Post subject:
Reply with quote

Quote:
Could adding BUFNO to the input and output DDs help?


Not for DFSORT. It does it own buffer optimization and ignores BUFNO.

Large BLKSIZEs can help. Note that DFSORT will generally use them for output automatically since System Determined Blocksizes (SDB) is the shipped default. Of course, DFSORT has no control over the input blocksizes.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. 00D3003B - time outs in DB2 when invo... chavinash2004 DB2 2 Mon Oct 09, 2017 4:39 pm
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am
No new posts Comparing 2 Files using Current time arunsoods SYNCSORT 9 Fri Sep 22, 2017 6:00 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us