Formulas for shared memory used by a single server

This subsection lists and describes the formulas used for calculating the shared memory used by a HiRDB single server configuration.

For 32-bit mode (KB):: Formula 1 + {((40 + (value obtained by adding Formulas 2 through 7 and Formula 9) + (6.5 1,024 1,024)) 512 512)} 1,024

For 64-bit mode (KB):: Formula 1 + {((72 + (value obtained by adding Formulas 2 through 9) + (6.5 1,024 1,024)) 512 512)} 1,024

Notes on Formulas 1 to 10:

If Y is specified in the pd_rdarea_open_attribute_use or pd_lv_mirror_use operand, add Formula 3.
If commit is specified in either the pd_dbsync_point operand or the pd_system_dbsync_point operand, add Formula 4. The default for the pd_system_dbsync_point operand is commit.
Otherwise, add Formula 7.
If the pd_inner_replica_control operand is specified, add Formula 5.
If the pd_dfw_awt_process operand is specified, add Formula 6.
If you omit the pd_sds_shmpool_size operand, the following value is set:
For 32-bit mode:
{((40 + (value obtained by adding Formulas 2 through 7 9, 10)) 512 512)} 1,024
For 64-bit mode:
{((72 + (value obtained by adding Formulas 2 through 9, 10)) 512 512)} 1,024
If you specify the pd_max_resident_rdarea_no operand, add Formula 8.
If the value of pd_max_temporary_object_no is 1 or greater, add Formula 9.
If the value of pd_max_tmp_table_rdarea_no is 1 or greater, add Formula 10.

The following table shows Formulas 1 through 10.

