SAP Note 18993 - Influence of LOCK Parameter on Shared Memory Size

Component : Informix -

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 :

76583Shared memory: Error when creating a segment
69240Archiving: maximum number of database blocking achieved
38307Reducing shared memory consumption
17267SQL Error "ISAM-134: no more locks"