Following is the formula for calculating the size of the shared memory that is used by a front-end server. For the variables used in this formula, see (4) below.

• 32-bit mode
  

  40 + b 1.3 + c + d + k + 1.6 + x + y + 4 + {[(a + 12) 13] 1.1 + [(a + 62) 63] + 3.7} (e + 3) + { b 64 (8 16) 4 4 + 12 {(b 3) + 1 - mod(b 3, 2)} + 4 a {(e + 3) 2 + 1 + MAX(e 10, 5)} + 32 + 4+ {28 (f + 1) g} + 20,000 + {(c 8) + 7} 64 8 + {(k 8) + 7} 64 8 + MAX{a (e + 3), c 8} 104 + MAX{a (e + 3), k 8} 24 + {(x 4) + 7} 64 8 + {[(y - (s 592 + t 916 + u 172)) 2] + 7} 64 8 + MAX{13 (e + 3), x 4} 88 + 60 MAX{21 (e + 3), (y - (s 592 + t 916 + u 172)) 2} + 44 + 256 + 1,024 } 1,024 + A + 7 I + (Ji) i=1 + 6.5 1,024 f Add this value if you specified INITIAL in the pd_def_buf_control_area_assign operand or omitted this operand. + {[(a + 12) 13] 1.1 + [(a + 62) 63] + 3.7} (e + 7) (KB)

• 64-bit mode
  

  40 + b 1.3 + c + d + k + 1.6 + x + y + 5 + {[(a + 12) 13] 1.2 + [(a + 62) 63] 1.5 + 4.1} (e + 3) + { b 64 (8 16) 4 4 + 12 {(b 3) + 1-mod(b 3, 2)} + 4 a {(e + 3) 2 + 1 + MAX(e 10, 5)} + 48 + 8+ {40 (f + 1) g} + 20,000 + {(c 8) + 7} 64 8 + {(k 8) + 7} 64 8 + MAX(a (e + 3), c 8) 104 + MAX{a (e + 3), k 8} 40 + {(x 4) + 7} 64 8 + {[(y - (s 600 + t 936 + u 184)) 2] + 7} 64 8 + MAX{13 (e + 3), x 4} 104 + 72 MAX{21 (e + 3), (y-(s 600 + t 936 + u 184)) 2} + 72 + 256 + 1,536 } 1,024 + A + 7 I + (Ji) i=1 + 6.5 1,024 f Add this value when INITIAL is specified in the pd_def_buf_control_area_assign operand or the operand is omitted. + {[(a + 12) 13] 1.2 + [(a + 62) 63] 1.5 + 4.1} (e + 7) (KB)

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

For 32-bit mode (KB):

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

For 64-bit mode (KB):

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

For the variables used in the formulas, see (4).

Notes

• Add 3 to the formula if commit is specified in either the pd_dbsync_point operand or the pd_system_dbsync_point operand. The default for the pd_system_dbsync_point operand is commit.
  Otherwise, add Formula 5.
  
