The size of the memory required for a HiRDB/Single Server is the sum of the items listed in Table 16-2.
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-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 process1 | 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 | ||
Utility shared memory | t | ||
Security audit information buffer shared memory | ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() | ||
Inter-process memory communication shared memory2 | j ![]() |
(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)![]() ![]() |
A + B![]() + 112 ![]() ![]() ![]() + C ![]() + D |
Variable | Value |
---|---|
A |
![]() + {48 ![]() ![]() ![]()
![]() + {64 ![]() ![]() ![]() Number of tables: Number of data dictionary tables + MAX {value of pd_max_access_tables, 500} |
B | 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 ![]() When 3401 ![]() ![]() When 6801 ![]() b2: When the record length of the server status file < 4096 ( ![]() ![]() ![]() ![]() ![]() + ( ![]() ![]() ![]() ![]() ![]() ![]() ![]() + 0.7) ![]() ![]() ![]() ![]() ![]() ![]() When 4096 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() When 12288 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Y: When the number of RDAREAs ![]() When 10201 ![]() ![]() When 5672511 ![]() ![]() When 11334821 ![]() |
C |
![]() ![]() ![]()
![]() ![]() ![]() |
D |
![]() ![]() ![]() ![]()
![]() ![]() ![]() ![]() |
OS | Value of E | Value of F | Value of G |
---|---|---|---|
HP-UX (32-bit mode) | 84,100 | 2,700 | 4,800 |
HP-UX (32-bit-mode POSIX library version) | 129,600 | 2,800 | 4,900 |
HP-UX (64-bit mode) | 86,800 | 2,800 | 5,300 |
HP-UX (IPF) | 161,300 | 2,800 | 5,100 |
AIX 5L (32-bit mode) | 71,800 | 2,200 | 5,100 |
AIX 5L (32-bit-mode POSIX library version) | 131,400 | 4,900 | 8,000 |
AIX 5L (64-bit mode) | 82,100 | 2,700 | 6,700 |
Solaris (32-bit mode) | 74,800 | 1,500 | 3,100 |
Solaris (32-bit-mode POSIX library version) | 12,200 | 1,700 | 3,300 |
Solaris (64-bit mode) | 86,600 | 1,900 | 3,800 |
Linux (32-bit mode) | 96,300 | 3,300 | 5,100 |
Linux (IPF) | 168,800 | 4,600 | 6,900 |
Linux (EM64T) | 150,500 | 8,000 | 11,200 |
Table 16-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 |