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 dick scherrer » Fri Jun 07, 2013 1:42 am

Agreed. My suggestion is something to do when it really needs done Now and there is no hardware solution in sight.

Splitting the file is a simple step and the next N steps are the original sort cloned N times for each of the split files. Tghe last step should be to merge the smaller split files (and then delete the split files).
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: How to calculate sortwork

Postby samb01 » Fri Jun 07, 2013 1:02 pm

Hello,

i have an idea but i don't know if it's possible.

I would like to know how dfsort allocate the work dataset (enven if it abend)

VOL SER NOS= VPUB01.
SYS13156.T150720.RA000.DFSORT01.R0130297 DELETED
VOL SER NOS= VPUB01.
SYS13156.T150720.RA000.DFSORT01.R0130298 DELETED
VOL SER NOS= VPUB01.
SYS13156.T150721.RA000.DFSORT01.R0130299 DELETED
VOL SER NOS= VPUB01.
SYS13156.T150722.RA000.DFSORT01.R0130300 DELETED
VOL SER NOS= VPUB01.
SYS13156.T150723.RA000.DFSORT01.R0130301 DELETED




and after i will copy dfsort allocation by including the work dataset in the jcl but the dataset :

SYS13156.T150720.RA000.DFSORT01.R0130298
etc..

are deleted.

Is there a way to keep that dataset in the catalog because i would like ta see their allocation..

It's just an idea, i don't know if it is possible.


About the abend, we have only one volume : VPUB01 for the work dataset. It's a model 9.
samb01
 
Posts: 431
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 1 time
Been thanked: 0 time

Re: How to calculate sortwork

Postby skolusu » Fri Jun 07, 2013 10:18 pm

samb01 wrote:Hello,

i have an idea but i don't know if it's possible.

I would like to know how dfsort allocate the work dataset (enven if it abend)


I am not sure as to why you want to reinvent the wheel in here. DFSORT allocates SORTWORKS with Primary of zero and then acquires the secondary allocations as when it is needed. You need to talk to your systems programmer as to why you aren't getting the required sortwork allocation.

If you are able to allocate 60 JCL sortworks with UNIT=3390, you can specify that on DYNALLOC too.

Change DYNALLOC=(,60) to DYNALLOC=(3390,60)
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 » Mon Jun 10, 2013 1:40 pm

Hello,

i have the same error message...

ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5                 
ICE805I 1 JOBNAME: uj02132A , STEPNAME: TRI41                         
ICE802I 0 BLOCKSET     TECHNIQUE IN CONTROL                           
ICE905I 0 I : RF=80,LR=626,BLK=32760,BCT=4469209                       
ICE143I 0 BLOCKSET     SORT  TECHNIQUE SELECTED                       
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EX
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R12 - 10:04
           SORT FIELDS=(22,91,A),FORMAT=CH                             
           OPTION AVGRLEN=204,DYNALLOC=(3390,60),FILSZ=E730000000     
ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5                 
ICE083A D RESOURCES WERE UNAVAILABLE FOR DYNAMIC ALLOCATION OF WORK DAT
ICE753I 0 FWK=(0,0) SWK=(1,56377) TWK=(0,0) RWK=(0,0) TOTAL=(1,56377) B
ICE248I 0 ATTEMPTED TO ALLOCATE 228491MB OF DISK WORK SPACE ON 60 WORK
ICE249I 0 SUCCESSFULLY ALLOCATED 3046MB OF DISK WORK SPACE ON 1 WORK DA
ICE751I 0 C5-K76982 C6-K90026 C7-K82419 C8-K67572 E9-K60824 C9-BASE   E
ICE750I 0 DC 0 TC 146411286840 CS DSVRR KSZ 95 VSZ 95                 
ICE752I 0 FSZ=146411286840 BC  IGN=730000000 E  AVG=251 204  WSP=233975
ICE052I 3 END OF DFSORT                                               



It go on to use the disk VPUB01.( VPUB01 is a disk 3390...)

Is there a way to force DFSORT DYNALLOC to use a particular storclass ? I would like to use other disk than VPUB01 by codind DYNALLOC.
samb01
 
Posts: 431
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 1 time
Been thanked: 0 time

Re: How to calculate sortwork

Postby skolusu » Mon Jun 10, 2013 9:30 pm

samb01 wrote:It go on to use the disk VPUB01.( VPUB01 is a disk 3390...)

Is there a way to force DFSORT DYNALLOC to use a particular storclass ? I would like to use other disk than VPUB01 by codind DYNALLOC.


How about talking to your systems programmer? You have been working on this issue for about a week now and yet you haven't talked to your systems programmer who in this case is the right person to talk to. There is nothing much we can do.
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 » Mon Jun 10, 2013 11:20 pm

OK, thank's for your help skolusu.
samb01
 
Posts: 431
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 1 time
Been thanked: 0 time

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post