Unanswered: swap memory usage while increasing db size
I am using Informix 11.7 and I got a requirement to increase the DB Size. But on increasing the Db Space, I can see swap memory being used on my system (in my environment DB shares memory with many other applications). I have set SHMTOTAL as 1 GB but still memory consumption through TOP seems quite high.
Need to understand if I am using the right approach to get the memory consumption of Informix.
Although onstat –g seg suggest on Virtual segment being added to server.
cucdb onstat -g seg
id key addr size ovhd class blkused blkfree
4063244 52604801 44010000 328232960 2146492 R* 80133 2
4390934 5260480b 57917000 268435456 1574024 V 25298 40238
Total: - - 596668416 - - 105431 40240
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
I'm not sure about what you mean when you say "increase db size".
If you mean "increase disk space for Informix", this action has absolutely no consequence on the memory consumption. I think you are confusing between increasing BUFFERPOOL, which will definately have consequences on the memory consumption, and enlarging disk space.
I have a feeling you are meaning enlarging disk space. Generally, this is done using the onspaces command, which allows you to add a chunk to an existing dbspace
See at this place how to use onspaces.
Another great feature introduced in 11.70 is the Storage Pool, which allows you to declare chunks as automatically extendable. Reaching a determined threshold, Informix will automatically extend the chunk size with any human action.
TO understand Storage Pool, check here
If you are meaning increasing the Informix shared memory, please specify why you have to do it and what is your objective.