DB2 Kill Lock Process

DB2 kill lock-in command

Get  for Locks    on (Requires snapshot access)
DB2 List Applications
" Force Application (8) "

In the fourth paragraph of snapshot, an application with an application handle of 8 has a lock present, and the locked table is us_catalog in its corresponding lock list.

If you are sure that a deadlock has occurred on the Us_catalog table, you can kill the application's connection to the database by command DB2 "Force application (8)".

Note If the force command causes the application's transaction to be rolled back, the Force command cannot immediately disconnect the application on the database, but wait until the rollback is complete before disconnecting the application's database connection.

You can use db2top-d db_name, enter the name of the table by pressing U, and see which application the lock is added to the table.

If you want to release the lock, just force the application off. DB2 "Force application (APPL_ID)"
However, before force application, take care of what the application is doing, force, will be rolled back, some operations can not be rolled back,
The object is invalid.

DB2 Kill Lock Process