If you use the facility for predicting reorganization time, you must add the amount of log information obtained from the following formula to the amount of log information that is output by the dictionary server for a HiRDB parallel server configuration (or that is output by the single server for a HiRDB single server configuration):

Formula

Amount of system log information (bytes) = n {1,604 (A + B + C + D) (E + 1)} + m {872 (a + b + c + 1)} + 11,680 {(A + B + C + D) (E + 1)} 30 540 + 332 {(A + B + C + D) (E + 1)} 30 + 7,760

A: Number of tables that have been created + 61

B: Number of indexes that have been created + 124

C: Total number of BLOB columns defined for the tables that have been created + 3

D: Total number of BLOB attributes defined for the tables that have been created

E: Average number of partitions in the table storage RDAREA

If the RDAREA is not partitioned, the value is 1. The average value is rounded up.

a: Number of RDAREAs storing tables processed by SQL statements or commands

b: Number of RDAREAs storing indexes processed by SQL statements or commands

c: Number of LOB RDAREAs storing tables processed by SQL statements or commands

n: Number of times the condition analysis result accumulation facility (pddbst -k logi -e) executed

m: Number of SQL statements or commands executed to update the database management table

For details about the SQL statements and commands for updating the database management table, see the HiRDB Version 9 System Operation Guide.