6.12.11 Determining the size of the user logs that are output during execution of the adbarchivechunk command (variable max_user_log)

(1) Determining the variable TBLARCCHKLOG

Use the following formula to determine the value of variable TBLARCCHKLOG.

Formula (bytes)

Explanation of variables

dbarea_file_num

Number of data DB area files for the data DB area that stores the archivable multi-chunk table

SGCHTBL

Number of segments that are used by the archivable multi-chunk table in the chunk to be processed by the adbarchivechunk command

SEGBF

Segment block factor of the data DB area that stores the archivable multi-chunk table

page_size

Page size of the data DB area that stores the archivable multi-chunk table (bytes)

usrlog_file_num

Use the following formula to determine this value.

For details about the number of segments in a data DB area and the segment block factors, see (2) Explanation of variables in 5.8.1 Determining the total number of pages in the data DB area.

For details about the number of user log files required during execution of the adbarchivechunk 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.

To Page Top

(2) Determining the variable IDXARCCHKLOG

Use the following formula to determine the value of variable IDXARCCHKLOG.

Formula (bytes)

Explanation of variables

idx_num

Number of indexes that are defined for the archivable multi-chunk table for which the adbarchivechunk command is executed

dbarea_file_num(i)

Number of data DB area files for the data DB area that contains the indexes

SGCHIDX(i)

Number of segments used by the indexes defined for the archivable multi-chunk table in the chunks to be processed by the adbarchivechunk command

SEGBF(i)

Segment block factor of the data DB area that stores the indexes defined for the archivable multi-chunk table

page_size(i)

Page size of the data DB area that stores the indexes defined for the archivable multi-chunk table (bytes)

usrlog_file_num

Use the following formula to determine this value.

For details about the number of segments in a data DB area and the segment block factors, see (2) Explanation of variables in 5.8.1 Determining the total number of pages in the data DB area.

For details about the number of user log files required during execution of the adbarchivechunk 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.

To Page Top

(3) Determining the variable STBLUPDLOG

Substitute the following value for the variable STBLUPDLOG.

Value (bytes)

To Page Top

(4) Determining the variable ARCCHKLOCLOG

Use the following formula to determine the value of variable ARCCHKLOCLOG.

Formula (bytes)

Explanation of variables

INSLOG

Determine the value from the formula in Size of user logs that are output when an INSERT statement is executed in 6.12.7 Determining the size of the user logs that are output during database updating (variable max_user_log). Note that for some of the variables in the formula, you must substitute values that are different from the values indicated in the preceding section. The following shows the relevant variables and the values to be substituted.

VRWLOG

Substitute 0.

TIXSLOG

Substitute 0.

IDXSLOG

To determine the value of the variable IDXSLOG, see (3) Determining the size of the B-tree index user log in 6.12.7 Determining the size of the user logs that are output during database updating (variable max_user_log). Note that for some of the variables in the formula, you must substitute values that are different from the values indicated in the preceding section. The following shows the relevant variables and the values to be substituted.

• idx_num

  Substitute 1.

• IDXLOG(i)

  Use the following formula to determine this value.

  Formula

• SPLITLOG(i)

  Determine this value according to Formula (when the number of duplicate index keys in the update-target rows is 256 or more) in the description of the SPLITLOG₍i₎ variable in (3) Determining the size of the B-tree index user log under 6.12.7 Determining the size of the user logs that are output during database updating (variable max_user_log).

LROWNUM

Number of archive files created by the adbarchivechunk command

Use the formula for the variable LROWNUM in (f) Determining the variable SGROWTBL (for a multi-chunk table) under (2) Explanation of variables in 5.8.1 Determining the total number of pages in the data DB area. Note that for some of the variables in the formula, you must substitute values that are different from the values indicated in the preceding section. The following shows the relevant variables and the values to be substituted.

• archive_chunk_num

  Substitute 1.

• merge_chunk_num

  Substitute 0.

ins_row_num

Substitute the same value as the variable LROWNUM determined before.

SGMTLOG

Use the following formula to determine this value.

Formula

LBP

Use the formula for the variable LBP(i) in (f) Determining the variable SGROWTBL (for a multi-chunk table) under (2) Explanation of variables in 5.8.1 Determining the total number of pages in the data DB area. Note that for some of the variables in the formula, you must substitute values that are different from the values indicated in the preceding section. The following shows the relevant variables and the values to be substituted.

• LROWNUM

  Substitute the same value as the variable LROWNUM determined before.

SEGSIZE

Segment size of the data DB area that stores the archivable multi-chunk table

Use the following formula to determine this value.

Formula (pages)

page_size

Page size of the data DB area that stores the archivable multi-chunk table (bytes)

To Page Top