This subsection lists and describes the formulas used for calculating the shared memory used by a HiRDB/Single Server.

For 32-bit mode (KB):

Formula 1 + {( (40 + (value obtained by adding Formulas 2 through 5)) 512 512)} 1024

For 64-bit mode (KB):

Formula 1 + {((72 + (value obtained by adding Formulas 2 through 5)) 512 512)} 1024

Notes on Formulas 1 to 6:

• If Y is specified in the pd_rdarea_open_attribute_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.
• If the pd_dfw_awt_process operand is specified, add Formula 5.
• If you omit the pd_sds_shmpool_size operand, the following value is set:
  For 32-bit mode:
  {( (40 + (total of Formulas 2 through 5)) 512 512)} 1024
  For 64-bit mode:
  {( (72 + (total of Formulas 2 through 5)) 512 512)} 1024
  
• If you omit the pd_max_commit_write_reclaim_no operand (except cases in which v6compatible or v7compatible is specified in the pd_sysdef_default_option operand), or you specify a value other than 0 in the pd_max_commit_write_reclaim_no operand, add Formula 6. However, if you have already added Formula 4, you do not need to add this formula.

The following table shows Formulas 1 through 6.

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 + {(c 8) + 7} 64 8 + {(f 8) + 7} 64 8 + MAX {a (e + 3), c 8} 88 + 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 + 1024 + 512#1 } 1024 + y + 7.5 + {248 v w + 47 v + 72} 1024 + { (28 + ((32 + ((g 127 + 1) 2048 + 128)) 32 32)) 128 128 } 1024 D + (Ei) 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 + {(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 +1536 + 512#1 } 1024 + y + 7.5 + {248 v w + 64 v + 72} 1024 + {(56 + ((56 + ((g 127 + 1) 2048 + 128)) 32 32)) 128 128 } 1024 D + (Ei) 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 1024 5072 (e + 15) + (372 g 16 16) + 48#1 g + 328 h + 112 (p + 240)#5 + 96 x + 32 j + 132 {19 + (e + 3) 3} + 48 n + 48 {(e + 3) 2 + 1 + MAX(5,(e + 3) 10)} + 68 B + 144 A + 80 + 32 g + 64#2 + 368#3 + (( ( (g 8) + 3) 4 ) 4) j 64-bit mode 500 1024 9416 (e + 15) + (472 g 16 16) + (56#1 g 16 16) + 344 h + (136 (p + 240) 16 16)#6 + 144 x + 48 j + 240 {19 + (e + 3) 3} + 64 n + 96 {(e + 3) 2 + 1 + MAX(5,(e + 3) 10)} + 68 B + 160 A + 96 + 48 g + 64#2 + 448#3 + (( ( (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)	32-bit mode 88 + 52 C + 3400 64-bit mode 112 + 56 C + 7200
Formula 6 (bytes)	32-bit mode (32 + 16 q) F + 16 64-bit mode (48 + 32 q) F + 16

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

i: Total number of indexes in the server (for a partitioning key index, this is the number of partitions in the server)

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^#4

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

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

A: Value of the pd_assurance_table_no operand

B: Maximum number of transactions in the server (2e + 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.

F: Value of the pd_max_commit_write_reclaim_no operand

#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 the facility for predicting reorganization time is used.

#4: 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')

#5: When you specify v6compatible or v7compatible in the pd_sysdef_default_option operand, use 112 MAX(p, i 1.2) for calculating instead of 112 (p + 240).

#6: When you specify v6compatible or v7compatible in the pd_sysdef_default_option operand, use ( 136 MAX(p, (i 1.2)) 16 16) for calculating instead of ( 136 (p + 240) 16 16).