Changing the Physical-Log Location and Size

You can change your physical-log location or size in several ways:

• Using a text editor or ISA to edit the ONCONFIG file
• Using the onparams utility from the command line
• Using ON–Monitor

Log in as user informix or root on UNIX or as a member of the Informix-Admin group on Windows when you make the changes. The following sections describe each of these methods.

To activate the changes to the size or location of the physical log as soon as you make them, shut down and restart the database server. The onparams utility automatically shuts down and restarts the database server.

Create a level-0 backup immediately after you restart the database server. This storage-space backup is critical for database server recovery.

You can move the physical-log file to try to improve performance. When the database server initializes disk space, it places the disk pages allocated for the logical log and the physical log in the root dbspace. You might improve performance by moving the physical log, the logical-log files, or both to other dbspaces.

For advice on where to place the physical log, see Specifying the Location of the Physical Log. For advice on sizing the physical log, see Size and Location of the Physical Log. To obtain information about the physical log, see Monitoring Physical and Logical-Logging Activity.