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.
40 + b x 1.3 + c + d + k + 1.6 + x + y + 4 + {[(a + 12) ![]() ![]() + { ![]() ![]() ![]() ![]() ![]() ![]() + 12 x {(b ![]() ![]() + 4 x a x {(e + 3) x 2 + 1 + MAX(e ![]() + 32 + 4+ {28 x (f + 1) x g} + 20,000 + 112 x B + ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() + MAX{a x (e + 3), c ![]() ![]() x 24 + ![]() ![]() ![]() ![]() + ![]() ![]() ![]() ![]() x 8 + MAX{13 x (e + 3), x ![]() + 60 x MAX{21 x (e + 3), (y - (s x 592 + t x 916 + u x 172)) ![]() + 44 + 256 + 1,024 } ![]() I + ![]() i=1 + ![]() ![]() ![]()
|
40 + b x 1.3 + c + d + k + 1.6 + x + y + 5 + {[(a + 12) ![]() ![]() + { ![]() ![]() ![]() ![]() ![]() ![]() + 12x{(b ![]() ![]() + 4 x ax {(e + 3) x 2 + 1 + MAX(e ![]() + 48 + 8+ {40x(f + 1) x g} + 20,000 + 112 x B + ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() + MAX(a x (e + 3), c ![]() ![]() + ![]() ![]() ![]() ![]() + ![]() ![]() ![]() ![]() + MAX{13 x (e + 3), x ![]() + 72 x MAX{21 x (e + 3), (y-(s x 600 + t x 936 + u x 184)) ![]() + 72 + 256 + 1,536 } ![]() I + ![]() i=1 + ![]() ![]() ![]()
![]() ![]() |
This subsection lists and describes the formulas used for calculating the shared memory used by a dictionary server.
Formula 1 + {(
(40 + (value obtained by adding Formulas 2 through 5))
512
x 512)}
1,024
Formula 1 + {(
(72 + (value obtained by adding Formulas 2 through 5))
512
x 512)}
1,024
For the variables used in the formulas, see (4).
Condition | Shared memory calculation formula (KB) |
---|---|
Formula 1 (KB) |
+ { ![]() ![]() ![]() ![]() ![]() ![]() + 12 x {(b ![]() ![]() + 8 x a x {(e + 3) x 2 + 1 + MAX(e ![]() + 512 } ![]() + 3.5 + ![]() ![]() ![]() + ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() } ![]() ![]() K + ![]() i=1
+ { ![]() ![]() ![]() ![]() ![]() ![]() + 12 x {(b ![]() ![]() + 8 x a x {(e + 3) 2 + 1 + MAX(e ![]() + 1,024 } ![]() + 3.5 + ![]() ![]() ![]() + ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() } ![]() ![]() K + ![]() i=1 |
Formula 2 (bytes) |
|
Formula 3 (bytes) |
|
Formula 4 (bytes) |
If you specify 1 in the pd_dbbuff_trace_level operand, add: + 320 x z
If you specify 1 in the pd_dbbuff_trace_level operand, add: + 640 x z |
Formula 5 (bytes) |
|
This subsection lists and describes the formulas used for calculating the shared memory used by a back-end server.
For details about the variables used in these formulas, see (4) below.
Condition | Shared memory calculation formula |
---|---|
Formula 1 (KB) |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() } ![]() ![]() M + ![]() i=1
![]() ![]() M + ![]() i=1 |
Formula 2 (bytes) |
|
Formula 3 (bytes) |
![]() ![]() ![]() ![]() ![]() ![]()
![]() ![]() ![]() ![]() ![]() ![]() |
Formula 4 (bytes) |
|
Formula 5 (bytes) |
If you specify 1 in the pd_dbbuff_trace_level operand, add: + 320 x z
If you specify 1 in the pd_dbbuff_trace_level operand, add: + 640 x z |
Formula 6 (bytes) |
|
Formula 7 (bytes) | 16 + 112 + (48 + 48 x Q) + (48 + 32 x R) |
Formula 8 (bytes) | 16 + 80 x S |
#1: Add this value if neither pd_max_list_user nor pd_max_list_count operand is 0.
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')