Assertion failure in IDS 7.31 UC3

Hi, Ref: Informix Dynamic Server 7.31 UC3 on AIX 4.3.2 We had a server crash on one of our customer sites. The server was the Primary of a replicated pair (using HDR). According to the AF file (/tmp/af.3f0cd59), the session id at the time of the crash was 2, an informix daemon(?), and the thread id was 8, an sm_poll thread. On doing an "oninit" the server came back and all was well. My question is: can someone help me identify what actually brought the server down? Thanks! Alanoly Andrews. ======================= Some relevant parts of the AF file are given below: -------------- 15:58:01 15:58:01 Informix Dynamic Server Version 7.31.UC3 Software SerialNumber ACM #J709735 15:58:01 Assert Failed: No Exception Handler 15:58:01 Who: Session(2, informix@, 0, 0) Thread(8, sm_poll, 0, 1) File: mtex.c Line: 446 15:58:01 Results: Exception Caught. Type: MT_EX_OS, Context: mem 15:58:01 Action: Please notify Informix Technical Support. -------------- /apps/informix/bin/onstat -g ath: Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up 9 days 08:30 :20 -- 503872 Kbytes Threads: tid tcb rstcb prty status vp-class name 2 50142128 0 2 sleeping forever 5lio lio vp 0 3 50142384 0 2 sleeping forever 6pio pio vp 0 4 501425e0 0 2 sleeping forever 7aio aio vp 0 5 5014283c 0 2 sleeping forever 8msc msc vp 0 6 50142aec 0 2 sleeping forever 9aio aio vp 1 7 50142e80 5004e014 4 sleeping secs: 1 4cpu main_loop() *8 501436e8 0 2 running 1cpu sm_poll 9 5014b32c 0 2 running 3cpu sm_poll 10 5016fe28 0 2 running 10soc soctcppoll 11 5018b430 0 3 sleeping forever 3cpu sm_listen 12 5018bedc 0 2 sleeping secs: 1 1cpu sm_discon 13 5018e584 0 3 sleeping forever 3cpu sm_listen 14 5018f010 0 2 sleeping secs: 1 4cpu sm_discon 15 5018f5a0 0 3 sleeping forever 1cpu soctcplst ............ ............ ------------------ /apps/informix/bin/onstat -g stk 8 light: Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up 9 days 08:30 :20 -- 503872 Kbytes Stack for thread: 8 sm_poll base: 0x5021a014 len: 36864 pc: 0x1001e538 tos: 0x502220e8state: running vp: 1 0x1001e538 (oninit)mt_system(0x50222590, 0x200037dc, 0x50006480, 0x3, 0x0, 0x502 22188, 0x2, 0x0) 0x1002d138 (oninit)afhandler(0x50222834, 0x20003a98, 0x20003954, 0x20002e1c, 0x0 , 0x50143850, 0x6006c3db, 0x0) 0x1002db3c (oninit)mt_ex_throw_sig(0x1, 0x20002e1c, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0 ) 0x10015f00 (oninit)afsig_segv(0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0) 0x00000000 ---------------------------------- /apps/informix/bin/onstat -g ses 2: Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up 9 days 08:30 :21 -- 503872 Kbytes session #RSAM total used id user tty pid hostname threads memory memory 2 informix - 0 - 0 8192 5696 Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 2 V 50218014 8192 2496 9 1 name free used name free used overhead 0 108 scb 0 80 gentcb 0 536 ostcb 0 32 sqscb 0 4900 fragman 0 40 ------------------------- /apps/informix/bin/onstat -g sql 2: Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up 9 days 08:30 :21 -- 503872 Kbytes --------------------------- MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 3 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vpsto one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 200000 # Maximum number of locks BUFFERS 80000 # Maximum number of shared buffers NUMAIOVPS 2 # Number of IO vps PHYSBUFF 64 # Physical log buffer size (Kbytes) LOGBUFF 64 # Logical log buffer size (Kbytes)LOGSMAX 100 # Maximum number of logical log files CLEANERS 2 # Number of buffer cleaner processes SHMBASE 0x30000000 # Shared memory base address SHMVIRTSIZE 100000 # initial virtual shared memory segmentsize SHMADD 64000 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 300 # Check point interval (in sec) LRUS 13 # Number of LRU queues LRU_MAX_DIRTY 10 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 5 # LRU percent dirty end cleaning limit LTXHWM 50 # Long transaction high water markpercentage LTXEHWM 60 # Long transaction high water mark (exclusive) TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 64 # Stack size (Kbytes) ====================================== Sent via Deja.com http://www.deja.com/ Before you buy.

