Hitachi

Hitachi Advanced Database Setup and Operation Guide

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

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

Formula (bytes)

[Figure]
Explanation of variables
Organization of this subsection

(1) Determining the variable TBLPRGLOG

Use the formula below to determine the value of variable TBLPRGLOG.

Note that in the following cases, you do not need to estimate the value of this variable. Substitute 0 for TBLPRGLOG.

Formula (bytes)

[Figure]

Explanation of variables

dbarea_file_num

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

SGTBL

Number of segments used to store the table

SEGBF

Segment block factor of the data DB area used to store the table

page_size

Page size of the data DB area used to store the table (bytes)

usrlog_file_num

Use the following formula to determine its value.

[Figure]

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 adbimport 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 IDXPRGLOG

Use the formula below to determine the value of variable IDXPRGLOG.

Note that in the following cases, you do not need to estimate the value of this variable. Substitute 0 for IDXPRGLOG.

Formula (bytes)

[Figure]

Explanation of variables

idx_num

Number of indexes defined for the table to be deleted

dbarea_file_num(i)

Number of DB area files in data DB area that stores the indexes

SGIDX(i)

For each index, number of segments that store indexes

SEGBF(i)

For each index, segment block factor for the data DB area

page_size(i)

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

usrlog_file_num

Use the following formula to determine its value.

[Figure]

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 adbimport 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 IMPTBLLOG

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

Formula (bytes)

[Figure]
Explanation of variables

  • dbarea_file_num

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

  • SGDATA

    Number of segments that store the table to be allocated during import processing

  • SEGBF

    Segment block factor of the data DB area that stores the table

  • page_size

    Page size of the data DB area used to store the table (bytes)

  • imp_load_rthd

    Use the following formula to determine the value:

    value-specified-for-import-option-adb_import_rthd_num - 1

    If the import option adb_import_rthd_num is omitted, substitute the number of threads used when the import option adb_import_rthd_num is omitted. For details, see adbimport (Import Data) in the manual HADB Command Reference.

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. Estimate the number of segments to be allocated based on the size of the data to be imported.

To Page Top

(4) Determining the variable IMPSTBLLOG

Use the formula below to determine the value of variable IMPSTBLLOG.

Note that in the following cases, you do not need to estimate the value of this variable. Substitute 0 for IMPSTBLLOG.

Formula (bytes)
IMPSTBLLOG = IMPSTBLPRGLOG + IMPSTBLUPDLOG

In the following case, a value needs to be estimated for variable IMPSTBLPRGLOG only:

In the following case, a value needs to be estimated for variable IMPSTBLUPDLOG only:

Explanation of variables

IMPSTBLPRGLOG

Update log created when data is deleted from or added to the STATUS_CHUNKS table

Use the following formula to determine its value.

Formula (bytes)

[Figure]
chunk_num

Number of chunks created

IMPSTBLUPDLOG

Update log created when data is updated in or added to the STATUS_CHUNKS table

Substitute the following value.

Value (bytes)
IMPSTBLUPDLOG = 1,464

To Page Top

(5) Determining the variable IMPRNGIDXLOG

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

Formula (bytes)

[Figure]
Explanation of variables

  • n

    Number of range indexes defined for the table to be imported

  • IMPRNGIDX(i)LOG

    Log size of the i-th range index defined for the table to be imported

    Determine this value from the formula shown below. However, the formula depends on whether the adbimport command is executed with the -d option specified (whether the creation mode or the addition mode is used).

■ Formula (when the -d option is specified (creation mode is used)) (bytes)

[Figure]

  • page_size(i)

    Page size in the data DB area for storing the i-th range index defined for the table to be imported (bytes)

  • DIRRNGPGNO(i)

    Number of pages in the management area for the i-th range index defined for the table to be imported

    Use the following formula to determine its value:

    [Figure]

  • dbarea_file_num(i)

    Number of DB area files in the data DB area for storing range indexes (files)

  • SGRNGDATA(i)

    Number of range index segments to be allocated in the data import processing

    For details, see 5.8.6 Determining the number of segments for storing each range index.

  • SEGBF(i)

    Segment blocking factor for the data DB area for storing range indexes

    See the explanation of the variable SEGBF in (2) Explanation of variables under 5.8.1 Determining the total number of pages in the data DB area.

  • page_size(i)

    Page size in the data DB area for storing the i-th range index defined for the table to be imported (bytes)

■ Formula (when the -d option is omitted (addition mode is used)) (bytes)

