DB6_DB02_ELWNAME - DB6: Extended Latch Wait Names/Types

Data Description

The DB6_DB02_ELWNAME event is used to capture and report Extended Latch Wait metrics for an IBM DB6/DB2 database, providing a breakdown of wait time and frequency by latch type/name. This facilitates detailed analysis of internal contention and performance bottlenecks in memory management and synchronization mechanisms.

Potential Use Cases

Extended means that the requester yielded CPU while requesting latch and considered as some contention on the database. This event could be used in the following scenarios:

• Performance Bottleneck Analysis: Identify internal memory structures (e.g., buffer pools, hash buckets, lock managers) experiencing high contention.

• Proactive Monitoring: Use with performance dashboards to alert on increasing ELW times, helping prevent system slowdowns before they impact users.

• Database Tuning: Detect if certain memory pools (e.g., buffer pools) are under- or over-allocated, and tune them accordingly to reduce contention.

SAP Navigation

Log into the managed SAP system and execute the transaction DBACOCKPIT & click on the Performance->Time Spent Analysis as shown below