The size of the memory required for each unit of a HiRDB/Parallel Server is the sum of the items listed in Table 16-7.
For details about the value specified in the shmmax operating system parameter (for Solaris, shmsys:shminfo_shmmax; for Linux, SHMMAX), see 21. Specifying OS Parameters.
Table 16-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 process1, 2 | Front-end server | (N + h + m + p + q) ![]() | ||
Dictionary server | pd_work_buff_mode=each specified | {(P + i + m + r + t) ![]() (a + 9) ![]() | ||
pd_work_buff_ mode=pool specified or omitted | {(P + i + m + r + t) ![]() + a + 9 + ![]() ![]() ![]() ![]() | |||
Back-end server | pd_work_buff_ mode=each specified | {Q + g + (a + 9) ![]() ![]() | ||
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 each server in the unit controller shared memory1 | e | |||
Global buffer shared memory | f | |||
Utility shared memory | u | |||
Security audit information buffer shared memory | ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() | |||
Inter-process memory communication shared memory3 | j ![]() |
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 manual HiRDB Version 8 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 ![]() |
{(Number of files1 + number of extensions2)![]() ![]() |
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 files1 + number of extensions2)![]() ![]() |
(D + E + F) ![]() ![]() ![]() |
Variable | Value |
---|---|
D |
![]() + {48 ![]() ![]() ![]()
![]() + {64 ![]() ![]() ![]() Number of tables: Number of data dictionary tables + MAX {value of pd_max_access_tables, 500} |
E | b1![]() ![]() b1: When the record length of the server status file < 4096 MAX(( ![]() ![]() ![]() ![]() ![]() + ( ![]() ![]() ![]() ![]() ![]() ![]() ![]() + 0.7) ![]() ![]() ![]() ![]() ![]() ![]() When 4096 ![]() MAX( ![]() ![]() ![]() ![]() ![]() ![]() ![]() When 12288 ![]() MAX( ![]() ![]() ![]() ![]() ![]() ![]() ![]() X: When the number of RDAREAS in server ![]() When 3401 ![]() ![]() When 6801 ![]() b2: When the record length of the status file for server < 4096 ( ![]() ![]() ![]() ![]() ![]() + ( ![]() ![]() ![]() ![]() ![]() ![]() ![]() + 0.7) ![]() ![]() ![]() ![]() ![]() ![]() When 4096 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() When 12288 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Y: When the number of RDAREAS in server ![]() When 10201 ![]() ![]() When 5672511 ![]() ![]() When 11334821 ![]() |
F | If commit is specified in the pd_dbsync_point operand, add: + 112 ![]() ![]() |
G | If 1 or a greater value is specified in the pd_inner_replica_control operand, add:
![]() ![]() ![]()
![]() ![]() ![]() |
H | For a back-end server, if the number of RDAREA storage areas created in a character special file is 1001 or greater in the server, add:
![]() ![]() ![]() ![]()
![]() ![]() ![]() ![]() |
OS | Value of J | Value of K | Value of L | Value of M | Value of N | Value of P | Value of Q |
---|---|---|---|---|---|---|---|
HP-UX (32-bit mode) | 74,300 | 9,300 | 12,100 | 2,700 | 4,100 | 3,500 | 4,200 |
HP-UX (32-bit-mode POSIX library version) | 120,700 | 9,700 | 12,300 | 2,800 | 4,200 | 3,600 | 4,300 |
HP-UX (64-bit mode) | 75,800 | 10,200 | 13,000 | 2,800 | 4,400 | 3,900 | 5,400 |
HP-UX (IPF) | 154,300 | 10,300 | 13,100 | 2,700 | 4,700 | 5,300 | 7,400 |
AIX 5L (32-bit mode) | 64,200 | 8,500 | 10,800 | 2,200 | 4,800 | 4,300 | 5,100 |
AIX 5L (32-bit-mode POSIX library version) | 116,900 | 16,700 | 19,200 | 5,000 | 7,600 | 7,400 | 8,300 |
AIX 5L (64-bit mode) | 72,100 | 10,300 | 13,200 | 2,800 | 6,300 | 5,700 | 7,300 |
Solaris (32-bit mode) | 69,600 | 6,000 | 7,500 | 1,400 | 2,600 | 2,100 | 4,100 |
Solaris (32-bit-mode POSIX library version) | 117,800 | 6,700 | 6,100 | 1,600 | 2,800 | 2,300 | 4,200 |
Solaris (64-bit mode) | 80,100 | 7,500 | 9,500 | 1,900 | 3,300 | 2,700 | 6,100 |
Linux (32-bit mode) | 84,400 | 11,500 | 15,000 | 3,300 | 4,400 | 3,900 | 3,800 |
Linux (IPF) | 151,600 | 151,600 | 20,500 | 4,700 | 6,300 | 6,800 | 7,300 |
Linux (EM64T) | 121,100 | 26,300 | 35,200 | 7,600 | 11,100 | 12,900 | 12,500 |
Table 16-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 |