The HDB_DBCC_BTRAN event is used in SAP to view HANA DB blocked transactions. Blocked transactions are transactions that are unable to be processed further because they need to acquire transactional locks (record or table locks) that are currently held by another transaction. Transactions can also be blocked waiting for other resources such as network or disk (database or metadata locks).
Potential Use Cases
This event could be used in the following scenarios:
Alert on HANA DB blocked transactions
Trend HANA DB blocked transactions over time
The event will look like this in Splunk:
Execute the dbacockpit transaction in the system. Open the Diagnostics folder, open the Locks folder, and double-click on “Blocked Transactions”. The information displayed on the right side of the screen will match the data that is extracted and sent to Splunk.