This subsection lists and describes the formulas used for calculating the shared memory used by a HiRDB/Single Server.
The following table shows Formulas 1 through 8.
Formula | Shared memory calculation formula |
---|---|
Formula 1 (KB) |
![]() + ![]() ![]() ![]() + ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() } ![]() ![]() D + ![]() 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) ![]() ![]()
![]() ![]() ![]() + ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() } ![]() D + ![]() i=1 Add this if the pd_def_buf_control_area_assign operand is specified as INITIAL or if the operand is omitted.
|
Formula 2 (bytes) |
5,072 x (e + 15) + ( ![]() ![]() ![]() + 112 x (p + 240)#5 + 96 x x + 32 x j + 132 x {19 + (e + 3) x 3} + 48 x n + 48 x {(e + 3) x 2 + 1 + MAX(5,(e + 3) ![]() + 68 x B + 144 x A#7 + 80 + 32 x g + 64#2 + 368#3 + (( ![]() ![]() ![]() ![]() ![]() ![]()
9,416 x (e + 15) + ( ![]() ![]() ![]() + ( ![]() ![]() ![]() + ( ![]() ![]() ![]() + 144 x x + 48 x j + 240 x {19 + (e + 3) x 3} + 64 x n + 96 x {(e + 3) x 2 + 1 + MAX(5,(e + 3) ![]() + 68 x B + 160 x A#8 + 96 + 48 x g + 64#2 + 448#3 + (( ![]() ![]() ![]() ![]() ![]() ![]() |
Formula 3 (bytes) |
|
Formula 4 (bytes) |
|
Formula 5 (bytes) |
|
Formula 6 (bytes) |
|
Formula 7 (bytes) | 16 + 112 + (48 + 48 x G) + (48 + 32 x H) |
Formula 8 (bytes) | 16 + 80 x I |
Formula 9 (bytes) | ![]() ![]() ![]() |
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')