18.1.10 Amount of system log information that is output during execution of the facility for predicting reorganization time

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 (or that is output by the single server for a HiRDB/Single Server):

Formula
Amount of system log information (bytes) =
n[Figure] {1604 [Figure] (A + B + C + D) [Figure] ([Figure]E[Figure] + 1)}
+ m[Figure] {872 [Figure] (a + b + c + 1)}
+ 11680 [Figure][Figure]{(A + B + C + D) [Figure] ([Figure]E[Figure] + 1)} [Figure] 30 [Figure] 540[Figure]
+ 332 [Figure] {(A + B + C + D) [Figure] ([Figure]E[Figure] + 1)} [Figure] 30
+ 7760
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 manual HiRDB Version 8 System Operation Guide.