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

Use the following formula to determine the size of the user logs that are output during execution of the adbchgchunkstatus command.

Formula (bytes)

Size of user logs output during execution of adbchgchunkstatus command =
          TBLCHKSTATLOG + IDXCHKSTATLOG + 5,760,360 × (1 + idx_num)

Explanation of the variables

idx_num

Number of indexes defined for the base table in the chunk whose status is to be changed

TBLCHKSTATLOG

Size of logs for a base table in a chunk whose status is to be changed.

Use the following formula to determine its value.

Formula (bytes)

• dbarea_file_num

  Number of DB area files in data DB area that stores the base table

• change_chunk_num

  Number of chunks whose status is to be changed

• page_size

  Page size of the data DB area that stores the base table (bytes)

IDXCHKSTATLOG

Log size for the indexes defined for a base table in a chunk whose status is to be changed.

Use the following formula to determine its value.

Formula (bytes)

• idx_num

  Number of indexes defined for the base table in the chunk whose status is to be changed

• dbarea_file_num₍i₎

  Number of DB area files in the data DB areas that store the indexes

• change_chunk_num

  Number of chunks whose status is to be changed

• page_size₍i₎

  Page size in the data DB area of each index (bytes)

To Page Top