Hello,

I was wondering if there is any way for Informix to alert us if it
"Dynamically allocated new virtual shared memory segment". I tried
getting the ALARMPROGRAM to alert, though it seems that this action
does not trigger the ALARMPROGRAM. Any ideas?

16:17:26 Requested shared memory segment size rounded from 640000KB
to 655360KB
16:17:26 Shared memory segment will use large pages with intimate
shared memory (ISM) if available
16:17:27 Dynamically allocated new virtual shared memory segment
(size 655360KB)
16:17:27 Memory sizes:resident:9961472 KB, virtual:20185088 KB, no
SHMTOTAL limit

--David

Unfortunately it is not considered a significant "event" for the
alarmprogram. The only way would be to poll the message log for the string.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Wed, Jun 9, 2010 at 3:32 PM, Dave <in4mixdba (AT) gmail (DOT) com> wrote:

Art,

Thank you. I would consider it a significant event because if I see the
Server Dynamically adding new virtual memory segments that means I need to
tweak SHMVIRTSIZE and add more memory to the initial segment.

--David

On Wed, Jun 9, 2010 at 3:52 PM, Art Kagel <art.kagel (AT) gmail (DOT) com> wrote:

Personally I agree. Call IBM and register a feature request.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Wed, Jun 9, 2010 at 4:05 PM, Informix DBA <in4mixdba (AT) gmail (DOT) com> wrote:

Personally I agree. Call IBM and register a feature request.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Wed, Jun 9, 2010 at 4:05 PM, Informix DBA <in4mixdba (AT) gmail (DOT) com> wrote:

On Jun 9, 9:05*pm, Informix DBA <in4mix... (AT) gmail (DOT) com> wrote:
fix SHMVIRTSIZE or the developer! ;-)

-->>The only way would be to poll the message log for the string.

i would make sure only one segment for virtual and use
onstat -g seg
or
dbaccess sysmaster <<!

select * from sysseglst
!


to check if extra were added

Superboer

On 9 jun, 21:52, Art Kagel <art.ka... (AT) gmail (DOT) com> wrote:

Thank you Superboer and Art. For the meantime I will create another
monitor. I have also submitted a feature request to get this event to
trigger the ALARMPROGRAM.

--Dave


On Thu, Jun 10, 2010 at 4:31 AM, Superboer <superboer7 (AT) t-online (DOT) de> wrote: