adding another sort container

, , , ,
1

While using the adamup utility, we received the following error message.

ADAMUP-I-SORTSIZE, Current SORT size 45 Megabytes
%ADAMUP-I-SORTSIZE, Needed SORT size 74 Megabytes (for incore sort : LWP=40292K)
%ADAMUP-F-SRTFIL, sortfile too small
%ADAMUP-I-NOCHNG, nothing changed

%ADAMUP-I-IOCNT, 2 IOs on dataset MUPDTA
%ADAMUP-I-IOCNT, 3 IOs on dataset ASSO
%ADAMUP-I-ABORTED, 1-JUN-2006 04:14:53, elapsed time: 00:00:01

I think we need to add another sort container, but I can’t find any directions on how to do this. Can somebody tell me how to add another sort container?

Thank you,
Andrea

2

No, you don’t need to “add” another SORT container, because SORT (as well as TEMP), in contrast to ASSO / DATA / WORK are “independent” containers, they are not tied to a database, only used by utilities.

So you can just format a bigger SORT1, for example using

adafrm sortsize = (80M)

or you can format multiple containers with

adafrm sortsize = (40M,40M)
3

Thank you for the quick reply. This is the message we get when we try that command.

adafrm dbid=005 sortsize=(100m)
sh: Syntax error: `(’ is not expected.

So we tried it without the parenthesis and got this message. Any suggestions.

adafrm dbid=005 sortsize=100m
%ADAFRM-I-STARTED, 1-JUN-2006 18:55:54, Version 3.2.2.19 (HP-UX 32bit)

%ADAFRM-E-MISSPAR, missing mandatory parameter ASSOSIZE
%ADAFRM-E-MISSPAR, missing mandatory parameter DATASIZE
%ADAFRM-E-MISSPAR, missing mandatory parameter WORKSIZE
%ADAFRM-I-ABORTED, 1-JUN-2006 18:55:54, elapsed time: 00:00:00

Again, thanks,
Andrea

4

Thank you for the quick reply. This is the message we get when we try that command.

adafrm dbid=005 sortsize=(100m)
sh: Syntax error: `(’ is not expected.

So we tried it without the parenthesis and got this message. Any suggestions.

adafrm dbid=005 sortsize=100m
%ADAFRM-I-STARTED, 1-JUN-2006 18:55:54, Version 3.2.2.19 (HP-UX 32bit)

%ADAFRM-E-MISSPAR, missing mandatory parameter ASSOSIZE
%ADAFRM-E-MISSPAR, missing mandatory parameter DATASIZE
%ADAFRM-E-MISSPAR, missing mandatory parameter WORKSIZE
%ADAFRM-I-ABORTED, 1-JUN-2006 18:55:54, elapsed time: 00:00:00

Again, thanks,
Andrea

5

A number of things:

  • don’t specify a DBID

  • if you want to format SORT only, don’t start adafrm, then enter the parameters, specify the entire command at once:

adafrm sortsize=80m

In that case it won’t complain about the parenthesis either,

adafrm sortsize=(80m)

will do just fine as well

6

When we run the command it adds another SORT file without the extension of the DBID. Is that correct ?

7

Whatever you decide to name it is “correct” :wink:

If you don’t export a SORTn environment variable, ADAFRM will create a container named SORTn in the CWD.

8

Thank you very much that worked !!! Appreciate your quick response !
:smiley: :smiley: :smiley: