When you execute the following utilities, the system outputs the system log information shown in Table 18-14.
The system log size is calculated by adding the value shown in Table 18-15 to the value obtained in Table 18-14. For row partitioned tables and indexes, the amount of system log information is calculated for each RDAREA in which tables and indexes are stored.
Table 18-14 Formulas for determining the amount of system log information output during database creation by a utility
Number | Condition | Amount of system log information output (bytes) | |
---|---|---|---|
a specified in -l option | p specified in -l option | ||
1 | Batch index creation performed (c or n specified in -i option) | n![]() i=1 [132 + ![]() ![]() ![]() ![]() ![]() + 280 ![]() ![]() ![]() ![]() ![]() } + 280 ![]() ![]() ![]() ![]() ![]() ![]() | n![]() i=1 280 ![]() ![]() ![]() ![]() ![]() } + 280 ![]() ![]() ![]() ![]() ![]() ![]() |
2 | Batch index creation not performed (s specified in -i option) | n![]() i=1 280 ![]() ![]() ![]() ![]() ![]() + b ![]() ![]() } + 280 ![]() ![]() ![]() ![]() ![]() ![]() | n![]() i=1 280 ![]() ![]() ![]() ![]() ![]() + b ![]() ![]() } + 280 ![]() ![]() ![]() ![]() ![]() ![]() |
3 | Index creation or regeneration performed (nothing loaded with pdload, or ixrc or ixor specified in pdrorg -k option) | Add the following amount to the system log: | Add the following amount to the system log: |
For items 1 and 2 in Table 18-14, the following table lists the values that are added when calculating the amount of system log information, and the conditions required to perform this addition.
Table 18-15 Values added when calculating the amount of system log information, and conditions required to perform this addition
Conditions for addition | Values added to the amount of system log information |
---|---|
When LOB columns are defined | Add the following amount of log information for (the number of LOB columns ![]()
|
When the database load utility (pdload) is executed with the -d option specified, or the database reorganization utility (pdrorg) is executed | Add the amount of log information of all indexes and all LOB columns (or LOB attributes) defined in Tables or Rebalancing tables in Table 18-17 Amount of system log information output during execution of the PURGE TABLE statement and target tables. |
When a table having a LOB column or LOB attribute is reorganized using the database reorganization utility (pdrorg), if the following two conditions are met:
| Add the following log amount of information for each LOB RDAREA configuration file:![]() ![]() ![]() ![]() ![]() ![]() |
Add the following amount of log information for each item (the number of LOB columns or LOB attributes ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() sr: Record length of the system log file specified in the pd_log_rec_leng operand. | |
The HiRDB Datareplicator linkage facility is used (the pd_rpl_hdepath operand is specified) and the table contains repetition columns | Add the log information shown in Table 18-13 Amount of event log information that is output when a single row is manipulated for each added row. |