Increasing user limit
Posted in 1994
PROBLEM
-------
We are hitting the number of users limit with Informix OnLine.
We have increased the relevant shared memory parameters as
directed by the Administrators manual. When Informix is shut
down and restarted so that the new values take effect "tbinit"
fails to start up with the following error :-
tbinit:shmat[EINVAL][22]:shared memory base address illegal
using 0x80500000 needs 0x80800000
tbinit:fatal error in shared memory creation.
The shared memory base address specified in the TBCONFIG file
as recommended for our machine is as follows :-
SHMBASE 0x80400000 # Shared memory base address
From what I understand this base address should not be altered.
Further details follow :-
UNIX VERSION
------------
SCO UNIX System V/386 Release 3.2v4.1
PROCESSOR
---------
i80486
INFORMIX VERSIONS
-----------------
Copyright (C) 1984-1991 Informix Software, Inc.
INFORMIX-OnLine Version 4.10.UG1
UNIX KERNEL SHARED MEMORY PARAMETERS
------------------------------------
*
* IPC Semaphores
*
10 entries in semaphore map (SEMMAP)
10 semaphore identifiers (SEMMNI)
60 semaphores in system (SEMMNS)
30 undo structures in system (SEMMNU)
25 max semaphores per id (SEMMSL)
10 max operations per semop call (SEMOPM)
10 max undo entries per process (SEMUME)
32767 semaphore maximum value (SEMVMX)
16384 adjust on exit max value (SEMAEM)
*
* IPC Shared Memory
*
1048576 max shared memory segment size (SHMMAX)
1 min shared memory segment size (SHMMIN)
100 shared memory identifiers (SHMMNI)
6 max attached shm segments per process (SHMSEG)
512 max in use shared memory (SHMALL) (4k clicks)
ORIGINAL SHARED MEMORY PARAMETERS (Before modification)
-------------------------------------------------------
SHARED MEMORY PARAMETERS
Page Size [ 2] Kbytes
Server Number [ 0] Server Name [white ]
Deadlock Timeout [ 60] Seconds
Forced Residency [N]
Number of Page Cleaners [ 2]
Physical Log Buffer Size [ 32] Kbytes
Logical Log Buffer Size [ 32] Kbytes
Max # of Logical Logs [ 4]
Max # of Users [ 32]
Max # of Locks [ 3500]
Max # of Buffers [ 200]
Max # of Chunks [ 8]
Max # of Open Tblspaces [ 320]
Max # of Dbspaces [ 8]
============
Shared memory size [ 848] Kbytes
MODIFIED SHARED MEMORY PARAMETERS
---------------------------------
SHARED MEMORY PARAMETERS
Page Size [ 2] Kbytes
Server Number [ 0] Server Name [white ]
Deadlock Timeout [ 60] Seconds
Forced Residency [N]
Number of Page Cleaners [ 2]
Physical Log Buffer Size [ 32] Kbytes
Logical Log Buffer Size [ 32] Kbytes
Max # of Logical Logs [ 4]
Max # of Users [ 64]
Max # of Locks [ 3500]
Max # of Buffers [ 256] ( 4 * Users )
Max # of Chunks [ 8]
Max # of Open Tblspaces [ 640] ( 10 * Users )
Max # of Dbspaces [ 8]
============
Shared memory size [ 1072] Kbytes
Any help regarding this problem would be much appreciated. Why
are things never as easy as the manual suggests :-)
--
----------------------------------------------------------------------------
Tony Desborough SRL Data Ltd
Software Programmer 1, Perren St
Email: tony@bilpin.co.uk LONDON, NW5 3ED