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 to 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, you should mirror the dbspace that contains the physical log.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]