6.12.13 Determining the size of the user logs that are output during execution of the adbreorgsystemdata command (variable max_user_log)
The size of the user log data that is output when the adbreorgsystemdata command is executed is the same as the size of user log data that is output in the following case:
-
When the adbimport command is executed with the -d option specified for a multi-chunk table
Determine the size of the user logs that are output during the execution of the adbimport command according to the explanation in 6.12.4 Determining the size of the user logs that are output during execution of the adbimport command (variable max_user_log). When determining the size of user log data (variable max_user_log), substitute the following values for the variables:
- IMPSTBLLOG
-
Substitute 0.
- IMPRNGIDXLOG
-
Substitute 0.
- IMPTIXLOG
-
Substitute 0.
- dbarea_file_num
-
Substitute 1.
- dbarea_file_num(i)
-
Substitute 1.
- SGTBL
-
Execute the adbdbstatus command for the reorganization-target system table (base table) to output the summary information about tables. Then, substitute the value of the output item Used_segments.
The following shows an example of executing the adbdbstatus command when the table STATUS_CHUNKS is to be reorganized:
Example:
adbdbstatus -d summary -c table -n HADB.STATUS_CHUNKS
- SEGBF
-
Substitute 56.
- SEGBF(i)
-
Substitute 56.
- page_size
-
Substitute 4,096.
- page_size(i)
-
Substitute 4,096.
- pctfree
-
Substitute 0.
The variable pctfree is used to determine the values of the following variables, which are used to solve the formula in 6.12.4 Determining the size of the user logs that are output during execution of the adbimport command (variable max_user_log):
-
Variable IP_LOWER(i) in (1) Determining the number of storage pages used in the lower page segment (variable IP_LOWER(i)) under 5.8.3 Determining the number of storage pages for each B-tree index segment
-
Variable IP_UPPER(i) in (2) Determining the number of storage pages used in the upper page segment (variable IP_UPPER(i)) under 5.8.3 Determining the number of storage pages for each B-tree index segment
-
- usrlog_file_num
-
Substitute the following value.
number-of-user-log-files-required-during-execution-of-the-adbreorgsystemdata-command - 1
For details about the number of user log files required during execution of the adbreorgsystemdata command, see (2) Commands for which the number of user log files needs to be estimated in 6.12.15 Determining the number of user log files.
- idx_num
-
Substitute the number of indexed that are defined for the system table (base table) to be reorganized.
For details about the number of indexes defined for the system table (base table) to be reorganized, see C.8 B-tree indexes of system tables (base tables).
- SGIDX(i)
-
Execute the adbdbstatus command for the indexes that are defined for the reorganization-target system table (base table) to output the summary information about indexes. Then, substitute the value of the output item Used_segments.
Note that you must execute the adbdbstatus command for each of the defined indexes.
For details about the indexes defined for the system table (base table) to be reorganized, see C.8 B-tree indexes of system tables (base tables).
The following shows an example of executing the adbdbstatus command when an index (STATUSINDEXM05) of the table STATUS_CHUNKS is to be reorganized.
Example:
adbdbstatus -d summary -c index -n HADB.STATUSINDEXM05
- SEGDATA
-
Substitute the value of SGTBL.
- imp_load_rthd
-
Substitute 1.
- imp_dividx_rthd
-
Substitute 1.