When the maximum size of the logical log files is reached, logical log files are no longer added to improve performance. However, if the DYNAMIC_LOGS configuration parameter is enabled, logical logs are added to prevent transaction blocking.
When the maximum size of the logical log files is reached, logical log files are no longer added to improve performance. However, if the DYNAMIC_LOGS configuration parameter is enabled, logical logs are added to prevent transaction blocking.
The settings of the DYNAMIC_LOGS and the AUTO_LLOG configuration parameters do not interact.
If the value of the max_size field is larger than the size of the specified dbspace, enable automatic expansion of storage spaces.
In the message log file:
In the message log file:
Thru the onstat –m command line utility:
You may see unusual numbers of logical logs have been added.