how to find out if table is locked in HANA

[Former Member]

Hello Experts

how to find out the if the table is locked in HANA and let's say once we find out table is locked,how to unlock the table so my ETL jobs doesn't fail.

Thanks,

Nis

[former_member184768 · Accepted solution]

Hi Nishith,

Please check the view M_TABLE_LOCKS for the table level lock details.

http://help.sap.com/hana/html/_m__t_a_b_l_e__l_o_c_k_s.html

The locks are released once the transaction is completed.

Regards,

Ravi

[Former Member · Accepted solution]

Thanks Ravi. How do I manually release the lock from table?

[former_member184768 · Accepted solution]

Hi Nithish,

Please refer to another thread on the same topic here. There is a workaround provided in that.

http://scn.sap.com/thread/2107614

Regards,

Ravi