• Add Formula 4 if the pd_dfw_awt_process operand is specified.
• If you omit the pd_dic_shmpool_size operand, the following value is set:
  For 32-bit mode:
  {((40 + (total of Formulas 2 through 5)) 512 512)} 1,024
  For 64-bit mode:
  {((72 + (total of Formulas 2 through 5)) 512 512)} 1,024
  

  Condition	Shared memory calculation formula (KB)
  Formula 1 (KB)	32-bit mode b 1.3 + { b 64 (8 16) 4 4 + 12 {(b 3) + 1 - mod(b 3, 2)} + 8 a {(e + 3) 2 + 1 + MAX(e 10, 5)} + 512 } 1,024 + 3.5 + (224 v w) 1,024 + 0.5 + { (28 + ((32 + ((g 127 + 1) 2,048 + 128)) 32 32)) 128 128 } 1,024 K + (Li) i=1 64-bit mode b 1.3 + { b 64 (8 16) 4 4 + 12 {(b 3) + 1 - mod(b 3, 2)} + 8 a {(e + 3) 2 + 1 + MAX(e 10, 5)} + 1,024 } 1,024 + 3.5 + (224 v w) 1,024 + 0.5 + { (56 + ((56 + ((g 127 + 1) 2,048 + 128)) 32 32)) 128 128 } 1,024 K + (Li) i=1
  Formula 2 (bytes)	32-bit mode 500 1,024 + (372 g 16 16) + 432 h + 112 240 + 5,072 (e + 15) + 96 z + 32 m + 172 {a (e + 3) + (e + 3) 2 + 22} + 16 + 48 p + 36 {(e + 3) 2 + 1 + MAX(5, [e + 3] 10)} + 68 G + 152 120 + 80 + 64#1 + 368#2 + ((((g 8) + 3) 4) 4) m 64-bit mode 500 1,024 + (472 g 16 16) + 448 h + (136 240 16 16) + 9,424 (e + 15) + 144 z + 48 m + 336 {a (e + 3) + (e + 3) 2 + 22} + 16 + 64 p + 72 {(e + 3) 2 + 1 + MAX(5, [e + 3] 10)} + 68 G + 184 120 + 96 + 64#1 + 448#2 + ((((g 8) + 7) 8) 8) m
  Formula 3 (bytes)	32-bit mode (32 + 16 z) (G + 1) + 16 64-bit mode (48 + 32 z) (G + 1) + 16
  Formula 4 (bytes)	32-bit mode 72 + 52 H + 68 z If you specify 1 in the pd_dbbuff_trace_level operand, add: + 320 z 64-bit mode 96 + 56 H + 72 z If you specify 1 in the pd_dbbuff_trace_level operand, add: + 640 z
  Formula 5 (bytes)	32-bit mode (32 + 16 z) 10 + 16 64-bit mode (48 + 32 z) 10 + 16

#1: Add this if the pd_max_ard_process operand is specified with a value of at least 1.

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

This subsection lists and describes the formulas used for calculating the shared memory used by a back-end server.

For 32-bit mode (KB):

Formula 1 + {((40 + (value obtained by adding Formulas 2 through 7)) 512 512)} 1,024

For 64-bit mode (KB):

Formula 1 + {((72 + (value obtained by adding Formulas 2 through 9)) 512 512)} 1,024

For details about the variables used in these formulas, see (4) below.

Notes on Formulas 1 through 9

• If any of the following conditions is satisfied, add Formula 3:
  Y is specified in the pd_rdarea_open_attribute_use operand
  Y is specified in the pd_lv_mirror_use operand
  The rapid switchover facility is used
  
• If either of the following conditions is satisfied, add Formula 4:
  commit is specified in the pd_dbsync_point operand
  Y is specified in the pd_shared_rdarea_use operand
  Otherwise, add Formula 7.
  
