Estimating logical-log size when logging dbspaces

To estimate the size of logical logs, use a formula or onstat -u information.

Use the following formula to obtain an initial estimate for LOGSIZE in kilobytes:
LOGSIZE = (connections * maxrows * rowsize) / 1024) / LOGFILES 

In this formula:

To obtain a better estimate during peak activity periods, execute the onstat -u command. The last line of the onstat -u output contains the maximum number of concurrent connections.

You need to adjust the size of the logical log when your transactions include simple large objects or smart large objects, as the following sections describe.

You also can increase the amount of space devoted to the logical log by adding another logical-log file.

Copyright© 2018 HCL Technologies Limited