6.3.9 Determining the memory requirement for executing the adbdbstatus command

(1) Determining the process common memory requirement (for executing the adbdbstatus command)

Use the following formula to determine the process common memory (PROC_DBSTATUSSZ) required for executing the adbdbstatus command.

Formula (kilobytes)

PROC_DBSTATUSSZ = Σ(PROC_MNG)#

#

If you execute multiple adbdbstatus commands concurrently, determine the memory requirement for each adbdbstatus command. Then, add up the total memory requirements.

Explanation of variables

PROC_MNG

Process common memory used for managing DB status analysis

Formula (kilobytes)

PROC_MNG = 1,353 + DICINF + DBINF + ARCINF#1 + PROC_AUDINFSZ#2

#1

Add this value if you specify archivechunk for the -c option of the adbdbstatus command.

#2

Add this value when the audit trail facility is enabled.

DICINF

Memory for managing definition information

Formula (kilobytes)

• dbarea_num

  Number of data DB areas

• table_num

  Number of user-defined base tables

• arctable_num

  Number of user-defined base tables that are archivable multi-chunk tables

• index_num

  Number of user-defined indexes

DBINF

Memory for managing database information

Formula (kilobytes)

• file_num

  The largest number of DB area files among the DB areas to be analyzed and the DB areas storing the base tables and indexes to be analyzed

• chunk_num

  The largest number of chunks created in the base tables and indexes to be analyzed

  Determine the value as explained in (10) Determining the number of chunks created under C.9 Searching system tables.

• uthd_num

  Value specified for the adb_sys_uthd_num operand in the server definition

  If you do not specify the -d reorginfo option in the adbdbstatus command, substitute 0.

ARCINF

Memory for managing archivable multi-chunk tables

Formula (kilobytes)

col_num

Number of columns in the table to be processed

max_rowsz

Maximum row length (bytes)

Determine the maximum row length based on the formula for the row length ROWSZ in (1) Determining the number of pages for base rows (variable BP(i)) under 5.8.2 Determining the number of pages for storing each type of row.

idx_num

Number of indexes defined for 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.

To Page Top

(2) Determining the real thread private memory requirement (for executing adbdbstatus command)

The amount of real thread private memory (RTHD_DBSTATUSSZ) required for executing the adbdbstatus command is as follows.

Value (kilobytes)

RTHD_DBSTATUSSZ = 3

To Page Top