• If commit is specified in the pd_inner_replica_control operand, add Formula 5.
• If the pd_dfw_awt_process operand is specified, add Formula 6.
• If you omit the pd_bes_shmpool_size operand, the following value is set:
  For 32-bit mode:
  {((40 + (value obtained by adding Formulas 2 through 7)) 512 512)} 1,024
  For 64-bit mode:
  {((72 + (value obtained by adding Formulas 2 through 9)) 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.
  

  Condition	Shared memory calculation formula
  Formula 1 (KB)	32-bit mode b 1.3 + { b 64 (8 16) 4 4 + 12 {(b 3) + 1 - mod(b 3, 2)} + 8 a {(e + 3) 2 + 1 + MAX(e 10, 5)} + 512 + 512#1 } 1,024 + {72 + 8 v (8 + 3 w)} 1,024 + {(g 127 + 1) 2,048 + 128} 1,024 + { (28 + ((32 + ((g 127 + 1) 2,048 + 128)) 32 32)) 128 128} } 1,024 M + (Ni) i=1 64-bit mode b 1.3 + { b 64 (8 16) 4 4 + 12 {(b 3) + 1 - mod(b 3, 2)} + 8 a {(e + 3) 2 + 1 + MAX(e 10, 5)} + 1,024 + 512#1 } 1,024 + {72 + 24 v (2 + w)} 1,024 + { (56 + ((56 + ((g 127 + 1) 2,048 + 128)) 32 32)) 128 128 } 1,024 M + (Ni) i=1
  Formula 2 (bytes)	32-bit mode 500 1,024 + (308 + 48#1) g + 432 h + 112 r + 5,072 (e + 15) + 96 z + 32 m + 172 {a (e + 3) + (e + 3) 2 + 22} + 16 + 48 p + 48 {(e + 3) 2 + 1 + MAX(5, [e + 3] 10)} + 68 G + 152 F + 80 + 32 g + 64#2 + 96#3 + ((((g 8) + 3) 4) 4) m 64-bit mode 500 1,024 + (400 + 56#1) g + 448 h + 136 r + 9,424 (e + 15) + 144 z + 48 m + 336 {a (e + 3) + (e + 3) 2 + 22} + 16 + 64 p + 96 {(e + 3) 2 + 1 + MAX(5, [e + 3] 10)} + 68 G + 184 F + 96 + 48 g + 64#2 + 128#3 + ((((g 8) + 7) 8) 8) m
  Formula 3 (bytes)	32-bit mode {{[(g 8 4) 4] + 8} (a [[e + 3] + e + 15)} 64-bit mode {([(g 8 8) 8] + 8} (a [e + 3] + e + 15)}
  Formula 4 (bytes)	32-bit mode (32 + 16 z) (e 2 + 7 + 1) + 16 64-bit mode (48 + 32 z) (e 2 + 7 + 1) + 16
  Formula 5 (bytes)	56 E + 16
  Formula 6 (bytes)	32-bit mode 72 + 52 H + 68 z If you specify 1 in the pd_dbbuff_trace_level operand, add: + 320 z 64-bit mode 96 + 56 H + 72 z If you specify 1 in the pd_dbbuff_trace_level operand, add: + 640 z
  Formula 7 (bytes)	32-bit mode (32 + 16 z) 10 + 16 64-bit mode (48 + 32 z) 10 + 16
  Formula 8 (bytes)	16 + 112 + (48 + 48 Q) + (48 + 32 R)
  Formula 9 (bytes)	16 + 80 S

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

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

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

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

f: Total number of back-end servers

g: Value of pd_max_rdarea_no operand

h: Value of pd_max_file_no operand

k: Value of pd_view_def_cache_size operand

m: Number of global buffers for index

If Y is specified in the pd_dbbuff_modify operand, add the pd_max_add_dbbuff_no operand value of the server definition to the number of pdbuffer statements related to the server.

p: Value of pd_lck_until_disconnect_cnt operand

q: MIN (e + 3, p)

r: Value of pd_assurance_index_no operand

s: Number of plug-ins installed

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

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

v: Value of pd_max_list_users operand

w: Value of pd_max_list_count operand

x: Value of pd_type_def_cache_size operand

y: Value of pd_routine_def_cache_size operand

z: Total number of global buffers (number of pdbuffer operands specified)

If Y is specified in the pd_dbbuff_modify operand, add the pd_max_add_dbbuff_no operand value of the server definition to the number of pdbuffer statements related to the server.

A: Value of pd_registry_cache_size operand

E: Value of the pd_inner_replica_control operand

F: Value of the pd_assurance_table_no operand

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

H: Value of the pd_dfw_awt_process operand

I: Total number of pdplgprm operands specified in the front-end server

J_i: Size of the shared memory specified in the i^th pdplgprm operand specified in the front-end server

K: Total number of pdplgprm operands specified in the dictionary server

L_i: Size of the shared memory specified in the i^th pdplgprm operand specified in the dictionary server

M: Total number of pdplgprm operands specified in the back-end server

N_i: Size of the shared memory specified in the i^th pdplgprm operand specified in the back-end server

Q: Value of the pd_max_resident_rdarea_no operand

R: Value of the pd_max_resident_rdarea_shm_no operand

S: Value of the pd_max_temporary_object_no operand

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

#1: For a dictionary server, use the value of the pd_max_dic_process operand. For a back-end server, use the value of the pd_max_bes_process operand. If the pd_max_dic_process or pd_max_bes_process operand is omitted, use the value of the pd_max_users operand.

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