PHYSFILE configuration parameter

Use the PHYSFILE configuration parameter to specify the size of the physical log file when you first initialize the disk space and bring the database server online.

onconfig.std value
PHYSFILE 50000
if not present
200
values
An integer 200 or greater
units
KB
takes effect
After you edit the onconfig file and initialize disk space by running the oninit -i command.
After you run the onparams -p -s command.

Usage

You cannot change the value of the PHYSFILE configuration parameter by editing the onconfig file after you start the server for the first time.

The database server updates the value of the PHYSFILE configuration parameter in the onconfig file under the following circumstances:
  • You change the size of the physical log file by running the onparams -p -s command.
  • The plogspace is automatically expanded. If the physical log is stored in a plogspace, the database server expands the size of the physical log as needed to improve performance.

The database server updates the value of the PHYSFILE configuration parameter in the onconfig file when you change the size of the physical log file by running the onparams -p -s command.

When the RTO_SERVER_RESTART configuration parameter is enabled, ensure that the size of the physical log is equal to at least 110% of the buffer pool size. A warning message prints to the message log when:
  • The value for the PHYSFILE configuration parameter is changed to less than 110% of all of the buffer pools
  • The server is restarted
  • A new buffer pool is added