Architecting, installing and maintaining your SAS environment

Does update on config file require restart?

Accepted Solution Solved
Reply
Super Contributor
Posts: 318
Accepted Solution

Does update on config file require restart?

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!


Accepted Solutions
Solution
‎07-20-2015 08:02 AM
Super User
Posts: 9,681

Re: Does update on config file require restart?

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

View solution in original post


All Replies
Super User
Posts: 3,108

Re: Does update on config file require restart?

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.

Solution
‎07-20-2015 08:02 AM
Super User
Posts: 9,681

Re: Does update on config file require restart?

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

Super Contributor
Posts: 318

Re: Does update on config file require restart?

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.

Super User
Posts: 9,681

Re: Does update on config file require restart?

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 512 views
  • 4 likes
  • 3 in conversation