Hi,
I am facing problem with shared memory on AIX 5.2 with Informix 9.40. UC2
,My Informix server is crashing after 27 Hours after continuous stress test.
with the following error.
======================================
13:52:48 shmdt: errno = 22
13:52:48 out of virtual shared memory
13:52:54 shmat: [EMFILE][24]: out of shared memory segments, check system
SHMSEG
13:52:54 shmdt: errno = 22
13:52:54 out of virtual shared memory
13:52:57 I/O write chunk 1, pagenum 2763, pagecnt 1 --> errno = 4
13:53:00 Assert Failed: Dynamic Server must abort
13:53:00 IBM Informix Dynamic Server Version 9.40.UC2
13:53:00 Who: Session(1, informix@adolphus, 0, 4020c018)
Thread(7, main_loop(), 401db018, 1)
File: rslog.c Line: 3406
13:53:00 Results: Dynamic Server must abort
13:53:00 Action: Reinitialize shared memory
13:53:00 stack trace for pid 28728 written to /tmp/af.3efa9e9
13:53:00 See Also: /tmp/af.3efa9e9, shmem.3efa9e9.0
13:54:27 rslog.c, line 3406, thread 7, proc id 28728, Dynamic Server must
abort.
13:54:29 The Master Daemon Died
13:54:32 PANIC: Attempting to bring system down

======================================
Current setting for shared memory is:
SHMBASE 0x30000000L
SHMVIRTSIZE 65536
SHMADD 24576

system is Running on Informix 9.40.UC2 and AIX 5.2.
If anybody has idea how to tune this value . It will be great help.

- Thanks

sharad.

On Mon, 21 Jul 2003 06:24:43 -0400, sharad wrote:

The engine exceeded the maximum number of shared segments that AIX would
permit it to attach. Increase SHMVIRTSIZE to reduce the number of
segments needed steady state and increase SHMADD to reduce the number of
additional segments added at peak times. Also in normal operations you
would run onmode -F after any unusual peaks to release unneeded shared
memory segments. You may want to make a periodic onmode -F during the
stress test to simulate that.

Art S. Kagel


> Hi,
> I am facing problem with shared memory on AIX 5.2 with Informix 9.40.
> UC2
> ,My Informix server is crashing after 27 Hours after continuous stress
> test. with the following error.
> ====================================== 13:52:48 shmdt: errno = 22
> 13:52:48 out of virtual shared memory 13:52:54 shmat: [EMFILE][24]:
> out of shared memory segments, check system SHMSEG 13:52:54 shmdt:
> errno = 22
> 13:52:54 out of virtual shared memory 13:52:57 I/O write chunk 1,
> pagenum 2763, pagecnt 1 --> errno = 4 13:53:00 Assert Failed: Dynamic
> Server must abort 13:53:00 IBM Informix Dynamic Server Version 9.40.UC2
> 13:53:00 Who: Session(1, informix@adolphus, 0, 4020c018)
> Thread(7, main_loop(), 401db018, 1)
> File: rslog.c Line: 3406
> 13:53:00 Results: Dynamic Server must abort 13:53:00 Action:
> Reinitialize shared memory 13:53:00 stack trace for pid 28728 written
> to /tmp/af.3efa9e9 13:53:00 See Also: /tmp/af.3efa9e9, shmem.3efa9e9.0
> 13:54:27 rslog.c, line 3406, thread 7, proc id 28728, Dynamic Server
> must abort.
> 13:54:29 The Master Daemon Died
> 13:54:32 PANIC: Attempting to bring system down
>
> ====================================== Current setting for shared memory
> is: SHMBASE 0x30000000L
> SHMVIRTSIZE 65536
> SHMADD 24576
>
> system is Running on Informix 9.40.UC2 and AIX 5.2. If anybody has idea
> how to tune this value . It will be great help.
>
> - Thanks
>
> sharad.