IDS GE license restriction limits warning messages...

[June Nebab LKINY]

On a new install of IDS 11.70 UC1GE on Red Hat Enterprise 5 32 bit with 6GB RAM.   I noticed the following messages in the online.log file:

14:07:32  Warning: The IBM IDS Growth Edition license restriction limits
14:07:32  the total shared memory size for this server to 0 KB.
14:07:32  The maximum allowable shared memory was reset to this size to start the database server.
14:07:32  Insufficient free huge pages in /proc/meminfo for shared memory segment.
          Requested: 142397440 bytes.  Available: 0 bytes.
          The default memory page size will be used.
14:07:32  Segment locked: addr=0x44000000, size=142397440
14:07:32  Insufficient free huge pages in /proc/meminfo for shared memory segment.
          Requested: 655360000 bytes.  Available: 0 bytes.
          The default memory page size will be used.
14:07:32  Segment locked: addr=0x4c7cd000, size=655360000


My SHMVIRTSIZE is set to 640000 KB

DISCLAIMER

This transmission and the information contained herein and/or in any attachments hereto and/or in any attachments thereto is privileged and/or confidential and is intended ONLY for the use of the individual(s) and/or entity(s) named above. If you are not the intended recipient, you are strictly prohibited from disclosing, printing, copying, using or disseminating this transmission and/or any such attachments and any information contained in this transmission and/or in any such attachments. ANY unauthorized interception of this transmission and/or any such attachments is a violation of federal criminal law.

If you have received this transmission in error please notify the sender immediately and delete the transmission and all such attachments.

[Alexandre Marini]

Hello.

1) Did you check if there´s any segment in use? (ipcs command)
2) I had similar troubles here, with no segment used by informix.
I suggest you to take your whole *SHM* portion of the onconfig.std file,
and paste it into your production one. That maybe some mispelling word.
If you cannot start it yet, paste all your memory parameters here, so we can try to help you out, ok?

Best regards.

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

--

Alexandre Marini

Tecnologia da Informação - DBA

SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix

IBM Informix Dynamic Server Certified Professional V10 / V11

 

[jrenaut]

> If you have received this transmission in error, please notify the sender immediately and delete the transmission and all such attachments

To get those messages it appears you need to have the env variable
IFX_LARGE_PAGES set to 1. If that is turned on, then when trying to
start up the server and create the initial shared memory segments, the
oninit process will open up /proc/meminfo looking for HugePages_Free
and Hugepagesize. I'm not familiar with this concept on Linux, but I
would assume it is some sort of OS configuration thing. From the
message you got, it would appear that we found Hugepagesize set to be
0 from our query to /proc/meminfo, at which point we would no longer
attempt to use that feature.

Jacques Renaut
IBM Informix Advanced Support
APD Team

[June Nebab LKINY]

Thank you Jacques...that WORKED!

---

June A. Nebab
IBM Informix DBA/Linux System Admin
Lazare Kaplan International Inc.
19 W 44th Street
New York, NY 10036
800-554-3325
212-972-9700

"The World's Most Beautiful Diamond"
www.lazarediamonds.com

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

DISCLAIMER

This transmission and the information contained herein and/or in any attachments hereto and/or in any attachments thereto is privileged and/or confidential and is intended ONLY for the use of the individual(s) and/or entity(s) named above. If you are not the intended recipient, you are strictly prohibited from disclosing, printing, copying, using or disseminating this transmission and/or any such attachments and any information contained in this transmission and/or in any such attachments. ANY unauthorized interception of this transmission and/or any such attachments is a violation of federal criminal law.

If you have received this transmission in error please notify the sender immediately and delete the transmission and all such attachments.

[June Nebab]

Jacques,

After mistakenly admitting that this worked, I noticed the same error messages still appearing in the log whenever I startup the engine.

IFX_LARGE_PAGES environment is already set to 1.

cat /proc/meminfo shows the following  HugePages settings:

   HugePages_Total:     0
   HugePages_Free:      0
   HugePages_Rsvd:      0
   Hugepagesize:     2048 kB

I changed RESIDENT from "-1" to "1" and bounced the engine but the message still appears.

My shared memory settings in ONCONFIG:

