hello,

Is there any way to remove locks on the table in the db2?
I tried to execute snapshot command and got couple of tables locked on the schema.

I was just wondering if there is any way to remove the locks as I am not able to execute some java based commands on the database.

regards
Pankaj

You can have the application holding the locks do a SQL COMMIT, or you can FORCE the application connection that is holding the locks (see Command Reference manual).

Thanks for the information. I tried to kill the locks by FORCE application but could not execute it as I receive below error.

db2 => force application (81)
SQL1096N The command is not valid for this node type.


Any idea?

Best regards
Pankaj

See you can always deferred the locking.
if u r on version 8.2 and higher you can use the registry variables

DB2_EVALUNCOMMITED=YES
and DB2_SKIPINSERTED=YES... you can read about these more on internet or manuals. But do test it before going to change in production systems

Try using the Command Window instead of Command Processor:

db2 "force application (81)"