Hitachi

Hitachi Advanced Database Setup and Operation Guide


6.3.1 Determining the shared memory requirement

This subsection explains how to determine the amount of shared memory the HADB server will use.

Use the following formula to determine the amount of shared memory required by the HADB server.

Formula
shared-memory =
     shared-memory-management-area + global-buffer-page + process-common-memory
     + real-thread-private-memory#1
     × (value-specified-for-adb_sys_max_users-operand-in-server-definition
       + value-specified-for-adb_sys_rthd_num-operand-in-server-definition + 10)
       + real-thread-private-memory#2
#1

Applies to the variables in (4) Determining the real thread private 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

Applies to the following variables in (4) Determining the real thread private 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 following subsections explain how to determine the requirements for the shared memory management area, global buffer page, process common memory, and real thread private memory.

Organization of this subsection

(1) Determining the shared memory management area requirement

The shared memory management area is used in the cases described below. You must determine the requirement for the shared memory management area required in each of these cases.

(2) Determining the global buffer page requirement

A global buffer page is used for starting the HADB server. To determine the global buffer page requirement, see (2) Determining the global buffer page requirement (for starting the HADB server) in 6.3.3 Determining the memory requirement for starting the HADB server.

(3) Determining the process common memory requirement

Use the formula shown below to determine the process common memory requirement.

Formula (megabytes)

[Figure]

#

Add the value obtained by subtracting the value of the PROC_STAINF variable from the value of the PROC_STARTSZ variable.

Explanation of variables

(4) Determining the real thread private memory requirement

Use the formula shown below to determine the real thread private memory requirement.

Formula (megabytes)

[Figure]

Explanation of variables