That was one of the shared memory poll listener threads. It may be a bug or it may just be that a shared memory application overwrote some data structure that the engine needed and crashed it. Try changing your shared memory connection to stream pipe for a while and see if some app crashes instead. Art S. Kagel alanolya@planmatics.com wrote: > Hi, > > Ref: Informix Dynamic Server 7.31 UC3 on AIX 4.3.2 > > We had a server crash on one of our customer sites. The server > was the Primary of a replicated pair (using HDR). According to > the AF file (/tmp/af.3f0cd59), the session id at the time of the > crash was 2, an informix daemon(?), and the thread id was 8, an > sm_poll thread. On doing an "oninit" the server came back and all was > well. My question is: can someone help me identify what actually > brought the server down? > > Thanks! > > Alanoly Andrews. > > ======================= > > Some relevant parts of the AF file are given below: > > -------------- > > 15:58:01 > 15:58:01 Informix Dynamic Server Version 7.31.UC3 Software Serial> Number ACM > #J709735 > > 15:58:01 Assert Failed: No Exception Handler > 15:58:01 Who: Session(2, informix@, 0, 0) > Thread(8, sm_poll, 0, 1) > File: mtex.c Line: 446 > 15:58:01 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 15:58:01 Action: Please notify Informix Technical Support. > --------------> > /apps/informix/bin/onstat -g ath: > > Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up 9 > days 08:30 > :20 -- 503872 Kbytes > > Threads: > tid tcb rstcb prty status vp-class name > 2 50142128 0 2 sleeping forever 5lio lio > vp 0 > 3 50142384 0 2 sleeping forever 6pio pio > vp 0 > 4 501425e0 0 2 sleeping forever 7aio aio > vp 0 > 5 5014283c 0 2 sleeping forever 8msc msc > vp 0 > 6 50142aec 0 2 sleeping forever 9aio aio > vp 1 > 7 50142e80 5004e014 4 sleeping secs: 1 4cpu > main_loop() > *8 501436e8 0 2 running 1cpu > sm_poll > 9 5014b32c 0 2 running 3cpu > sm_poll > 10 5016fe28 0 2 running 10soc > soctcppoll > 11 5018b430 0 3 sleeping forever 3cpu > sm_listen > 12 5018bedc 0 2 sleeping secs: 1 1cpu > sm_discon > 13 5018e584 0 3 sleeping forever 3cpu > sm_listen > 14 5018f010 0 2 sleeping secs: 1 4cpu > sm_discon > 15 5018f5a0 0 3 sleeping forever 1cpu > soctcplst > ............ > ............ > ------------------ > > /apps/informix/bin/onstat -g stk 8 light: > > Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up 9 > days 08:30 > :20 -- 503872 Kbytes > > Stack for thread: 8 sm_poll > base: 0x5021a014 > len: 36864 > pc: 0x1001e538 > tos: 0x502220e8> state: running > vp: 1 > > 0x1001e538 (oninit)mt_system(0x50222590, 0x200037dc, 0x50006480, 0x3, > 0x0, 0x502 > 22188, 0x2, 0x0) > 0x1002d138 (oninit)afhandler(0x50222834, 0x20003a98, 0x20003954, > 0x20002e1c, 0x0 > , 0x50143850, 0x6006c3db, 0x0) > 0x1002db3c (oninit)mt_ex_throw_sig(0x1, 0x20002e1c, 0x0, 0x0, 0x0, 0x0, > 0x0, 0x0 > ) > 0x10015f00 (oninit)afsig_segv(0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0) > 0x00000000 > > ---------------------------------- > > /apps/informix/bin/onstat -g ses 2: > > Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up 9 > days 08:30 > :21 -- 503872 Kbytes > > session #RSAM total used > id user tty pid hostname threads memory memory > 2 informix - 0 - 0 8192 5696 > > Memory pools count 1 > name class addr totalsize freesize #allocfrag #freefrag > 2 V 50218014 8192 2496 9 1 > > name free used name free used > overhead 0 108 scb 0 80 > gentcb 0 536 ostcb 0 32 > sqscb 0 4900 fragman 0 40 > > ------------------------- > > /apps/informix/bin/onstat -g sql 2: > > Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up 9 > days 08:30 > :21 -- 503872 Kbytes > > --------------------------- > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-> processor > NUMCPUVPS 3 # Number of user (cpu) vps > SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps> to one > > NOAGE 1 # Process aging > AFF_SPROC 0 # Affinity start processor > AFF_NPROCS 0 # Affinity number of processors> > # Shared Memory Parameters > > LOCKS 200000 # Maximum number of locks > BUFFERS 80000 # Maximum number of shared buffers > NUMAIOVPS 2 # Number of IO vps > PHYSBUFF 64 # Physical log buffer size (Kbytes) > LOGBUFF 64 # Logical log buffer size (Kbytes)> LOGSMAX 100 # Maximum number of logical log files > CLEANERS 2 # Number of buffer cleaner processes > SHMBASE 0x30000000 # Shared memory base address > SHMVIRTSIZE 100000 # initial virtual shared memory segment> size > SHMADD 64000 # Size of new shared memory segments > (Kbytes) > SHMTOTAL 0 # Total shared memory (Kbytes). > 0=>unlimited > CKPTINTVL 300 # Check point interval (in sec) > LRUS 13 # Number of LRU queues > LRU_MAX_DIRTY 10 # LRU percent dirty begin cleaning limit > LRU_MIN_DIRTY 5 # LRU percent dirty end cleaning limit > LTXHWM 50 # Long transaction high water mark> percentage > LTXEHWM 60 # Long transaction high water mark > (exclusive) > TXTIMEOUT 0x12c # Transaction timeout (in sec) > STACKSIZE 64 # Stack size (Kbytes)> > ====================================== > > Sent via Deja.com http://www.deja.com/ > Before you buy.

