17.4 Determining audit trail file capacity

Determine the capacity of the HiRDB file system for audit trail files using the following formulas.

Formula
HiRDB file system capacity for audit trail files (MB) = a + 19
a: Maximum amount of audit trail data (MB)
[Figure]([Figure]{b x c}) [Figure] (1,024 x 1,024)[Figure]
When an audit trail file input/output error has occurred or an audit trail file swap has been executed using the pdaudswap command, the swap occurs before the audit trail file reaches capacity. In this case, the free space cannot be used until registration of data to the audit trail table terminates. For this reason, we recommend doubling the value of a in advance.
b: Audit trail record size (bytes)
Find the audit trail record size using the following formula.
464 + d + e + f + g + h + i
c: Number of audit trail records
This is the number of records recorded by audit trail event type.
d: Length of SQL statement output to the audit trail record (bytes)
If the value of pd_aud_sql_source_size is 0 or is not specified: 0
If there is no SQL statement in the record item: 0
If there is a SQL statement in the record item, but the SQL statement is NULL: 0
In other cases:
[Figure]Min (value of pd_aud_sql_source_size, average SQL statement length) [Figure] 4[Figure] x 4 + 8
e: Length of SQL data output to audit trail record (bytes)
If the pd_aud_sql_data_size value is 0 or is not specified: 0
If there is no SQL data in the record item: 0
If there is SQL data in the record item, but the SQL data is NULL: 0
In other cases:
[Figure]Min (value of pd_aud_sql_data_size, average length of SQL data) [Figure] 4[Figure] x 4 + 8
f, g, h: Length of additional user information 1, 2 and 3 output to audit trail record (bytes)
If there is no additional user information in the record item or if that information is NULL: 0
In other cases:
[Figure]average length of additional user information [Figure] 4[Figure] x 4 + 8
i: Length of additional related product information output to audit trail record (bytes)
If there is no additional related product information in the record item or if that additional related product information is NULL#1: 0
In other cases:
[Figure]average length of additional related product information#2[Figure] 4[Figure] x 4 + 8
#1
For details about conditions when additional related product information is NULL, see the relevant product documentation.
#2
For details about average length of additional related product information, see the relevant product documentation. If you find no pertinent information in that documentation, calculate the maximum length of additional related product information.

For details about the audit trail record length and information output to the audit trail file, see the HiRDB Version 9 System Operation Guide.