Page 2 of 4

Re: How to calculate sortwork

PostPosted: Sun Jun 02, 2013 4:37 am
by BillyBoyo
Forget the LRECL. You have the average length (204) so you know how much input and output there will be.

Kolusu won't be back here until start of business on the West Coast, USA. I think that he will suggest that you send information to the DFSORT support team, who would give you the best possible advice with what you can supply to them.

Changing from tape to DASD is only going to affect the reading of the data, and the writing of the data, so is far from being a cure-all.

Re: How to calculate sortwork

PostPosted: Mon Jun 03, 2013 9:31 pm
by skolusu
samb01 wrote:But i would like to know if the sort will work more quiclkly ?

Actually i have 12 tape on entry et 12 tape out.

I think it will be work fatser if the dataset is on disk. What do you think about it.

The problem is the size of the dataset : 712 000 000 records with 624 lrecl.

I calculate 50 disk model 9 (our disk are model 9). Actually we don't have enought disk... but we can ask for having more disk if we can win time by doing the sort ondisk. Only if it worth it.


What does quick mean? CPU time or elapsed time? DASD files doe NOT have the mount times , so you will be saving on that time. If you still need the job to be analyzed, Please add the following to your job so we can see the diagnostic mesages:

//SORTDIAG DD DUMMY

Then rerun the job and post the complete JES log including the //SYSOUT messages to dfsort@us.ibm.com

Re: How to calculate sortwork

PostPosted: Tue Jun 04, 2013 7:45 pm
by samb01
Hello,

i tryed the sort by getting rid of the sortwork. I want to let the system calculate the sortwork, but it doesn't work. The sysout of the job is in the attached file.



Why it doesn't work.

The value of DYNAUTO is YES.

Re: How to calculate sortwork

PostPosted: Tue Jun 04, 2013 11:36 pm
by skolusu
samb01 wrote:Hello,

i tryed the sort by getting rid of the sortwork. I want to let the system calculate the sortwork, but it doesn't work. The sysout of the job is in the attached file.

Why it doesn't work.

The value of DYNAUTO is YES.


You serious? You haven't used any of my suggestions and your file size is enormous(146,411,286,840) with an average LRECL of 361 and you don't even have enough DASD for a single work dataset. You still wondering why your job failed?

 ICE083A D RESOURCES WERE UNAVAILABLE FOR DYNAMIC ALLOCATION OF WORK DATA SETS (
 ICE753I 0 FWK=(0,0) SWK=(0,0) TWK=(0,0) RWK=(0,0) TOTAL=(0,0) BLK=56664
 ICE248I 0 ATTEMPTED TO ALLOCATE 214185MB OF DISK WORK SPACE ON 3 WORK DATA SETS
 ICE249I 0 SUCCESSFULLY ALLOCATED 0MB OF DISK WORK SPACE ON 0 WORK DATA SETS

 ICE752I 0 FSZ=146411286840 BC  IGN=0 E  AVG=361 0  WSP=219325489 C  DYN=0 56664

Re: How to calculate sortwork

PostPosted: Wed Jun 05, 2013 12:52 pm
by samb01
i have DASD but i just want letting DFSORT calculate autmaticly DYNALLOC.
It's not possible ?

So OK, if it's not possible how can i calculate the number eand the values of the optimal sort work ?

Actually i am using 60 sortwork with the space : 100,200 cylinders.

//SORTWK01 DD DSN=PRTGF.TGRI.SORTWK01, 
//            SPACE=(CYL,(100,200)),UNIT=3390, 
//            DISP=(,DELETE,DELETE)             
//*                                             



It work but i wonder if it is optimised...

Re: How to calculate sortwork

PostPosted: Wed Jun 05, 2013 5:47 pm
by NicC
I suggest you actually try implementing what Kolusu specified on the first page of this topic - go back and read and obey. In there he is showing you how to do the dynamic allocation. Why post if you are not going to read and understand the replies?

Re: How to calculate sortwork

PostPosted: Wed Jun 05, 2013 6:00 pm
by Robert Sample
i have DASD but i just want letting DFSORT calculate autmaticly DYNALLOC.
It's not possible ?
It may or may not be possible -- so far you have not followed instructions you have been given so you cannot say that DYNALLOC cannot be done on your system.

Re: How to calculate sortwork

PostPosted: Wed Jun 05, 2013 6:48 pm
by samb01
heelo,

i tryed but it doesn't work...

here is the sysout. Thank's for your help..

Just an other think, i thought the number of sortwork is limited to 32... So 60 sortworks is too much ?

Re: How to calculate sortwork

PostPosted: Wed Jun 05, 2013 8:06 pm
by Akatsukami
samb01 wrote:heelo,

i tryed but it doesn't work...

here is the sysout.

Cut and paste in Code tags, kusomushi; we're not going to contaminate our or our clients' machines with your malware.

Just an other think, i thought the number of sortwork is limited to 32... So 60 sortworks is too much ?

If instead of trying to think you'd read the fine manual, you'd have seen that the maximum is 255 if Blockset is used.

Re: How to calculate sortwork

PostPosted: Wed Jun 05, 2013 8:12 pm
by samb01
Why are you saying it's a malware ?

It is just the sysout of the job....

The forum allow us to upload it, i am uusing it, that's all.