Show TOC

E2E DB Reporting: Deadlocks Locate this document in the navigation structure

Query Query: 0E2EREP_DBH_DEADLOCKS

 

This query is used in interactive reporting in the Technical Monitoring work center. The report shows the total number of deadlocks in the relevant time periods. These are situations in which two or more processes deadlock and each process waits for another process to release the lock.

This query is used in the following report:

  • Start of the navigation path Database Next navigation step Exceptions Next navigation step Deadlocks End of the navigation path

The query is used in the following Web Template:

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Metric Type

0DBH_METY

= DB Exceptions [DB Exceptions]
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Deadlocks

‘Key value’ [1KYFNM] = ‘Sum’ [0DBH_SUM]

‘Metric name’ [0DBH_MENA] = ‘Deadlocks’ [Deadlocks]