DB2 table is locked, how to unlock

Reasons and Solutions

1. Reason: Modify the table structure table structure changes and then any operation on the table is not allowed, SQLState is 57016 (because the table is not active, so it cannot be accessed), because the table field permissions are modified, resulting in tables are not available state, another small suggestion, If you used DB2 in your usual work, you'd better prepare a copy of the DB2 error document

2. Solution: The process of reconstructing and reconstructing a table is the process of breaking up and re-assembling part of the data.

The statement needs to be executed:

Command line execution: REORG TABLE tablename

Non-command line execution: Call Sysproc. Admin_cmd (' REORG TABLE tablename ')

3. Suggestion: A small suggestion, if the usual work with DB2 more, it is best to prepare a DB2 error document, can quickly cut into the problem to find

DB2 table is locked, how to unlock