18.1.5 Amount of system log information output during database creation by a utility

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.

Note:
The amount of system log information when indexes are created in batch or singularly needs to be calculated for the number of indexes.
a: Amount of log information output when one data item is added, as obtained from Tables 18-3 Formulas for determining the amount of base row log information per data item and 18-4 Formulas for determining the amount of log information per BLOB column data item.
b: Amount of log information output when one data item is added, as obtained from Table 18-10 Amount of index log information per index.
c: Amount of log information output when one data item is added, as obtained from Table 18-4 Formulas for determining the amount of log information per BLOB column data item.
d: Amount of system log information output during index splitting
See Tables 18-11 Amount of index log information by split type and 18-12 Amount of log information for page allocation and segment allocation.
e: Number of times index splitting occurs
f: Value (%) of the PCTFREE operand specified during index definition (percentage of unused space in a page)
m: Number of table storage pages
See 17.1.2 Calculating the number of table storage pages.
n: Total number of indexes defined for table
r: Number of rows to be stored in table (rows)
s: Segment size of user RDAREA used to store table (pages)
Vi: Segment size of user RDAREA used to store index (pages)
Wi: Number of index storage pages
See 17.1.3 Calculating the number of index storage pages.
Xi: Page length of user RDAREA used to store index (bytes).

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 additionValues added to the amount of system log information
When LOB columns are definedAdd the following amount of log information for (the number of LOB columns [Figure] the number of rows):
When the database load utility (pdload) is executed with the -d option specified, or the database reorganization utility (pdrorg) is executedAdd 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:
  • The table is reorganized without the -j option specified
  • The LOB column does not specify recovery no and n is not specified for the -l option
Add the following log amount of information for each LOB RDAREA configuration file:
[Figure]{17000 [Figure][Figure] (the number of HiRDB file segments [Figure] 64000) [Figure][Figure] 95}
Add the following amount of log information for each item (the number of LOB columns or LOB attributes [Figure] the number of rows).
[Figure]LOB column is recovery all specification and also -l a specification
[Figure]17600 [Figure] sr[Figure][Figure] sr
[Figure] Other than the above
[Figure]3200 [Figure] sr[Figure][Figure] sr
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 columnsAdd 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.