Hi
I need to unlock a DB2 Table. How do I do this ?
I was trying to load to a target table and then i aborted the job as it was taking a long time. The target table is empty and I wanted to verify it. When I clicked view data it hung up.
I am assuming this is due to a table lock..Please help as to how I can release it ? or if I need to have the DBA do it ?
Unlock Table
Moderators: chulett, rschirm, roy
If its DB2UDB and the table is empty only then, you can do a Load from /dev/null. This also gets rid of any table locks on UDB's. Get the exact syntax from google by searching for "How to truncate a UDB table?"
Only try this if its UDB. If its DB2, then all the tables in that particular table space will get truncated.
Only try this if its UDB. If its DB2, then all the tables in that particular table space will get truncated.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.