Deadlock and timeout batch reporting in Sysview for Db2

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Is there a Sysview Performance Management Option for Db2 for z/OS (IDB2) batch report that can list all the
deadlocks and timeouts seen online excluding the SQL.

Resolution

The BTLCONT report shows contention information for the threads involved in any deadlock or timeout.
The BTCNTSM report summarizes timeouts and deadlocks. The report is grouped by task waiting, resources and task holding.
You can locate them in the hlq.CDBATREQ dataset.