Use the LOGSIZE configuration parameter to set the size of the logical-log files. It is difficult to predict how much logical-log space your database server system requires until it is fully in use.
The easiest way to increase the amount of space for the logical log is to add another logical-log file. See Adding Logical-Log Files Manually.
The following expression provides the recommended minimum total-log-space configuration, in kilobytes:
LOGSIZE = (((connections * maxrows) * rowsize) / 1024) / LOGFILES
| Expression Element | Explanation |
|---|---|
| LOGSIZE | Specifies the size of each logical-log file in kilobytes. |
| connections | Specifies the maximum number of connections for all network types that you specify in the sqlhosts file or registry and in the NETTYPE parameter. If you configured more than one connection by setting multiple NETTYPE configuration parameters in your configuration file, sum the users fields for each NETTYPE, and substitute this total for connections in the preceding formula. |
| maxrows | Specifies the largest number of rows to be updated in a single transaction. |
| rowsize | Specifies the average size of a table row in bytes. To calculate the rowsize, add up the length (from the syscolumns system catalog table) of the columns in the row. |
| 1024 | Converts the LOGSIZE to units of kilobytes. |
| LOGFILES | Specifies the number of logical-log files. |