Location of the Physical Log

When the database server initializes disk space, it places the logical-log files and the physical log in the root dbspace. You have no initial control over this placement. To improve performance (specifically, to reduce the number of writes to the root dbspace and minimize disk contention), you can move the physical log out of the root dbspace to another dbspace, preferably on a disk that does not contain active tables or the logical-log files.

The physical log is located in the dbspace specified by the ONCONFIG parameter PHYSDBS. (For information on PHYSDBS, see the chapter on configuration parameters in the IBM Informix: Administrator's Reference.) Change PHYSDBS only if you decide to move the physical-log file from the root dbspace. (See Changing the Physical-Log Location and Size.)

Because the physical log is critical, It is recommended that you mirror the dbspace that contains the physical log.