Using onparams to Change Physical-Log Location or Size

To change the size and location of the physical log, execute the following command after you bring the database server to quiescent or single-user mode:

onparams -p -s size -d dbspace -y

size

is the new size of the physical log in kilobytes

dbspace

specifies the dbspace where the physical log is to reside

The following example changes the size and location of the physical log. The new physical-log size is 400 kilobytes, and the log will reside in the dbspace6 dbspace:

onparams -p -s 400 -d dbspace6 -y

The command shown above, with the -y option, changes the value of the parameter in shared memory so that the change takes effect immediately.

After you shut down and restart the database server, create a level-0 backup to ensure that all recovery mechanisms are available.

For information on using the onparams utility to modify the physical log, see the IBM Informix Administrator's Reference.