Solution : https://service.sap.com/sap/support/notes/18993 (SAP Service marketplace login required)
Summary :
Increasing the LOCKS parameter directly affects memory allocation in the Informix shared memory, capped at 8,000,000 locks. Each lock uses 44 bytes in 32-bit systems and 72 bytes in 64-bit systems. Adjustments to the LOCKS value should take into consideration its significant impact on shared memory size. In versions prior to Informix 9.3x, these locks are set during startup, while versions from 9.3x onward allow locks to be dynamically created, up to a total of 9,500,000 under specific configurations. It is recommended to limit shared memory usage for locks to one-third of the total shared memory to avoid performance degradation. Recent IDS versions have improved dynamic lock allocation, making precise LOCKS settings less crucial.
Key words :
newer informix dynamic server versions, locks 32-bit server 64-bit server--------------------------------------------------------- 400, documented ibm informix pts 170449, total shared memory size, shared memory size, informix shared memory, considerable performance problems, memory consumption reason, shared memory usagenumber, approximate guide values
Related Notes :
76583 | Shared memory: Error when creating a segment |
69240 | Archiving: maximum number of database blocking achieved |
38307 | Reducing shared memory consumption |
17267 | SQL Error "ISAM-134: no more locks" |