Thanks Art, for the feedback. But I do think memory overwrite is unlikely as the cause of the crash. The system has 3 GB of Memory and Informix uses up about 600 Mb. The only other application running is our own Program which does not specifically make Memory requests, but lets the OS do it. And is it likely that the OS will overwrite Informix's space when there is so much other space available? Alanoly Andrews. In article <391B10B2.1CA2A79@bloomberg.net>, "Art S. Kagel" <kagel@bloomberg.net> wrote: > That was one of the shared memory poll listener threads. It may be a bug or it > > may just be that a shared memory application overwrote some data structure > that the engine needed and crashed it. Try changing your shared memory > connection to stream pipe for a while and see if some app crashes instead. > > Art S. Kagel > > alanolya@planmatics.com wrote: > > > Hi, > > > > Ref: Informix Dynamic Server 7.31 UC3 on AIX 4.3.2 > > > > We had a server crash on one of our customer sites. The server > > was the Primary of a replicated pair (using HDR). According to > > the AF file (/tmp/af.3f0cd59), the session id at the time of the > > crash was 2, an informix daemon(?), and the thread id was 8, an > > sm_poll thread. On doing an "oninit" the server came back and all was > > well. My question is: can someone help me identify what actually > > brought the server down? > > > > Thanks! > > > > Alanoly Andrews. > > > > ======================= > > > > Some relevant parts of the AF file are given below: > > > > -------------- > > > > 15:58:01 > > 15:58:01 Informix Dynamic Server Version 7.31.UC3 SoftwareSerial > > Number ACM > > #J709735 > > > > 15:58:01 Assert Failed: No Exception Handler > > 15:58:01 Who: Session(2, informix@, 0, 0) > > Thread(8, sm_poll, 0, 1) > > File: mtex.c Line: 446 > > 15:58:01 Results: Exception Caught. Type: MT_EX_OS, Context: mem > > 15:58:01 Action: Please notify Informix Technical Support. > > --------------> > > > /apps/informix/bin/onstat -g ath: > > > > Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up 9 > > days 08:30 > > :20 -- 503872 Kbytes > > > > Threads: > > tid tcb rstcb prty status vp-class name > > 2 50142128 0 2 sleeping forever 5lio lio > > vp 0 > > 3 50142384 0 2 sleeping forever 6pio pio > > vp 0 > > 4 501425e0 0 2 sleeping forever 7aio aio > > vp 0 > > 5 5014283c 0 2 sleeping forever 8msc msc > > vp 0 > > 6 50142aec 0 2 sleeping forever 9aio aio > > vp 1 > > 7 50142e80 5004e014 4 sleeping secs: 1 4cpu > > main_loop() > > *8 501436e8 0 2 running 1cpu > > sm_poll > > 9 5014b32c 0 2 running 3cpu > > sm_poll > > 10 5016fe28 0 2 running 10soc > > soctcppoll > > 11 5018b430 0 3 sleeping forever 3cpu > > sm_listen > > 12 5018bedc 0 2 sleeping secs: 1 1cpu > > sm_discon > > 13 5018e584 0 3 sleeping forever 3cpu > > sm_listen > > 14 5018f010 0 2 sleeping secs: 1 4cpu > > sm_discon > > 15 5018f5a0 0 3 sleeping forever 1cpu > > soctcplst > > ............ > > ............ > > ------------------ > > > > /apps/informix/bin/onstat -g stk 8 light: > > > > Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up 9 > > days 08:30 > > :20 -- 503872 Kbytes > > > > Stack for thread: 8 sm_poll > > base: 0x5021a014 > > len: 36864 > > pc: 0x1001e538 > > tos: 0x502220e8> > state: running > > vp: 1 > > > > 0x1001e538 (oninit)mt_system(0x50222590, 0x200037dc, 0x50006480, 0x3, > > 0x0, 0x502 > > 22188, 0x2, 0x0) > > 0x1002d138 (oninit)afhandler(0x50222834, 0x20003a98, 0x20003954, > > 0x20002e1c, 0x0 > > , 0x50143850, 0x6006c3db, 0x0) > > 0x1002db3c (oninit)mt_ex_throw_sig(0x1, 0x20002e1c, 0x0, 0x0, 0x0, 0x0, > > 0x0, 0x0 > > ) > > 0x10015f00 (oninit)afsig_segv(0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0) > > 0x00000000 > > > > ---------------------------------- > > > > /apps/informix/bin/onstat -g ses 2: > > > > Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up 9 > > days 08:30 > > :21 -- 503872 Kbytes > > > > session #RSAM total used > > id user tty pid hostname threads memory memory > > 2 informix - 0 - 0 8192 5696 > > > > Memory pools count 1 > > name class addr totalsize freesize #allocfrag #freefrag > > 2 V 50218014 8192 2496 9 1 > > > > name free used name free used > > overhead 0 108 scb 0 80 > > gentcb 0 536 ostcb 0 32 > > sqscb 0 4900 fragman 0 40 > > > > ------------------------- > > > > /apps/informix/bin/onstat -g sql 2: > > > > Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up 9 > > days 08:30 > > :21 -- 503872 Kbytes > > > > --------------------------- > > > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-> > processor > > NUMCPUVPS 3 # Number of user (cpu) vps > > SINGLE_CPU_VP 0 # If non-zero, limit number of cpuvps > > to one > > > > NOAGE 1 # Process aging > > AFF_SPROC 0 # Affinity start processor > > AFF_NPROCS 0 # Affinity number of processors> > > > # Shared Memory Parameters > > > > LOCKS 200000 # Maximum number of locks > > BUFFERS 80000 # Maximum number of shared buffers > > NUMAIOVPS 2 # Number of IO vps > > PHYSBUFF 64 # Physical log buffer size (Kbytes) > > LOGBUFF 64 # Logical log buffer size (Kbytes)> > LOGSMAX 100 # Maximum number of logical log files > > CLEANERS 2 # Number of buffer cleaner processes > > SHMBASE 0x30000000 # Shared memory base address > > SHMVIRTSIZE 100000 # initial virtual shared memorysegment > > size > > SHMADD 64000 # Size of new shared memory segments > > (Kbytes) > > SHMTOTAL 0 # Total shared memory (Kbytes). > > 0=>unlimited > > CKPTINTVL 300 # Check point interval (in sec) > > LRUS 13 # Number of LRU queues > > LRU_MAX_DIRTY 10 # LRU percent dirty begin cleaninglimit > > LRU_MIN_DIRTY 5 # LRU percent dirty end cleaninglimit > > LTXH

