6.3 Estimating the HADB server's memory requirement

This section explains how to estimate the amount of memory required by the HADB server.

You can use the following formula to determine the maximum size of memory to be used by the HADB server. Specify a value that is equal to or greater than the value obtained from the formula for the adb_sys_memory_limit server definition operand. For details, see the explanation of the adb_sys_memory_limit operand in 7.2.2 Operands related to performance (set format).

Formula (kilobytes)

#1

Applies to the variables in (4) Determining the real thread private memory requirement under 6.3.1 Determining the shared memory requirement, excluding the following:

• RTHD_IMPORTSZ

• RTHD_IDXRBLDSZ

• RTHD_GETCOSTSZ

• RTHD_DBSTATUSSZ

• RTHD_EXPORTSZ

• RTHD_MERCHKSZ

• RTHD_ARCCKSZ

• RTHD_UNARCCKSZ

• RTHD_REORGSZ

• RTHD_CLTDEFMNG

• RTHD_SYNDICTSZ

• RTHD_AUDTRAILSZ

• RTHD_CONVERTAUDSZ

#2

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

#3

Applies to the following variables in (4) Determining the real thread private memory requirement under 6.3.1 Determining the shared memory requirement:

• RTHD_IMPORTSZ

• RTHD_IDXRBLDSZ

• RTHD_GETCOSTSZ

• RTHD_DBSTATUSSZ

• RTHD_EXPORTSZ

• RTHD_MERCHKSZ

• RTHD_ARCCKSZ

• RTHD_UNARCCKSZ

• RTHD_REORGSZ

• RTHD_CLTDEFMNG

• RTHD_SYNDICTSZ

• RTHD_AUDTRAILSZ

• RTHD_CONVERTAUDSZ

The memory used by the HADB server consists of shared memory and process memory.

■ Shared memory types

To determine the amount of shared memory, you must determine the amount for each of the following four types:

• Shared memory management area

• Global buffer page

• Process common memory

• Real thread private memory

■ Process memory type

• Heap memory

The HADB server uses these types of memory at the following times:

• During startup of the HADB server

• During normal operation (when an HADB client connects to the HADB server and executes an SQL statement)

• During execution of the adbinit command

• During execution of the adbimport command

• During execution of the adbidxrebuild command

• During execution of the adbgetcst command

• During execution of the adbdbstatus command

• During execution of the adbexport command

• During execution of the adbstat command

• During execution of the adbmodarea command

• During execution of the adbmergechunk command

• During execution of the adbchgchunkcomment command

• During execution of the adbchgchunkstatus command

• During execution of the adbarchivechunk command

• During execution of the adbunarchivechunk command

• During execution of the adbreorgsystemdata command

• During execution of the adbclientdefmang command

• During execution of the adbsyndict command

• During execution of the adbconvertaudittrailfile command

Note

If you do not specify the adb_sys_memory_limit server definition operand, specify the maximum size of process common memory in the adb_sys_proc_area_max server definition operand. Also specify the maximum size of real thread private memory per real thread in the adb_sys_rthd_area_max server definition operand.

Organization of this section

• 6.3.1 Determining the shared memory requirement

• 6.3.2 Determining the process memory requirement

• 6.3.3 Determining the memory requirement for starting the HADB server

• 6.3.4 Determining the memory requirement during normal operation

• 6.3.5 Determining the memory requirement for executing the adbinit command

• 6.3.6 Determining the memory requirement for executing the adbimport command

• 6.3.7 Determining the memory requirement for executing the adbidxrebuild command

• 6.3.8 Determining the memory requirement for executing the adbgetcst command

• 6.3.9 Determining the memory requirement for executing the adbdbstatus command

• 6.3.10 Determining the memory requirement for executing the adbexport command

• 6.3.11 Determining the memory requirement for executing the adbstat command

• 6.3.12 Determining the memory requirement for executing the adbmodarea command

• 6.3.13 Determining the memory requirement for executing the adbmergechunk command

• 6.3.14 Determining the memory requirement for executing the adbchgchunkcomment command

• 6.3.15 Determining the memory requirement for executing the adbchgchunkstatus command

• 6.3.16 Determining the memory requirement for executing the adbarchivechunk command

• 6.3.17 Determining the memory requirement for executing the adbunarchivechunk command

• 6.3.18 Determining the memory requirement for executing the adbreorgsystemdata command

• 6.3.19 Determining the memory requirement for executing the adbclientdefmang command

• 6.3.20 Determining the memory requirement for executing the adbsyndict command

• 6.3.21 Determining the memory requirement for executing the adbaudittrail command

• 6.3.22 Determining the memory requirement for executing the adbconvertaudittrailfile command

To Page Top