Deadlock/Time-out Batch Report

Document ID : KB000016036
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Is there any batch report  that can list all the deadlocks and timeouts with as seen online excluding the SQLs?

 

Answer:

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