alanolya@my-deja.com wrote: > Thanks Art, for the feedback. But I do think memory overwrite is > unlikely as the cause of the crash. The system has 3 GB of Memory > and Informix uses up about 600 Mb. The only other application running > is our own Program which does not specifically make Memory requests, > but lets the OS do it. And is it likely that the OS will overwrite > Informix's space when there is so much other space available? Not the OS or other applications. But apps that query the Informix server which are connected using shared memory connections. If you read the Administrator's Guide and other docs you will see that it is possible for an application which is connected to the server via a shared memory connection to corrupt shared memory data structures that cannot be repaired by the running engine causing the server to shut down and that it is also possible to cause damage that the engine will not immediately recognize which will at some later point cause the engine to crash. Since it was a shared memory poll thread (sm_poll) which crashed the server such corruption is the likely cause. Now it is still possible that a server bug caused the corruption but a shared memory connected client is the more likely culprit. These apps have to access the shared memory segments that the engine uses in order to pass data back and forth so they need write permissions on the segment. An array reference that overruns the bounds of the array, a pointer reference using an uninitialized local pointer, or a free of memory not malloc'd or already free'd will all unintentionally overwrite memory and possibly the shared memory, which is mapped into the task's address space, included. If you change the connections to ipcpip then the shared memory segments will not be linked into the tasks' address space and the errant memory references may be illegal resulting in one of your apps crashing so you can diagnose the memory overrun and stop crashing your database engine. Art S. Kagel > Alanoly Andrews. > > In article <391B10B2.1CA2A79@bloomberg.net>, > "Art S. Kagel" <kagel@bloomberg.net> wrote: > > That was one of the shared memory poll listener threads. It may be a > bug or it > > > > may just be that a shared memory application overwrote some data > structure > > that the engine needed and crashed it. Try changing your shared > memory > > connection to stream pipe for a while and see if some app crashes > instead. > > > > Art S. Kagel > > > > alanolya@planmatics.com wrote: > > > > > Hi, > > > > > > Ref: Informix Dynamic Server 7.31 UC3 on AIX 4.3.2 > > > > > > We had a server crash on one of our customer sites. The server > > > was the Primary of a replicated pair (using HDR). According to > > > the AF file (/tmp/af.3f0cd59), the session id at the time of the > > > crash was 2, an informix daemon(?), and the thread id was 8, an > > > sm_poll thread. On doing an "oninit" the server came back and all > was > > > well. My question is: can someone help me identify what actually > > > brought the server down? > > > > > > Thanks! > > > > > > Alanoly Andrews. > > > > > > ======================= > > > > > > Some relevant parts of the AF file are given below: > > > > > > -------------- > > > > > > 15:58:01 > > > 15:58:01 Informix Dynamic Server Version 7.31.UC3 Software> Serial > > > Number ACM > > > #J709735 > > > > > > 15:58:01 Assert Failed: No Exception Handler > > > 15:58:01 Who: Session(2, informix@, 0, 0) > > > Thread(8, sm_poll, 0, 1) > > > File: mtex.c Line: 446 > > > 15:58:01 Results: Exception Caught. Type: MT_EX_OS, Context: mem > > > 15:58:01 Action: Please notify Informix Technical Support. > > > --------------> > > > > > /apps/informix/bin/onstat -g ath: > > > > > > Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up > 9 > > > days 08:30 > > > :20 -- 503872 Kbytes > > > > > > Threads: > > > tid tcb rstcb prty status vp-class > name > > > 2 50142128 0 2 sleeping forever 5lio > lio > > > vp 0 > > > 3 50142384 0 2 sleeping forever 6pio > pio > > > vp 0 > > > 4 501425e0 0 2 sleeping forever 7aio > aio > > > vp 0 > > > 5 5014283c 0 2 sleeping forever 8msc > msc > > > vp 0 > > > 6 50142aec 0 2 sleeping forever 9aio > aio > > > vp 1 > > > 7 50142e80 5004e014 4 sleeping secs: 1 4cpu > > > main_loop() > > > *8 501436e8 0 2 running 1cpu > > > sm_poll > > > 9 5014b32c 0 2 running 3cpu > > > sm_poll > > > 10 5016fe28 0 2 running 10soc > > > soctcppoll > > > 11 5018b430 0 3 sleeping forever 3cpu > > > sm_listen > > > 12 5018bedc 0 2 sleeping secs: 1 1cpu > > > sm_discon > > > 13 5018e584 0 3 sleeping forever 3cpu > > > sm_listen > > > 14 5018f010 0 2 sleeping secs: 1 4cpu > > > sm_discon > > > 15 5018f5a0 0 3 sleeping forever 1cpu > > > soctcplst > > > ............ > > > ............ > > > ------------------ > > > > > > /apps/informix/bin/onstat -g stk 8 light: > > > > > > Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up > 9 > > > days 08:30 > > > :20 -- 503872 Kbytes > > > > > > Stack for thread: 8 sm_poll > > > base: 0x5021a014 > > > len: 36864 > > > pc: 0x1001e538 > > > tos: 0x502220e8> > > state: running > > > vp: 1 > > > > > > 0x1001e538 (oninit)mt_system(0x50222590, 0x200037dc, 0x50006480, > 0x3, > > > 0x0, 0x502 > > > 22188, 0x2, 0x0) > > > 0x1002d138 (oninit)afhandler(0x50222834, 0x20003a98, 0x20003954, > > > 0x20002e1c, 0x0 > > > , 0x50143850, 0x6006c3db, 0x0) > > > 0x1002db3c (oninit)mt_ex_throw_sig(0x1, 0x20002e1c, 0x0, 0x0, 0x0, > 0x0, > > > 0x0, 0x0 > > > ) > > > 0x10015f00 (oninit)afsig_segv(0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, > 0x0) > > > 0x00000000 > > > > > > ---------------------------------- > > > > > > /apps/informix/bin/onstat -g ses 2: > > > > > > Informix Dynamic Server Version 7.31.UC3 -- On-Line (Prim) -- Up > 9 > > > days 08:30 > > > :21 -- 503872 Kbytes > > > > > > session #RSAM total used > > > id user tty pid hostname threads memory memory > > > 2 informix - 0 - 0 8192 5696 > > > > > > Memory pools count 1 > > > name class addr totalsize freesize #allocfrag #freefrag > > > 2 V 50218014 8192 2496 9 1 > > > > > > name free used name free > used > > > overhead 0 108 scb 0 > 80 > > > gentcb 0 536 ostcb 0 > 32 > > > sqscb 0

Ohhhh dear .....