How to calculate sortwork



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: How to calculate sortwork

Postby BillyBoyo » Sun Jun 02, 2013 4:37 am

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: How to calculate sortwork

Postby skolusu » Mon Jun 03, 2013 9:31 pm

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
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: How to calculate sortwork

Postby samb01 » Tue Jun 04, 2013 7:45 pm

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 do not have the required permissions to view the files attached to this post.
samb01
 
Posts: 427
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 1 time
Been thanked: 0 time

Re: How to calculate sortwork

Postby skolusu » Tue Jun 04, 2013 11:36 pm

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
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: How to calculate sortwork

Postby samb01 » Wed Jun 05, 2013 12:52 pm

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...
samb01
 
Posts: 427
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 1 time
Been thanked: 0 time

Re: How to calculate sortwork

Postby NicC » Wed Jun 05, 2013 5:47 pm

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?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: How to calculate sortwork

Postby Robert Sample » Wed Jun 05, 2013 6:00 pm

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.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: How to calculate sortwork

Postby samb01 » Wed Jun 05, 2013 6:48 pm

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 ?
You do not have the required permissions to view the files attached to this post.
samb01
 
Posts: 427
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 1 time
Been thanked: 0 time

Re: How to calculate sortwork

Postby Akatsukami » Wed Jun 05, 2013 8:06 pm

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.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: How to calculate sortwork

Postby samb01 » Wed Jun 05, 2013 8:12 pm

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.
samb01
 
Posts: 427
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 1 time
Been thanked: 0 time

PreviousNext

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post