Link to home
Start Free TrialLog in
Avatar of partminer
partminer

asked on

How to remove table from super exclusive lock in db2

We have a serious issue in DB2 and we need experts help with this. We have a tablespace and it contains 4 tables.One of the table went into super exclusive mode and no operations(read,update,delete etc) can be performed on that table. All the other tables in the table space can be accessed. We recycled the database many times and still the lock does not get released.

Is there a way we can release the super exclusive lock on the table ?

I would really appreciate your valuable inputs. Lookign forward to recieving your response.

Thank You.
Avatar of yjchong514
yjchong514
Flag of United States of America image

delete from mytable;
commit;
reorg table mytable;
commit;
runstats on table myTable on all columns;
commit;
Avatar of partminer
partminer

ASKER

operations(add,delete,update) are not allowing on table then how i will execute delete from mytable;
Dear friend,
1.What version of db2 in used?
2.What error message occured when you attempt to unlock it?
3.What you mean recycled the db?
4.Do you has admin access right?

Regards,
yjchong514
Dear yjchong : My db2 vertion is 8.1 . when we are trying to fetch data using select statement it's giving below error message
DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68
Message: The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". ?
and we observed exclusive lock held on table .Lock will automatically creating when we remove the existing lock . I have all admin rights available .
ASKER CERTIFIED SOLUTION
Avatar of gmarino
gmarino

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Are you okie?
Just check with you.
Provided part of the solution.