RESIDENT        1
SHMBASE         0x44000000
SHMVIRTSIZE  1024000
SHMADD          8192
EXTSHMADD    8192
SHMTOTAL        0
SHMVIRT_ALLOCSEG 0.000000,3
SHMNOACCESS     cpu,num=1,noage

[Art Kagel]

June:

This one setting, at least, is not correct:

SHMNOACCESS     cpu,num=1,noage

This looks like your SHMNOACCESS and VPCLASS settings got combined somehow.  Don't think this has anything to do with the warning you are seeing, but....

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (a...@iiug.org)
Blog: http://informix-myview.blogspot.com/

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 Thu, Dec 16, 2010 at 1:28 PM, June Nebab <jne...@idealcut.com> wrote:

Jacques,

After mistakenly admitting that this worked, I noticed the same error messages still appearing in the log whenever I startup the engine.

IFX_LARGE_PAGES environment is already set to 1.

cat /proc/meminfo shows the following  HugePages settings:

   HugePages_Total:     0
   HugePages_Free:      0
   HugePages_Rsvd:      0
   Hugepagesize:     2048 kB

I changed RESIDENT from "-1" to "1" and bounced the engine but the message still appears.

My shared memory settings in ONCONFIG:

RESIDENT        1
SHMBASE         0x44000000
SHMVIRTSIZE  1024000
SHMADD          8192
EXTSHMADD    8192
SHMTOTAL        0
SHMVIRT_ALLOCSEG 0.000000,3
SHMNOACCESS     cpu,num=1,noage

On Thu, Dec 2, 2010 at 10:28 AM, jrenaut <jpre...@yahoo.com> wrote:

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

[June Nebab LKINY]

Good catch Art,  fixed that but as you have stated it had nothing to do with it.

----- Original Message -----
From: "Art Kagel" <art....@gmail.com>
To: "June Nebab" <jne...@idealcut.com>
Cc: "jrenaut" <jpre...@yahoo.com>, inform...@iiug.org
Sent: Thursday, December 16, 2010 1:59:58 PM GMT -05:00 US/Canada Eastern
Subject: Re: IDS GE license restriction limits warning messages...

DISCLAIMER

If you have received this transmission in error please notify the sender immediately and delete the transmission and all such attachments.

[Fernando Nunes]

Can you post the output of "onstat -g env"?
Regards.

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

[June Nebab LKINY]

Output of onstat -g env


IBM Informix Dynamic Server Version 11.70.UC1GE -- On-Line -- Up 21:42:09 -- 1164112 Kbytes

Server start-up environment:

Variable            Value [values-list]
DBDELIMITER         |
DBPATH              .
DBPRINT             lp -s
DBTEMP              /tmp
IFX_LARGE_PAGES     1
INFORMIXDIR         /u/informix/11_7
                    [/u/informix/11_7]
                    [/usr/informix]
INFORMIXSERVER      prod117_net
INFORMIXSQLHOSTS    /u/informix/11_7/etc/sqlhosts
INFORMIXTERM        termcap
                    [termcap]
                    [terminfo]
LANG                en_US.UTF-8
LC_COLLATE          en_US.UTF-8
LC_CTYPE            en_US.UTF-8
LC_MONETARY         en_US.UTF-8
LC_NUMERIC          en_US.UTF-8
LC_TIME             en_US.UTF-8
LKNOTIFY            yes
LOCKDOWN            no
NODEFDAC            no
ONCONFIG            onconfig.prod117
PATH                /u/bin:/u/informix/11_7:/u/informix/11_7/bin:/u1/tmp:/u/informix/11_7/lib:/u/informix/11_7/lib/esql:/usr/kerberos/bin:/usr/bin:/bin:/opt/mx/bin
SERVER_LOCALE       en_US.819
SHELL               /bin/bash
TERM                wyse60
                    [wyse60]
                    [dumb]
TERMCAP             /u/informix/11_7/etc/termcap
                    [/u/informix/11_7/etc/termcap]
                    [/etc/termcap]


Output of /etc/systcl.conf:

# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled.  See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename
# Useful for debugging multi-threaded applications
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Controls the maximum size of a message, in bytes
kernel.msgmnb = 65536

# Controls the default maxmimum size of a mesage queue
kernel.msgmax = 65536

