Re: Help, I may be losing my mind ( Shared memory )
Posted in 2006
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
>
>
>