Re: Help, I may be losing my mind ( Shared memory )

What is your "Buffers" set to? OS? and if you can maybe helpful to do a "oninit -v" to see if you get any messages that would give a clue. On 8/21/06, Floyd Wellershaus <fwellers@yahoo.com> wrote: > > > Good point about the OS restricting the size of the segment that can be > grabbed. > But I am asking for 3.1gigs and it's giving me 4. > > Also, that doesn't explain why virtual is identical to resident. But it's a > good place to start. > > Thanks. > > > > > > > > ======================== > -<<Floyd Wellershaus>>- > Database Administrator > Unix Administrator > > email: fwellers@yahoo.com > Home: 703-430-0805 > Cell: 703-477-6045 > ======================== > http://www.one.org/ > > > ----- Original Message ---- > From: Eric Rowell <erowell@gmail.com> > To: informix-list@iiug.org > Sent: Monday, August 21, 2006 8:13:59 AM > Subject: Re: Help, I may be losing my mind ( Shared memory ) > > What OS and OS Version? Find out from the SA (if it isn't you) what > the SHM* values are. Maybe the values for the MIN values are set > extremely high? Also what is the MAX value? If set to 2.1G then that > would be why it was capped like it was. > > On 8/21/06, Floyd Wellershaus <fwellers@yahoo.com> wrote: > > > > > > I think I'm going crazy. I changed the SHMVIRTSIZE, LOCKS AND BUFFERS to > > take advantage of some new memory. > > Today, after reboot, I get these numbers and they make zero sense to me. > > > > 1) Why is my first virtual segment 4.2 G , when I have it configured to be > > 3.1G. > > 2) Why does the online log say it allocated a new virtual segment of 2.1G > > right after reboot > > -- Why is that new segment 2.1G, when I have SHMADD set for .5G. > > 3) Why does my resident segment EXACTLY match my Virtual segment ? > > > > These things make no sense to me the way I understand the way it's > supposed > > to work. What am I missing. > > > > Thanks. > > Floyd > > > > > > onstat -c|grep SHM> > > > SHMBASE 0x700000010000000 # Shared memory base address > > > > SHMVIRTSIZE 3145728 # initial virtual shared memory segment> > size > > > > SHMADD 524288 # Size of new shared> memory segments > > (Kbytes) > > > > SHMTOTAL 0 # Total shared memory (Kbytes). > 0=>unlimited> > > > # For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No. > > > > DUMPSHMEM 0 # Dump a copy of shared memory > > > > DD_HASHMAX 509> > > > [root@stella] Cur Dir ==> /u/floydw/working > > > > #onstat -g seg > > > > > > > > IBM Informix Dynamic Server Version 9.40.FC3 -- On-Line -- Up 01:15:46 > > -- 10579088 Kbytes> > > > > > > > Segment Summary: > > > > id key addr size ovhd class > blkused > > blkfree > > > > 6 1381451777 700000010000000 4294950912 > 549760 R 1048571 > > 1 > > > > 7 1381451778 700000110000000 4294950912 > 131728 V 1048527 > > 45 > > > > 8 1381451779 700000210000000 2242396160 > 69088 V 66964 > > 480496 > > > > 9 1381451780 7000002a0000000 688128 680 > M 135 > > 33 > > > > Total: - - 10832986112 - > - 2164197 > > 480575 > > > > > > > > > > > > 04:34:18 IBM Informix Dynamic Server Started. > > > > 04:34:25 Requested shared memory segment size rounded from 2189832KB to> > 2189840KB > > > > 04:34:25 Dynamically allocated new virtual shared memory segment (size > > 2189840KB) > > > > 04:34:25 VP pid=139618 priority fixed at 60, former = 92> > > > > > > > Mon Aug 21 04:34:26 2006 > > > > > > > > 04:34:26 Event alarms enabled. ALARMPROG = > > '/usr/online9.40.FC3/etc/alarmprogram.sh' > > > > 04:34:26 Booting Language <c> from module <> > > > > 04:34:26 Loading Module <CNULL> > > > > 04:34:26 Booting Language <builtin> from module <> > > > > 04:34:26 Loading Module <BUILTINNULL> > > > > 04:34:26 VP pid=78828 priority fixed at 60, former = 60 > > > > 04:34:26 VP pid=41660 priority fixed at 60, former = 60 > > > > 04:34:26 VP pid=102520 priority fixed at 60, former = 60 > > > > 04:34:26 VP pid=74652 priority fixed at 60, former = 60 > > > > 04:34:27 VP pid=172356 priority fixed at 60, former = 60 > > > > 04:34:27 VP pid=98402 priority fixed at 60, former = 60 > > > > 04:34:31 AIX MP latch code enabled > > > > 04:34:31 Dynamically allocated new message shared memory segment (size > > 672KB) > > > > 04:34:31 IBM Informix Dynamic Server Version 9.40.FC3 Software Serial> > Number AAA#B000000 > > > > 04:34:35 IBM Informix Dynamic Server Initialized -- Shared Memory> > Initialized. > > > > 04:34:35 Physical Recovery Started at Page (224:40479). > > > > 04:34:35 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. > > > > 04:34:35 Logical Recovery Started. > > > > 04:34:35 10 recovery worker threads will be started. > > > > 04:34:39 Logical Recovery has reached the transaction cleanup phase. > > > > 04:34:39 Logical Recovery Complete.> > > > 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > > > > > > > 04:34:40 Onconfig parameter LOCKS modified from 12000 to 100000. > > > > 04:34:40 Onconfig parameter BUFFERS modified from 888000 to 1776000. > > > > 04:34:40 Onconfig parameter NUMCPUVPS modified from 4 to 7. > > > > 04:34:40 Onconfig parameter SHMVIRTSIZE modified from 2621440 to 3145728. > > > > 04:34:40 Dataskip is now OFF for all dbspaces > > > > 04:34:43 TrapError set, errno = 25594, session_id = -1 > > > > 04:34:43 Checkpoint Completed: duration was 0 seconds. > > > > 04:34:43 Checkpoint loguniq 80675, logpos 0x24d018, timestamp: 1724409503> > > > > > > > (* segment locked in memory) > > > > > > > > > > ======================== > > -<<Floyd Wellershaus>>- > > Database Administrator > > Unix Administrator > > > > email: fwellers@yahoo.com > > Home: 703-430-0805 > > Cell: 703-477-6045 > > ======================== > > http://www.one.org/ > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >