Parameter
|
Meaning
|
Optimal setting
|
SHMMNI
|
Maximum number of shared memory (SHM) identifiers
|
Current value or system default + (total OpenEdge memory requirement)/SHMMAX
|
SHMSEG
|
Maximum number of SHM segments a single process can attach
|
4–8
|
SHMALL
|
Maximum number of in-use SHM segments
|
System default; increase if many databases are active simultaneously; decreasing -B, -n, and -L startup parameters decreases SHM requirements
|
SHMMAX
|
Maximum SHM segment size
|
System default; increase if you get OpenEdge error 1135
Note: On the AIX platform, when starting a database with large shared memory requirements (for instance, when the -B exceeds the allotted system paging space), the system may become unstable if the PSALLOC= early environment variable is not set.
|
SEMMNI
|
Number of semaphore (SEM) IDs; each represents an array of SEMs
|
1 per active multi-user database
|
SEMMSL
|
Maximum number of semaphores per SEM ID
|
(Max-local-users-on-any-database + Max-#servers-on-any-database + 4)
|
SEMMNS
|
Total semaphores in the system
|
(SEMMSL x #active-databases)
|
SEMMNU
|
Number of semaphore undo structures
|
Same value as SEMMNS
|
MAXUMEM
|
Maximum address space for a single user
|
> = server size process + SHMSEG * SHMMAX
|
Server: Semaphore limit exceeded Server: **The server terminated with exit code (X) (800) |
Error code
|
Parameter to increase
|
1081
|
SEMMNU
|
1093
|
SEMMSL or SEMMNS
|
1130
|
SEMMSL
|
1131
|
SEMMNI and SEMMNS
|
1135
|
SHMMAX, MAXUMEM, and MAXUPOn the AIX platform, when starting a database with large shared memory requirements (for instance, when the -B exceeds the allotted system paging space), the system may become unstable if the PSALLOC= early environment variable is not set.
|
1137
|
SHMMNI
|
1175
|
SHMSEG, MAXUMEM, and MAXUP
|
1195
|
SEMMNS
|