RE: Dynamically allocated new shared memory segment ???!!!

Yes, we have seen this with IUS 9.14 and the Webdatablade. Except in our case it would keep allocating until the server ran out of shared memory. In a web datablade page an MISQL statement tries to select from a table and gets back too many results for the webdatablade to handle. We would see behavior similar to this. Another strange side effect when this would happen, is we would run onstat -g seg and inspect the shared memory segments that were allocated andon each of the ones that were created within seconds the blkused was only 5 and blkfree was always very large. Until we rooted out the problem (the MISQL was too ambitious) we would run onmode -F to free these segments that were just created. Does anyone know if this is an informix bug? and if there is a fix? > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of jingker cheng > Sent: Thursday, August 19, 1999 8:43 AM > To: informix-list@iiug.org > Subject: Dynamically allocated new shared memory segment ???!!! > > > Dear ALL : > > Our system appear the following messages in seconds : > > 09:11:02 dynamically allocated new shared memory segment (size 8388608) > > 09:11:30 dynamically allocated new shared memory segment (size 8388608) > > 09:11:50 dynamically allocated new shared memory segment (size 8388608) > > 09:12:02 dynamically allocated new shared memory segment (size 8388608) > > 09:12:27 dynamically allocated new shared memory segment (size 8388608) > > 09:12:55 dynamically allocated new shared memory segment (size 8388608) > > 09:13:17 dynamically allocated new shared memory segment (size 8388608)> > ...... > ..... > ..... > > Does anyone know what kind of process will cause the results ? How can > I determine which process/session cause such results ? Thanks .... > Our system is HP-UX 10.20 and Informix On-Line Dynamic Server 7.22UC3 > > Jung-Hui Cheng > cheng@dbtel.com.tw > >