Allocate logical log files
When you initialize or restart the database server, it creates the number of logical-log files that are specified by the LOGFILES configuration parameter. The size of the logical log files is specified by the LOGSIZE configuration parameter.
You can manually add logical log files or configure the database server to add logical log files as needed. The database server updates the value of the LOGFILES configuration parameter dynamically when logical log files are added.
The following configuration parameters also affect logical log files. You can update the value of these configuration parameters while the server is running, unless otherwise noted.
- AUTO_LLOG
- Automatically adds logical logs to improve performance and limits the total size of logical log files.
- DYNAMIC_LOGS
- Automatically adds logical logs to prevent transaction blocking.
- LOGBUFF
- Sets the size of the three logical-log buffers in shared memory. You must restart the database server when you change the value of the LOGBUFF configuration parameter.
- LTXEHWM
- Sets the percentage of available log space that, when filled, triggers the database server to give the long transaction currently that is being rolled back exclusive access to the logical log.
- LTXHWM
- Sets the percentage of available log space that, when filled, triggers the database server to check for a long transaction.