Skip to Content
avatar image
Former Member

How to release table locks?

I was running Data Services (4.0 SP2) to load data into Hana (1.0 SP2 patch 20) using the Bulk load option. Apparently, the DS process hung and now the table I was writing to is locked although the DS Job is dead. How do you release the table lock without restarting Hana DB?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 04, 2012 at 12:31 PM

    Hello Sachin,

    you could try these statements. The first one will cancel the currently executed operation, the second one will disconnect the idle session:

    ALTER SYSTEM CANCEL SESSION session_id;
    ALTER SYSTEM DISCONNECT SESSION session_id;
    

    Regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded