Using a Text Editor to Change Physical-Log Location or Size

You can change the physical-log location and size by editing the ONCONFIG file while the database server is in online mode.

Parameter

Description

PHYSFILE

Specifies the size of the physical log file in kilobytes

PHYSDBS

Moves the physical log to the specified dbspace

PHYSSLICE

Moves the physical log to the specified dbspace or dbslice on each coserver

The changes do not take effect until you shut down and restart the database server. Then, create a level-0 backup immediately to ensure that all recovery mechanisms are available.

For information on PHYSSLICE, PHYSFILE, and PHYSDBS, see the chapter on configuration parameters in the IBM Informix: Administrator's Reference.