Re: Mapping a session to an allocation of virtual memory

Zev, Onstat does not query any system tables (I assume you are talking of tables in the sysmaster database). It's the other way round. When you query a sysmaster table, online treats this as a special case and returns information directly from the appropriate shared memory structures instead of accessing normal database tables via the buffer pool. Onstat directly attaches to shared memory and accesses the same structures directly without the help of the database engine. In the case of "onstat -g mem" there seems to be no corresponding sysmaster table at all. Michael Zev Berezin wrote: > Thank You Michael. That is what I needed. > I didn't gather the output last time but now I know what to do. > BTW would you know the system table(s) onstat -g mem is querying? > > Thank You, > Zev Berezin > IBM Informix DBA > > > On 30 Jul 2003, at 8:40, Michael Mueller wrote: > > >>Use "onstat -g mem" when it happens again. It should show some very >>large pool. If the pool name in column 1 is a number than this is the >>session number (use onstat -g ses <num>). But it's possible that the >>memory was not allocated for a particular session. If you can send me >>the output I will try and tell you more. >> >>Michael >> >>Zev Berezin wrote: >> >>>Hi All, >>> >>> >>> >>>Version: IDS 7.31.UD5 - Tools 7.30.UC5 - Solaris 2.6 >>> >>>Yesterday a process dynamically allocated as much virtual memory as >>>allowed by SHMTOTAL - 48 new allocations in less than a minute! I >>>ran onmode -F and it worked as advertised, almost all segmetns were >>>freed. >>> >>>I tried to track the session that caused this. >>>onstat -u didn't return any users with large reads or writes.>>>I suppose since onmode -F was able to free so many segments, the >>>offending session was probably not active anyway. >>> >>>My question is how could I map a session to virtual memory usage. I >>>could use the ALARMPROGRAM to run onstat's if alarm event = 6. the >>>ran out of virtual shared memory code. >>> >>>I'm not sure however, how to specifically map virtual memory usage >>>to a specific session. >>> >>>Any help is appreciated. >>> >>> >>>TIA, >>>Zev Berezin >>>IBM Informix DBA >>> >>>sending to informix-list >> >> >>-- >> >>=== Michael Mueller ================== >>Tel. + 49 8171 63600 >>Fax. + 49 8171 63615 >>Web: http://www.mm.kay-mueller.de >> http://www.planets.kay-mueller.de >>====================================== >> >> > > > > sending to informix-list > -- === Michael Mueller ================== Tel. + 49 8171 63600 Fax. + 49 8171 63615 Web: http://www.mm.kay-mueller.de http://www.planets.kay-mueller.de ====================================== sending to informix-list