I am trying to rename a table and the following error does not let me rename it.
db2 "RENAME TABLE DB2DB.TABLE_A TO TABLE_B"
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "68". SQLSTATE=40001.
The table does not have any dependent objects to it.I captured the snapshot of the ID holding the lock and is attached below.