The required memory used by HiRDB/Single Server is the sum of all the terms shown in the following table.
Table 15-2 Size of memory required for a HiRDB/Single Server
Item | Required memory (KB) | ||
---|---|---|---|
Process private area | Process private area used by all unit controller processes |
![]() ![]() ![]()
![]() ![]() ![]()
![]() ![]() ![]()
![]() ![]() ![]() | |
Process private area used by single server process#1 | pd_work_buff_ mode=each specified |
![]() ![]() ![]()
![]() ![]() ![]()
![]() ![]() ![]()
![]() ![]() ![]() | |
pd_work_buff_ mode=pool specified or omitted |
![]() ![]() ![]() ![]() ![]() ![]()
![]() ![]() ![]() ![]() ![]() ![]()
![]() ![]() ![]()
![]() ![]() ![]() | ||
Shared memory | Space used by the unit controller in the unit controller shared memory | ![]() ![]() ![]() | |
Space used by the Single Server in the unit controller shared memory | E | ||
Global buffer shared memory | F | ||
In-memory data processing shared memory | L | ||
Utility shared memory | T | ||
Security audit information buffer shared memory | ![]() ![]() ![]() ![]() Value specified for pd_audit_def_buffer_size | ||
Inter-process memory communication shared memory#2 | j x k |
(90 + 90 ![]() i=1 x value of pd_max_ard_process |
{(Number of files#1 + number of extensions#2) ![]() |
347 + Memory used by the work tables for management of the HiRDB file system area + Memory used by the system logs for management of the HiRDB file system area + 90 ![]() i=1 |
{(Number of files#1 + number of extensions#2) ![]() |
A + B
|
Variable | Value |
---|---|
A |
+ {48 x (value of pd_max_rdarea_no + number of tables) + 304} x (value of pd_max_users x 2 + 7)
+ {64 x (value of pd_max_rdarea_no + number of tables) + 512} x (value of pd_max_users x 2 + 7) Number of tables: 62 + MAX {value of pd_max_access_tables, 500} |
B | b1 x X + b2 x Y b1: When the record length of the server status file < 4,096 MAX(( ![]() ![]() ![]() ![]() ![]() + ( ![]() ![]() ![]() ![]() ![]() ![]() + 0.7) ![]() ![]() ![]() ![]() When 4,096 ![]() MAX( ![]() ![]() ![]() ![]() ![]() ![]() x (record length - 40) When 12,288 ![]() MAX( ![]() ![]() ![]() ![]() ![]() ![]() x (record length - 40) X: When the number of RDAREAs ![]() When 3,401 ![]() ![]() When 6,801 ![]() b2: When the record length of the server status file < 4,096 ( ![]() ![]() ![]() ![]() ![]() + ( ![]() ![]() ![]() ![]() ![]() ![]() + 0.7) ![]() ![]() ![]() ![]() When 4,096 ![]() ![]() ![]() ![]() ![]() ![]() ![]() x (record length - 40) When 12,288 ![]() ![]() ![]() ![]() ![]() ![]() ![]() x (record length - 40) Y: When the number of RDAREAs ![]() When 10,201 ![]() ![]() When 5,672,511 ![]() ![]() When 11,334,821 ![]() |
D |
![]() ![]() ![]()
![]() ![]() ![]() |
OS | Value of E | Value of F | Value of G |
---|---|---|---|
Windows (32-bit mode) | 207,100 | 11,100 | 14,100 |
Windows Server 2003 (IPF) | 167,000 | 5,400 | 11,700 |
Windows (x64) | 155,500 | 5,200 | 12,400 |
Table 15-3 Procedure for obtaining the number of work tables for each SQL statement
SQL statement | Procedure for obtaining the number of work tables |
---|---|
SELECT statement INSERT(-SELECT) statement | When none of 1-8 as follows are applicable: 0 When any of 1-8 as follows are applicable: Sum of the applicable values from 1-8
|
UPDATE statement DELETE statement | Number of columns with index defined in the search condition + 1 |
DROP SCHEMA statement DROP TABLE statement DROP INDEX statement CREATE INDEX statement REVOKE statement to revoke access privilege | 2 |