Skip to Content
0
Jun 21, 2018 at 04:35 AM

How to find out objects in HANA blocked transactions

1887 Views Last edit Jun 21, 2018 at 07:33 PM 3 rev

Hello Experts

We have an ECC system (SoH) with HANA DB Rev122.12 and we frequently get blocked transactions on table NRIV. We raised the issue to SAP and received below recommendation

"High lock time for Number Range Table (NRIV), objects EINKBELEG (Purchasing documents) and RV_BELEG (Billing Documents - External Assignment). It should be evaluated the setup of buffering for theses objects."

I tried to make analysis from my side and found the corresponding statement hash from "HANA_Locks_Transactional_LockWaits_Hierarchy_1.00.100+" script and I'm attaching the output as txt file hana-locks-scn.txt. Also found the SQL statement as

"SELECT TOP 1 * FROM "NRIV" WHERE "CLIENT" = ? AND "OBJECT" = ? AND "SUBOBJECT" = ? AND "NRRANGENR" = ? AND "TOYEAR" = ? FOR UPDATE". 

Since its using bind variable how can I find the OBJECT causing the lock situation as pointed out by SAP. I can see the bind values using HANA_SQL_ExpensiveStatements_BindValues_CommaList_1.00.60+. Is it the right method? Does all blocked transactions comes under Expensive Statements?

Attachments

hana-locks-scn.txt (10.6 kB)