18.1.1 Total size of system log files

Organization of this subsection
(1) How to obtain the total size of system log files
(2) Determining the size of system log information

(1) How to obtain the total size of system log files

The following formula is used to obtain the total size of all system log files.

Formula
Total size of all system log files (bytes) = ([Figure]a[Figure] c[Figure][Figure] 3)*[Figure] b
a: Amount of system log information to be output
For the procedure for obtaining this value, see (2), as follows.
b: System log file record length that is specified in the pd_log_rec_leng operand
c: Use one of the following values:

pd_log_rec_leng = 1024: 1000
pd_log_rec_leng = 2048: 2000
pd_log_rec_leng = 4096: 4000

Notes
  • Because there may be unused space in system log files, it is recommended that the allocation size be at least 1.2 times the value obtained.
  • Because extension information is added when the inner replica facility is used, allocate 1.1 times the value obtained.
  • The value obtained is converted to a size per unit of time, and then an estimate is made of the size of one system log file and the number of system log files. The unload intervals for the system log files must be taken into account.
* This is the formula for obtaining the total number of system log file records.

(2) Determining the size of system log information

The following formula is used to obtain the amount of system log information that will be output.

Formula
Amount of system log information to be output (bytes) = [Figure]{b + e + [Figure]b[Figure](a - 256) [Figure][Figure]256 + d} + c
[Figure] For a recovery-unnecessary front-end server only, add:
+ f
[Figure]refers to the total for each transaction. However, if an executing transaction satisfies all the following conditions, that part will not be output to the system log:
  • The transaction is performing a retrieval, and it ends with the COMMIT statement.
  • The server that is executing the transaction is a Single Server, a dictionary server, or a back-end server.
a: Value of the pd_log_max_data_size operand
b: 1328 + amount of system log information that is output depending on the database manipulation
Note that the value is 0 for a recovery-unnecessary front-end server.
This is the total amount of system log information that is obtained for each transaction, as explained in 18.1.2 Amount of system log information output during table definition through 18.1.5 Amount of system log information output during database creation by a utility.
c: Amount of system log information that is output depending on the SQL manipulation
See 18.1.6 Amount of system log information that is output depending on the SQL manipulation.
d: Value calculated using the following formula for each server type
  • For HiRDB/Single Server
    2 [Figure] pd_log_rec_leng operand value
  • For HiRDB/Parallel Server
    [Figure]For a front-end server
    Execution of UAP using the HiRDB library to implement a connection method that supports multi-threading and complies with X/Open, and use of the transaction transfer facilityUse of recovery-unnecessary front-end serverFormula
    UsedNot used (cannot be used)([Figure]1328 [Figure] pd_log_rec_leng operand value [Figure] + 3) [Figure] pd_log_rec_leng operand value
    Not usedUsed0
    Not usedNot used2 [Figure] pd_log_rec_leng operand value
    [Figure]For a back-end server or a dictionary server
    The system includes a front-end server that uses a recovery-unnecessary front-end serverpd_rpl_reflect_mode operand specification valueFormula
    Yesuap2 [Figure] pd_log_rec_leng operand value + [Figure]128 [Figure] (all BESs + all FESs) [Figure] pd_log_rec_leng operand value [Figure][Figure] pd_log_rec_leng operand value
    server
    Nouap
    server2 [Figure] pd_log_rec_leng operand value
e:
  • For a HiRDB/Parallel Server
    For a front-end server: 56 [Figure] total number of back-end servers
    Other than a front-end server: 0
  • For a HiRDB/Single Server: 0
f: 10 [Figure] value of pd_log_rec_leng
Notes
The system log is output when any of the following operations takes place:
  • Table definition
  • Index definition
  • Table data updating
  • Database creation by a utility
If rollback occurs while the database is being updated during any of these operations, the amount of system log information applicable to the part of the database updated up to that point is added and output; this must be taken into account in estimating the size of system log information.