SUM FIELDS=NONE and ON(x,x,x) length limit



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

SUM FIELDS=NONE and ON(x,x,x) length limit

Postby jonnavarra » Fri Jun 18, 2010 4:43 am

SYNCSORT FOR Z/OS 1.3.2.1NI
My records are 5560 chars long.
SORT FIELDS=(1,4093,CH,A)
SUM FIELDS=NONE

Above abends but value less than 4093 works.
The ON operand apparently has 1500 limit...

Anyway to get around these limitations?

appreciate any help!

Jon
jonnavarra
 
Posts: 4
Joined: Fri Jun 18, 2010 4:23 am
Has thanked: 0 time
Been thanked: 0 time

Re: SUM FIELDS=NONE and ON(x,x,x) length limit

Postby dick scherrer » Fri Jun 18, 2010 8:51 am

Hello and welcome to the forum,

What is it that you are trying to accomplish? I have never seen a business reason to use a 4k sort key. . .

If you explain the actual requirement, someone may have a suggestion.
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: SUM FIELDS=NONE and ON(x,x,x) length limit

Postby jonnavarra » Fri Jun 18, 2010 6:00 pm

its crazy really but mostly bad design... just got loaned into the project helping out.

I want to compare yesterdays (Y) and todays (T) datasets and get rid of duplicates in them before producing files with what's in Y not in T, in T not in Y and in both.

Any column in a record can change so I really have to compare all 6650 chars of them. I have the control statements to do the compares up to 4K chars... I've tried several ways to extend beyond that but i get this;

WER164B 12K BYTES RESERVE REQUESTED, 1,004K BYTES USED
WER146B 20K BYTES OF EMERGENCY SPACE ALLOCATED
WER017A ERR IN DISP LENGTH VALUE
WER108I SORTIN : RECFM=FB ; LRECL= 6650; BLKSIZE= 26600

Searched but can't find anything on WER017A. Suggestions are welcomed.

Thanks
jonnavarra
 
Posts: 4
Joined: Fri Jun 18, 2010 4:23 am
Has thanked: 0 time
Been thanked: 0 time

Re: SUM FIELDS=NONE and ON(x,x,x) length limit

Postby Alissa Margulies » Fri Jun 18, 2010 8:25 pm

Hello Jon.

For fixed-length records, all control fields and the sum of their lengths cannot exceed 4092 bytes. When EQUALS is in effect, the number is reduced 4 bytes to 4088 bytes. EXTCOUNT also reduces the number by 4 bytes. Thus, if both EQUALS and EXTCOUNT are in effect, the number is reduced to 4084 bytes.

For variable-length records, all control fields must be located within the first 32750 bytes and the sum of their lengths cannot exceed 4084 bytes. When EQUALS is in effect, all control fields must be located within the first 32746 bytes and the sum of their lengths cannot exceed 4080 bytes.

Regards,
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: SUM FIELDS=NONE and ON(x,x,x) length limit

Postby jonnavarra » Fri Jun 18, 2010 8:53 pm

Richard/Alissa

Not the reply I was hoping for but thanks.

I could not find documentation on these limits, could you please send me a link I can refer the "smart" architects to and let them know they'll have to come up with a different/better strategy.

Greatly appreciated. BTW, great forum... very responsive... now a big fan!

Jon
jonnavarra
 
Posts: 4
Joined: Fri Jun 18, 2010 4:23 am
Has thanked: 0 time
Been thanked: 0 time

Re: SUM FIELDS=NONE and ON(x,x,x) length limit

Postby Alissa Margulies » Fri Jun 18, 2010 9:21 pm

The rules for specifying sort control fields can be found on page 2.201 in the SyncSort for z/OS 1.3.2 Programmer's Guide. If you need a copy of the manual, please contact me offline at alissa.margulies@syncsort.com and I would be happy to further assist you.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post