topic Re: Does update on config file require restart? in Administration and Deployment

Does update on config file require restart?

milts — Mon, 20 Jul 2015 06:10:57 GMT

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!

Re: Does update on config file require restart?

SASKiwi — Mon, 20 Jul 2015 07:42:25 GMT

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.

Re: Does update on config file require restart?

Ksharp — Mon, 20 Jul 2015 12:02:54 GMT

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

Re: Does update on config file require restart?

milts — Tue, 28 Jul 2015 09:02:31 GMT

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.

Re: Does update on config file require restart?

Ksharp — Tue, 28 Jul 2015 11:47:33 GMT

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