When you execute the following utilities, the system outputs the system log information shown in Table 17-14 Formulas for determining the amount of system log information output during database creation by a utility.

• Database load utility (pdload command)
• Database reorganization utility (pdrorg command)
• Rebalancing facility (pdrbal command)

The system log size is calculated by adding the value shown in Table 17-15 Values added when calculating the amount of system log information, and conditions required to perform this addition to the value obtained in Table 17-14 Formulas for determining the amount of system log information output during database creation by a utility. For row-partitioned tables and indexes, the amount of system log information is calculated for each RDAREA in which tables and indexes are stored.

• For a HiRDB single server configuration:
  Add the total amount of system log information calculated for each RDAREA to the amount of log information output by a single server.
  
• For a HiRDB parallel server configuration:
  Add the total amount of system log information calculated for each RDAREA to the amount of log information of the back-end server that manages the tables and indexes to be processed. If you reorganize dictionary tables with the database reorganization utility (pdrorg), however, add the amount of log information output by the dictionary server.
  

  Table 17-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 specified in -i option)	n { i=1 [132 + (100 - f) 100 Xi] Wi + 280 Wi + 1,940 Wi Vi } + 280 m + 1,940 m s + a r	n { i=1 280 Wi + 1,940 Wi Vi } + 280 m + 1,940 m s + c r
  2	Batch index creation not performed (s specified in -i option)	n { i=1 280 Wi + 1,940 Wi Vi + b r + e d } + 280 m + 1,940 m s + a r	n { i=1 280 Wi + 1,940 Wi Vi + b r + e d } + 280 m + 1,940 m s + c r
  3	No index is created (n or x is specified in the -i option)	280 m + 1,940 s + a r	280 m + 1,940 m s + c r
  4	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: 17.1.3 Amount of system log information output during index definition Table 17-12 Amount of log information for page allocation and segment allocation Table 17-17 Amount of system log information output during execution of the PURGE TABLE statement	Add the following amount to the system log: Table 17-12 Amount of log information for page allocation and segment allocation Table 17-17 Amount of system log information output during execution of the PURGE TABLE statement

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 Table 17-3 Formulas for determining the amount of base row log information per data item and Table 17-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 17-10 Amount of index log information per index.

c: Amount of log information output when one data item is added, as obtained from 17-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 Table 17-11 Amount of index log information by split type and Table 17-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 16.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)

V_i: Segment size of user RDAREA used to store index (pages)

W_i: Number of index storage pages

See 16.1.3 Calculating the number of index storage pages.

X_i: Page length of user RDAREA used to store index (bytes).

For items 1 and 2 in Table 17-14 Formulas for determining the amount of system log information output during database creation by a utility, 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 17-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 the number of rows): See Data addition (INSERT statement) in Table 17-4 Formulas for determining the amount of log information per BLOB column data item When the recovery attribute of the LOB column is not recovery no 3,544 (LOB data length 31,744) (bytes)
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 17-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: {17,000 (the number of HiRDB file segments 64,000) 95}
	Add the following amount of log information for each item (the number of LOB columns or LOB attributes the number of rows). LOB column is recovery all specification and also -l a specification 17,600 sr sr Other than the above 3,200 sr 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 columns	Add the log information shown in Table 17-13 Amount of event log information that is output when a single row is manipulated for each added row.