Comment
Author: Admin | 2025-04-28
Problem You try to start the Informix server but it fails to start with messages like these in the online.log:21:45:30 IBM Informix Dynamic Server Started.21:45:30 size of resident + virtual segments 10443875920 + 4831838208 > 9663676416 total allowed by configuration parameter SHMTOTAL Symptom output of oninit -v:Checking group membership to determine server run mode...succeededReading configuration file '/opt/informix/etc/onconfig.test'...succeededCreating /INFORMIXTMP/.infxdirs...succeededChecking config parameters...succeededAllocating and attaching to shared memory...FAILEDmessages in online.log:21:45:30 IBM Informix Dynamic Server Started.21:45:30 size of resident + virtual segments 10443875920 + 4831838208 > 9663676416 total allowed by configuration parameter SHMTOTAL Cause The size of the resident and virtual portions of shared memory exceed the shared memory limit set by the ONCONFIG parameter SHMTOTAL.Resident portion of shared memory The resident portion of the database server shared memory stores the following data structures that do not change in size while the database server is running:Shared-memory headerBuffer poolLogical-log bufferPhysical-log bufferLock tableVirtual portion of shared memory The virtual portion of shared memory size is determined by the value of the ONCONFIG parameter SHMVIRTSIZE and stores the following data:Internal tablesBig buffersSession dataThread data (stacks and heaps)Data-distribution cacheDictionary cacheSPL routine cacheSQL statement cacheSorting poolGlobal pool Resolving The Problem Increase the value of the ONCONFIG parameter SHMTOTAL if possible.Decrease the value of one or more of these ONCONFIG parameters:- BUFFERPOOL ( the buffers value )- LOCKS- SHMVIRTSIZE [{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF022","label":"OS X"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.0;11.1;11.5;11.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Add Comment