6.3.15 Determining the memory requirement for executing the adbchgchunkstatus command

When you execute the adbchgchunkstatus command, the HADB server uses the following type of memory:

■ Shared memory

• Process common memory (PROC_CHGCSTSZ)

Use the following formula to determine the process common memory (PROC_CHGCSTSZ) used to execute the adbchgchunkstatus command.

Formula (kilobytes)

#

Add this value when you use the multi-node function.

Explanation of variables

PROC_MCS

Process common memory to be used for controlling chunk status changes

Formula (kilobytes)

#

Add this value when the audit trail facility is enabled.

DIC

Memory for acquiring the definition information of the table to be processed

Determine the value by referring to the explanation of the variable DIC in (a) Determining the variable PROC_IMPT in (1) Determining the process common memory requirement (for executing the adbimport command) in 6.3.6 Determining the memory requirement for executing the adbimport command.

chunk_num

Number of chunks created in the table to be processed

PROC_AUDINFSZ

Determine the value of the variable PROC_AUDINFSZ according to (r) Determining the variable AUDINF in (3) Determining the process common memory requirement (for starting the HADB server) under 6.3.3 Determining the memory requirement for starting the HADB server.

PROC_DBUPDINF

Process common memory required for storing DB area, table, index, and chunk update information

Value (kilobytes)

To Page Top