Turning Residency On or Off in On-Line Mode

To turn residency on or off while the database server is in online mode, use the onutil SET command.

To turn on residency immediately for the resident portion of shared memory, execute the following command:

% onutil SET RESIDENT 1

To turn off residency immediately for the resident portion of shared memory, execute the following command:

% onutil SET RESIDENT 0

These commands do not change the value of the RESIDENT parameter in the ONCONFIG file. That is, this change is not permanent, and residency reverts to the state specified by the RESIDENT parameter the next time that you initialize shared memory. To make the change permanent, add the PERSISTENT keyword:

% onutil SET RESIDENT 1 PERSISTENT

You cannot use the onutil SET command to turn residency on or off unless the RESIDENT parameter is set in your ONCONFIG file when you initialize the database server memory.

On UNIX, you must be root or user informix to turn residency on or off. On Windows NT, you must be a user in the Informix Admin group to turn residency on or off.