Show TOC

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

Query Query: 0E2EREP_ALLSYS_DBH_DEADLOCKS

 

This query is used in interactive reporting in the Technical Monitoring work center. The report shows the total number of deadlocks on the selected databases. 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 Overview 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

System ID

0SMD_LSID
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Deadlocks

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

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