Does update on config file require restart?

[milts]

Hi,

We have been hitting the sort execution failure recently on our batch jobs. memsize in sasv9_usermods.cfg was already set .

Appreciate if someone confirm that if we apply changes to the sasv9_usermods.cfg file to adjust sortsize, do we need to restart our SAS servers or it will automatically be in effect on our next batch run?

The config file I'm pertaining to is the one which usually sits in the SAS/Config/Lev1 foldfsor

Thanks!

[SASKiwi]

As I understand it batch jobs run in their own SAS session and not via any SAS services. As long as your batch job is run in the Lev1 environment, say for example using the LSF scheduler in Management Console then it should pick up your config.

You can confirm if your settings are working or not by running PROC OPTIONS in a batch job.

[Ksharp · Accepted solution]

You can use " proc sort SORTSIZE=max "  to overwrite system's option sortsize, no need to reboot your server.

And what is your ERROR info when you running proc sort ? Maybe it is not problem from memory's size  .

Xia Keshan

[milts]

Thanks I forgot it can sortsize can be overridden in the option statement as well. Apparently I am still having some sort execution failure even with 4G set on sortsize.

[Ksharp]

If your table was really big big , proc sort can't handle it . I suggest the following code to sort :

data F M;

set sashelp.class;

select;

when(sex='F') output F;

when(sex='M') output M;

otherwise;

end;

run;

AND APPEND THEM ALL TOGETHER:

proc append base=want data=F force;run;

proc append base=want data=M force;run;

Xia Keshan