DB6_DB02_TELWT - DB6: Total Extended Latch Wait Time drill-down by Service Classes

Data Description

DB6_DB02_TELWT event for IBM DB6 in SAP is used to get the cumulative time that database processes (threads) spend waiting to acquire latches on internal memory structures when those waits exceed a certain threshold.

Potential Use Cases

This event could be used in the following scenarios:

• Identifying Internal Contention in the Database: Extended latch wait time points to internal resource contention—where multiple threads/processes try to access the same memory structures.

• Drilled down by service class (e.g., dialog, batch, update), can help to pinpoint which types of workloads are being delayed

• Useful in SAP systems to see if, for example, only background jobs or reporting queries are causing the problem.

• Benchmarking and Trend Analysis: Used to track performance over time. Sudden spikes may indicate recent workload changes, SAP upgrades, or configuration regressions.

SAP Navigation

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