# Controls the maximum number of shared memory segments, in pages
# Default RHEL 5 kernel.shmmax value
# JN11/16/2010 - commented this line in favor of the IDS 11.7 params below
# kernel.shmall = 268435456

# Controls the maximum shared segment size, in bytes
# Default RHEL 5 kernel.shmmax value
# JN11/16/2010 - commented this line in favor of the IDS 11.7 params below
# kernel.shmmax = 4294967295

# JN11/16/2010 - LKI RHEL5 IDS11.7 customization
kernel.shmmax = 33554432
kernel.shmmni = 128
kernel.shmall = 4194304
kernel.semmni = 128
kernel.semmsl = 250
kernel.semmns = 32000
kernel.semopm = 32



Output of /proc/meminfo

MemTotal:      6221460 kB
MemFree:         59016 kB
Buffers:        322876 kB
Cached:        5391484 kB
SwapCached:          0 kB
Active:         901384 kB
Inactive:      5002172 kB
HighTotal:     5363900 kB
HighFree:        48312 kB
LowTotal:       857560 kB
LowFree:         10704 kB
SwapTotal:     6144744 kB
SwapFree:      6144424 kB
Dirty:            1108 kB
Writeback:           0 kB
AnonPages:      189180 kB
Mapped:         388060 kB
Slab:           219416 kB
PageTables:       9484 kB
NFS_Unstable:        0 kB
Bounce:              0 kB
CommitLimit:   9255472 kB
Committed_AS:  1997636 kB
VmallocTotal:   116728 kB
VmallocUsed:     20352 kB
VmallocChunk:    96128 kB

HugePages_Total:     0
HugePages_Free:      0
HugePages_Rsvd:      0
Hugepagesize:     2048 kB

-------------------------------------

June A. Nebab
IBM Informix DBA/Linux System Admin
Lazare Kaplan International Inc.
19 W 44th Street
New York, NY 10036
800-554-3325
212-972-9700

"The World's Most Beautiful Diamond"
www.lazarediamonds.com

[Fernando Nunes]

You have two messages there. One is caused by SHMTOTAL=0. apparently the message doesn't make sense. But it's a fact that the version you have has memory limits.

The other message is caused by IFX_LARGE_PAGES=1 and the engine was brought online with that in the environment (as the output from onstat -g env shows).

Regards.

[gok...@hotmail.com]

Mi estimado YO TENGO EL MISMO PROBLEMA CON UN SISTEMA DE MEMORIA DE 8 GB ¿CUAL ES LA SOLUCION? por favor

[gok...@hotmail.com]

El martes, 30 de noviembre de 2010, 18:08:50 (UTC-4), June Nebab LKINY escribió:

Mon Aug 27 08:43:52 2018

08:43:52 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 134217728 bytes. Available: 0 bytes.

The default memory page size will be used.

08:43:52 Segment locked: addr=0x47db4000, size=134217728
08:43:53 Successfully added a bufferpool of page size 2K.

08:43:53 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 134217728 bytes. Available: 0 bytes.

The default memory page size will be used.

08:43:53 Segment locked: addr=0x4fdb4000, size=134217728
08:43:53 Successfully added a bufferpool of page size 4K.

[Mike Walker]

Did informix still start up?

This is indicating that you have not configured huge pages. Informix should still allocate the memory that it needs...it just won't be using "huge pages".

There's some articles online for how to configure huge pages. Set them up, and these warnings will go away.

-----Original Message-----
From: informix-l...@iiug.org [mailto:informix-l...@iiug.org] On Behalf Of gok...@hotmail.com
Sent: Tuesday, August 28, 2018 7:38 PM
To: inform...@iiug.org
Subject: Re: IDS GE license restriction limits warning messages...

Mi estimado YO TENGO EL MISMO PROBLEMA CON UN SISTEMA DE MEMORIA DE 8 GB ¿CUAL ES LA SOLUCION? por favor _______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://members.iiug.org/mailman/listinfo/informix-list

[gok...@hotmail.com]

ENTONCES SE REFIERE A ESTO:

sysctl -w vm.nr_hugepages

SI ES ASI CREO YA TENER ALGUNA FORMA DE VERIFICAR SI FUNCIONARÁ

[gok...@hotmail.com]

ME CONFIRMA POR FAVOR SI ESTOY POR BUEN CAMINO?