how calculate time spended in a sort

elmister · New User Joined: 27 Nov 2005 Posts: 14

Hi, i need know how to do the calculation of time that spend one sort. There is some formula?.
Thanks

Frank Yaeger · Posted: Tue Dec 12, 2006 10:07 pm

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.

elmister · New User Joined: 27 Nov 2005 Posts: 14

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.

Frank Yaeger · Posted: Tue Dec 12, 2006 11:32 pm

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.)

dick scherrer · Posted: Wed Dec 13, 2006 4:11 am

Hello,

Could adding BUFNO to the input and output DDs help?

Frank Yaeger · Posted: Wed Dec 13, 2006 6:26 am