[Figure]

  • DIRRNGPGNO(i)

    Number of pages in the management area for the i-th range index defined for the table to be imported

    See the variable DIRRNGPGNO(i) in Formula (when the -d option is specified (creation mode is used)).

  • OLDSGRNGDATA

    Number of segments in the data DB area for storing the range indexes that had been allocated before the data was imported

    For details, see the description of the variable RS(i) in 5.8.6 Determining the number of segments for storing each range index.

  • SEGSIZE(i)

    Segment size in the data DB area for storing the i-th range index defined for the table to be imported

    Use the following formula to determine its value.

    SEGSIZE = 4,194,304 ÷ page_size(i)

  • page_size(i)

    Page size in the data DB area for storing the i-th range index defined for the table to be imported (bytes)

To Page Top

(6) Determining the variable IMPIDXLOG

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

Formula (bytes)

[Figure]
Explanation of variables

  • n

    Number of B-tree indexes defined for the table to be imported

  • IMPIDX(i)LOG

    Log size of the i-th B-tree index defined for the table to be imported

    Use the following formula to determine its value.

    Formula (bytes)

    [Figure]

  • unique_key_num

    Number of unique key values

    • Substitute 0 if the -d option is specified for the adbimport command.

    • In all other cases, for the i-th B-tree index defined for the table to be imported, remove duplicates from the key values generated from the imported data. Then, use a number that is between the minimum and maximum key values already stored in the index.

  • page_size(i)

    Page size of the data DB area that stores the i-th B-tree index (bytes)

  • imp_dividx_rthd

    Use the following formula to determine the value:

    value-specified-for-import-option-adb_import_rthd_num - 1

    If the import option adb_import_rthd_num is omitted, substitute the number of threads used when the import option adb_import_rthd_num is omitted. For details, see adbimport (Import Data) in the manual HADB Command Reference.

  • DIRPGNO(i)

    Number of pages in the management area for the i-th B-tree index defined for the table to be imported

    Use the following formula to determine its value.

    Formula

    [Figure]

  • dbarea_file_num(i)

    Number of DB area files in data DB area that stores the B-tree indexes

  • SGIDX(i)

    Number of segments that store the ith B-tree index to be allocated during import processing

  • SEGBF(i)

    Segment block factor of the data DB area that stores the ith B-tree indexes

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. Estimate the number of segments to be allocated based on the size of the data to be imported.

To Page Top

(7) Determining the variable IMPTIXLOG

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

Formula (bytes)

[Figure]

Explanation of variables

n

Number of text indexes defined for the table to be imported

IMPTIX(i)LOG

Log size of the i-th text index defined for the table to be imported

Use the following formula to determine its value. However, the formula depends on whether the adbimport command is executed with the -d option specified (whether the creation mode or the addition mode is used).

■ Formula (when the -d option is specified (creation mode is used)) (bytes)

[Figure]
page_size(i)

Page size of the data DB area for storing the i-th text index defined for the table to be imported (bytes)

DIRTIXPGNO(i)

Number of pages in the management area for the i-th text index defined for the table to be imported

Use the following formula to determine its value.

[Figure]
dbarea_file_num(i)

Number of DB area files in the data DB area for storing text indexes (files)

SGTXTDATA(i)

Number of text index segments to be allocated in the data import processing

SEGBF(i)

Segment blocking factor for the data DB area for storing text indexes

See the explanation of the variable SEGBF in (2) Explanation of variables under 5.8.1 Determining the total number of pages in the data DB area.

■ Formula (when the -d option is omitted (addition mode is used)) (bytes)

[Figure]
DIRTIXPGNO(i)

Number of pages in the management area for the i-th text index defined for the table to be imported

See the variable DIRTIXPGNO(i) in Formula (when the -d option is specified (creation mode is used)).

OLDPGTIXDATA(i)

Number of pages for storing the text indexes that had been allocated before the data was imported

Use the following formula to determine its value.

OLDPGTIXDATA(i) = ↑TIP_STRSEG(i)↑ + ↑TIP_APPSEG(i)↑
TIP_STRSEG(i)

See (1) Determining the number of storage pages used in the string control segment (variable TIP_STRSEG(i)) in 5.8.5 Determining the number of storage pages for each text index segment.

TIP_APPSEG(i)

See (2) Determining the number of storage pages used in the position control segment (variable TIP_APPSEG(i)) in 5.8.5 Determining the number of storage pages for each text index segment.

To Page Top

All Rights Reserved. Copyright (C) 2012, 2020, Hitachi, Ltd.