sort with more than 2500 sort conditions

[shivkumar]

i have a problem while sorting with Syncsort utility, that main scenario is i m using VB file and my sort card have more that 2000.

I got an error as:

CND1CNTL :
SORT FIELDS=COPY
WER428I CALLER-PROVIDED IDENTIFIER IS "0001"
WER002A EXCESS CARDS
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE

[shivkumar]

Can i use Syncsort utility for sort operation having more than 2500 sort conditions ?

If yes , please paste syntax.

thanks in advance

[William Thompson]

i have a problem while sorting with ICETOOL utility, that main scenario is i m using VB file and my sort card have more that 2000.

I got an error as:

CND1CNTL :
SORT FIELDS=COPY
WER428I CALLER-PROVIDED IDENTIFIER IS "0001"
WER002A EXCESS CARDS
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE

Have you checked your Syncsort manual for the max number you can use?
What kind of conditions are you using? 2000 conditions on one field or a few conditions on 2000 fields?
Please post an example of your conditions....

[CICS Guy]

WER002A EXCESS CARDS

WER002A EXCESS CARDS
EXPLANATION: The static internal storage area is inadequate for the quantity and/or complexity of the control statements in this application. Either the minimum storage value set at installation time is too low, or insufficient storage is available in your region.
ACTION: Ask the systems programmer in charge of SyncSort installation to increase the minimum storage (MINCORE) value unless the storage available in the region is less than the minimum storage value. In that case, increase the storage available in the region or partition so that it at least equals the minimum storage value.

[dick scherrer]

Hello,

As has already been requested, post your requirements.

I suggest that if there is that much qualification going on there are better ways to meet your requirement than using 2500+ sort control statements.

Once we see what you are actually trying to accomplish, we may be able to offer some alternative.

[shivkumar]

I m using ICETOOL utility ,,,and for ur info..please see below code..
I m looking into it ,,,but always geeting user code 16 .

//TOOL EXEC PGM=ICETOOL,PARM='MINLIM=1M',REGION=2M
//**STEP EXEC PGM=SORT,REGION=1M
//DFSMSG DD SYSOUT=*
//TOOLMSG DD SYSOUT=*
//SORTWK01 DD UNIT=D,SPACE=(CYL,(100,50),RLSE)
//SORTWK02 DD UNIT=D,SPACE=(CYL,(100,50),RLSE)
//SORTWK03 DD UNIT=D,SPACE=(CYL,(100,50),RLSE)
//SORTWK04 DD UNIT=D,SPACE=(CYL,(100,50),RLSE)
//SORTWK05 DD UNIT=D,SPACE=(CYL,(100,50),RLSE)
//SORTIN DD DSN=PIL0.UI0504B0(0),DISP=SHR
//SORTOUT DD DSN=@LIQ2UZ.SORT2.OUT,DISP=(NEW,CATLG,DELETE),
// UNIT=D,SPACE=(CYL,(750,400),RLSE),
// DCB=(RECFM=VB,BLKSIZE=35045)
//SYSIN DD *
//TOOLIN DD *
//SYSIN DD *
//TOOLIN DD *
SORT FROM(SORTIN) TO(SORTOUT) USING(CND1)
/*
//CND1CNTL DD *
SORT FIELDS=COPY
INCLUDE COND=(25,12,CH,EQ,C'000LH0012420',OR,
25,12,CH,EQ,C'000LH0100691',OR,
25,12,CH,EQ,C'000LH0252274',OR,
25,12,CH,EQ,C'000LH0254739',OR,
25,12,CH,EQ,C'000LH0254769',OR,
25,12,CH,EQ,C'000LH0260369',OR,
25,12,CH,EQ,C'000LH0261605',OR,
25,12,CH,EQ,C'000LH0261669',OR,
25,12,CH,EQ,C'000LH0274868',OR,
25,12,CH,EQ,C'000LH0276483',OR,
25,12,CH,EQ,C'000LH0287683',OR,
25,12,CH,EQ,C'000L01268855',OR,
.....
..... these condtions having 2500 records.
.....
/*
//

[CICS Guy]

I m using ICETOOL utility ,,,and for ur info..please see below code..
I m looking into it ,,,but always geeting user code 16 .

Have you found what the MINCORE value is?
Have you looked int reducing the number of cards? The error in not too many conditions, it is too many cards......
How many of the leading characters of "C'000L0...' are the same for all?
How were the conditions generated? Could they be generated with more per record? You could use the reporting feature of Syncsort to combine multiple conditions per record.....

[shivkumar]

Have you found what the MINCORE value is?
Have you looked int reducing the number of cards? The error in not too many conditions, it is too many cards......
How many of the leading characters of "C'000L0...' are the same for all?
How were the conditions generated? Could they be generated with more per record? You could use the reporting feature of Syncsort to combine multiple conditions per record.....

1 st. Nope i didnt found any MINCORE value
2.nd. I was tried with redusing cards, and it was nicely working with upto 350 cards,
but as per i know DFHSORT can work with so many condition cards (no limit)
3 rd. yes , same for all
4 th. conditions generated with according to records present in file.

i was tried on that but not getting MAXCC=0 ..

some one can please look into it ...

[CICS Guy]

1 st. Nope i didnt found any MINCORE value

That may be your greatest need.....

2.nd. I was tried with redusing cards, and it was nicely working with upto 350 cards,
but as per i know DFHSORT can work with so many condition cards (no limit)

The error implies it is a space condition that is relievable through increasing MINCORE

3 rd. yes , same for all

Find the part(s) that are identical for all (most) records and use that part once with an AND.....

some one can please look into it ...

I'm afraid that the ball is in your court...Like the manual said:

ACTION: Ask the systems programmer in charge of SyncSort installation to increase the minimum storage (MINCORE) value...

[Alissa Margulies]

There is no numerical limit to the number of comparisons that can be in an Include or OMIT statement. The limitation is based upon your system resources, specifically MINCORE. (Mincore is a subset of your below the line resources.)

You can pass a MINCORE value as a runtime parameter. With over 2000 conditions, I recommended passing MINCORE=512K and increase in 256K increments if necessary. If you are still having a problem after 1.5M, please let me know.