The size of the memory required for each unit of a HiRDB/Parallel Server is the sum of the items listed in the following table.
Table 15-7 Size of memory required for each unit of a HiRDB/Parallel Server
Item | Required memory (KB) | |||
---|---|---|---|---|
Process private area | Process private area used by all unit controller processes |
![]() ![]() ![]()
![]() ![]() ![]()
![]() ![]() ![]()
![]() ![]() ![]() | ||
Process private area used by each server process#1, #2 | Front-end server | (N + h + m + p + q) x (b + 3) + 100 + y
![]() ![]() ![]() | ||
Dictionary server | pd_work_buff_mode=each specified | {(P + i + m + r + t) x (b + 3)} + (a + 9) x 2 + 100 + y + S
![]() ![]() ![]() | ||
pd_work_buff_ mode=pool specified or omitted | {(P + i + m + r + t) x (b + 3)} + a + 9 + ![]() ![]() ![]()
![]() ![]() ![]() | |||
Back-end server | pd_work_buff_ mode=each specified | {Q + g + (a + 9) x c + i + m + r + t} x (b + 3) + 100 + y + S
![]() ![]() ![]()
![]() ![]() ![]() | ||
pd_work_buff_ mode=pool specified or omitted |
+ ![]() ![]() ![]() x (b + 3) + 100 + n + y + S
+ ![]() ![]() ![]() x (b + 3) + 100 + n + y + S
![]() ![]() ![]()
![]() ![]() ![]() | |||
Shared memory | Space used by the unit controller in the unit controller shared memory | ![]() ![]() ![]() | ||
Space used by each server in the unit controller shared memory#1 | E | |||
Global buffer shared memory | F | |||
In-memory data processing shared memory | U | |||
Utility shared memory | U | |||
Security audit information buffer shared memory | ![]() ![]() ![]() ![]() Value specified for pd_audit_def_buffer_size | |||
Inter-process memory communication shared memory#3 | j x k |
#3: Add this value if you have specified PDIPC=MEMORY in the client environment definition. For details about the inter-process memory communication facility and client environment definitions, see the HiRDB Version 9 UAP Development Guide. If either the HiRDB server or the HiRDB client is in 32-bit mode, the system allocates the shared memory for the inter-process memory communication facility in the 32-bit address space.
(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)![]() |
(D + E + F) x number of dictionary servers + (D + E + F) x number of back-end servers + ![]() |
Variable | Value |
---|---|
D |
+ {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} |
E | 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 in server ![]() When 3,401 ![]() ![]() When 6,801 ![]() b2: When the record length of the status file for server < 4,096 ( ![]() ![]() ![]() ![]() ![]() + ( ![]() ![]() ![]() ![]() ![]() ![]() + 0.7) ![]() ![]() ![]() ![]() When 4,096 ![]() ![]() ![]() ![]() ![]() ![]() ![]() x (record length - 40) When 12,288 ![]() ![]() ![]() ![]() ![]() ![]() ![]() x (record length - 40) Y: When the number of RDAREAS in server ![]() When 10,201 ![]() ![]() When 5,672,511 ![]() ![]() When 11,334,821 ![]() |
F | If commit is specified in the pd_dbsync_point operand, add: + 112 x (value of pd_max_users# x 2 + 7) |
H | For back-end servers in which the number of HiRDB file system areas that store RDAREAs created in a HiRDB file system area that uses the raw I/O facility in a server is 1,001 or more, add:
![]() ![]() ![]()
![]() ![]() ![]() |
OS | Value of J | Value of K | Value of L | Value of M | Value of N | Value of P | Value of Q |
---|---|---|---|---|---|---|---|
Windows (32-bit mode) | 128,200 | 24,600 | 32,200 | 7,400 | 9,500 | 8,300 | 8,300 |
Windows Server 2003 (IPF) | 180,400 | 18,000 | 23,300 | 5,400 | 11,600 | 12,900 | 15,300 |
Windows (x64) | 170,300 | 39,200 | 52,500 | 13,000 | 12,200 | 12,200 | 14,000 |
Table 15-8 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 |