SAP Note 1127881 - Poor performance due to mutex hash wait DS cache

Component : Informix - Database Administration with Informix

Solution : https://service.sap.com/sap/support/notes/1127881 (SAP Service marketplace login required)

Summary :
This SAP Note addresses a performance issue where the system often waits for the "hash mutex" of the "sysdistrib" table due to missing parameter recommendations from 2004 affecting the optimizer statistics. To resolve this, adjust the DS_HASHSIZE and DS_POOLSIZE settings according to specifications outlined in SAP Note 41360. Implement these changes to prevent bottlenecks, even if no immediate issues are evident.

Key words :
general performance problem, system frequently waits, special cache exists, ds_poolsize 2000ds_hashsize  503implement, hash mutex, terms - reason, infcfgcheck check, bottleneck occurs, optimizer statistics, 41360  database configuration

Related Notes :

41360Database configuration using onconfig parameter