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 7.
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) |
![]() 5072 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() + 112 ![]() + 96 ![]() ![]() ![]() ![]() + 48 ![]() ![]() ![]() ![]() + 68 ![]() ![]() ![]() + (( ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
![]() 9416 ![]() ![]() ![]() ![]() ![]() ![]() + ( ![]() ![]() ![]() ![]() ![]() ![]() + ( ![]() ![]() ![]() ![]() ![]() + 144 ![]() ![]() ![]() ![]() + 64 ![]() ![]() ![]() ![]() + 68 ![]() ![]() ![]() + (( ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Formula 3 (bytes) |
|
Formula 4 (bytes) |
![]() ![]() ![]()
|
Formula 5 (bytes) | 56 ![]() |
Formula 6 (bytes) |
|
Formula 7 (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')