Formula	Shared memory calculation formula
Formula 1 (KB)	32-bit mode b 1.3 + c + d + f + 1.6 + q + r + 4 + { [ (a + 12) 13] 1.1 + [ (a + 62) 63] + 3.7} (e + 3) + 3.5 + { ((b 64)) (8 16) 4 4 + 12 {(b 3) + 1 - mod (b 3, 2)} + 8 a {(e + 3) 2 + 1 + MAX (e 10, 5)} + 32 + 20,000 + {(c 8) + 7} 64 8 + {(f 8) + 7} 64 8 + MAX {a (e + 3), c 8} 104 + MAX {a (e + 3), f 8} 24 + {(q 4) + 7} 64 8 + {[(r - (s 592 + t 916 + u 172)) 2] + 7} 64 8 + MAX {13 (e + 3), q 4} 88 + MAX {21 (e + 3), [r - (s 592 + t 916 + u 172)] 2} 60 + 44 + 256 + 1,024 + 512^#¹ } 1,024 + y + 7.5 + {248 v w + 47 v + 72} 1,024 + {(28 + ((32 + ((g 127 + 1) 2,048 + 128)) 32 32)) 128 128 } 1,024 D + (E_i) i=1 Add this if the pd_def_buf_control_area_assign operand is specified as INITIAL or if the operand is omitted. + {[(a + 12) 13] 1.1 + [(a + 62) 63] + 3.7} (e + 7) 64-bit mode b 1.3 + c + d + f + 1.6 + q + r + 5 + { [ (a + 12) 13] 1.2 + [ (a + 62) 63] 1.5 + 4.1} (e + 3) + 3.5 + { ((b 64)) (8 16) 4 4 + 12 {(b 3) + 1 - mod (b 3, 2)} + 8 a {(e + 3) 2 + 1 + MAX (e 10, 5)} + 48 + 20,000 + {(c 8) + 7} 64 8 + {(f 8) + 7} 64 8 + MAX {a (e + 3),c 8} 104 + MAX {a (e + 3), f 8} 40 + {(q 4) + 7} 64 8 + {[(r - (s 600 + t 936 + u 182)) 2] + 7} 64 8 + MAX {13 (e + 3), q 4} 104 + MAX {21 (e + 3), [r - (s 600 + t 936 + u 184)] 2} 72 + 72 + 256 + 1,536 + 512^#¹ } 1,024 + y + 7.5 + {248 v w + 64 v + 72} 1,024 + {(56 + ((56 + ((g 127 + 1) 2,048 + 128)) 32 32)) 128 128 } 1,024 D + (E_i) i=1 Add this if the pd_def_buf_control_area_assign operand is specified as INITIAL or if the operand is omitted. + {[(a + 12) 13] 1.2 + [(a + 62) 63] 1.5 + 4.1} (e + 7)
Formula 2 (bytes)	32-bit mode 500 1,024 + 5,072 (e + 15) + (372 g 16 16) + 48^#1 g + 432 h + 112 (p + 240) + 96 x + 32 j + 132 {19 + (e + 3) 3} + 48 n + 48 {(e + 3) 2 + 1 + MAX(5, (e + 3) 10)} + 68 B + 152 (A + 120) + 80 + 32 g + 64^#2 + 96^#3 + 368^#4 + ((((g 8) + 3) 4) 4) j 64-bit mode 500 1,024 + 9,416 (e + 15) + (472 g 16 16) + (56^#1 g 16 16) + 448 h + (136 (p + 240) 16 16) + 144 x + 48 j + 240 {19 + (e + 3) 3} + 64 n + 96 {(e + 3) 2 + 1 + MAX(5, (e + 3) 10)} + 68 B + 184 (A + 120) + 96 + 48 g + 64^#2 + 128^#3 + 448^#4 + ((((g 8) + 7) 8) 8) j
Formula 3 (bytes)	32-bit mode {[(g 8 4) 4] + 8} {(e + 3) 2 + 12} 64-bit mode {[(g 8 8) 8] + 8} {(e + 3) 2 + 12}
Formula 4 (bytes)	32-bit mode (32 + 16 x) (e 2 + 7 + 1) + 16 64-bit mode (48 + 32 x) (e 2 + 7 + 1) + 16
Formula 5 (bytes)	56 z + 16
Formula 6 (bytes)	32-bit mode 72 + 52 C + 68 x If you specify 1 in the pd_dbbuff_trace_level operand, add: + 320 x 64-bit mode 96 + 56 C + 72 x If you specify 1 in the pd_dbbuff_trace_level operand, add: + 640 x
Formula 7 (bytes)	32-bit mode (32 + 16 x) 10 + 16 64-bit mode (48 + 32 x) 10 + 16
Formula 8 (bytes)	16 + 112 + (48 + 48 G) + (48 + 32 H)
Formula 9 (bytes)	16 + 80 I
Formula 10 (bytes)	(112 + (28 + J 52)) 8 8

a: Value of pd_max_access_tables operand

b: Value of pd_sql_object_cache_size operand

c: Value of pd_table_def_cache_size operand

d: Value of pd_auth_cache_size operand

e: Value of pd_max_users operand

f: Value of pd_view_def_cache_size operand

g: Value of pd_max_rdarea_no operand

h: Value of pd_max_file_no operand

j: Number of global buffers for indexes: If Y is specified in the pd_dbbuff_modify operand, add the pd_max_add_dbbuff_no operand value to the number of pdbuffer commands that have been specified.

n: Value of pd_lck_until_disconnect_cnt operand

p: Value of pd_assurance_index_no operand

q: Value of pd_type_def_cache_size operand

r: Value of pd_routine_def_cache_size operand

s: Number of plug-ins installed

t: Total number of plug-in functions used with DML^#⁵

u: Total number of parameters for the plug-in functions used with DML^#⁵

v: Value of pd_max_list_users operand

w: Value of pd_max_list_count operand

x: Total number of global buffers (number specified in the pdbuffer operand): If Y is specified in the pd_dbbuff_modify operand, add the pd_max_add_dbbuff_no operand value to the number of pdbuffer commands that have been specified.

y: Value of pd_registry_cache_size operand

z: Value of the pd_inner_replica_control operand

A: Value of the pd_assurance_table_no operand

B: Maximum number of transactions in the server (2 e + 7)

C: Value of the pd_dfw_awt_process operand

D: Total number of specified pdplgprm operands

E_i: Size of the shared memory specified by the i^th pdplgprm operand.

G: Value of the pd_max_resident_rdarea_no operand

H: Value of the pd_max_resident_rdarea_shm_no operand

I: Value of the pd_max_temporary_object_no operand

J: Value of the pd_max_tmp_table_rdarea_no operand

T: Number of tables that will use the free space reusage facility

#1: Add this value if neither the pd_max_list_users nor pd_max_list_count operand is 0.

#2: Add this value if at least 1 is specified in the pd_max_ard_process operand.

#3: Add this value if at least 1 is specified in the pd_max_reflect_process_count operand.

#4: Add this value if the facility for predicting reorganization time is used.

#5: You can use the following SQL statement to obtain the total number of plug-in functions and the total number of parameters for the plug-in functions used with DML:

SELECT COUNT(*),SUM(N_PARAM) FROM MASTER.SQL_PLUGIN_ROUTINES
WHERE PLUGIN_NAME  =  'plug-in-name'
AND (TIMING_DESCRIPTOR  =  'ADT_FUNCTION'
    OR TIMING_DESCRIPTOR IS NULL
    OR TIMING_DESCRIPTOR  =  'BEFORE_INSERT'
    OR TIMING_DESCRIPTOR  =  'AFTER_INSERT'
    OR TIMING_DESCRIPTOR  =  'BEFORE_UPDATE'
    OR TIMING_DESCRIPTOR  =  'AFTER_UPDATE'
    OR TIMING_DESCRIPTOR  =  'BEFORE_DELETE'
    OR TIMING_DESCRIPTOR  =  'AFTER_DELETE'
    OR TIMING_DESCRIPTOR  =  'BEFORE_PURGE_TABLE'
    OR TIMING_DESCRIPTOR  =  'AFTER_PURGE_TABLE'
    OR TIMING_DESCRIPTOR  =  'INDEX_SEARCH'
    OR TIMING_DESCRIPTOR  =  'INDEX_COUNT'
    OR TIMING_DESCRIPTOR  =  'INDEX_INSERT'
    OR TIMING_DESCRIPTOR  =  'INDEX_BEFORE_UPDATE'
    OR TIMING_DESCRIPTOR  =  'INDEX_AFTER_UPDATE'
    OR TIMING_DESCRIPTOR  =  'INDEX_DELETE'
    OR TIMING_DESCRIPTOR  =  'PURGE_INDEX'
    OR TIMING_DESCRIPTOR  =  'INDEX_MAINTENANCE_DEFERRED'
    OR TIMING_DESCRIPTOR  =  'BEFORE_INSERT_DC'
    OR TIMING_DESCRIPTOR  =  'BEFORE_UPDATE_DC'
    OR TIMING_DESCRIPTOR  =  'BEFORE_DATA_CHECK'
    OR TIMING_DESCRIPTOR  =  'AFTER_DATA_CHECK')

15.1.4 Formulas for shared memory used by a single server