Re: How to find "leaked" resources in Informix

Hi Ankur. Monitoring memory of onstat -g ses. session #RSAM total used id user tty pid hostname threads memory memory xx xxxx xxx xxx - xx 10000 7000 If memory leak occur, then session #RSAM total used id user tty pid hostname threads memory memory xx xxxx xxx xxx - xx 20000 9000 I suppose increase total memory or used memory. Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: anbharga@cisco.com (Tinku) >Reply-To: anbharga@cisco.com (Tinku) >To: informix-list@iiug.org >Subject: How to find "leaked" resources in Informix >Date: 24 Nov 2003 13:53:05 -0800 > >Hi > >My IDS version :9.2 >Platform Solaris 7 >Application in ESQL/C. > >We are having some problem in our application which seems to be >leading to some sort of a leak in Informix. So what happens is that >Informix IDS keeps allocating more and more "Virtual Shared memory" >segments there by increasing its size. Once the Informix reaches ~4G >size the server crashes (exits). > >Now the problem is that I am not able to figure out a way to find out >where or how are these resources being "leaked". > >can someone list down : > >a. Scenarios when Informix would allocate more virtual shared memory >(I mean what kind of queries etc > >b. What kind of resources are allocated in Informix via my >application (this is a ESQL/C application ) > >Any pointers are appreciated. > >Thanks >Ankur _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus sending to informix-list