Env:
DB2 LUW V8 + FP14
AIX 5.3
Problem Description:
Our production database create one big temporary tablespace to do off-
line reorg,
after reorg complete, we drop this tablespace online but we found the
containers /dev/tmplv lv state is open , can not be remove via aix
smit. :(
We issue fuser to check the locker are db2pfchr/db2pclnr.
Question:
Why db2 tablespace already be dropped but the containers still lock by
db2 (db2pfchr/db2pclnr) ?
So far , we already monitor this raw device state more than three
months but the container state still opening.
Cause of database work as 7x24, have any one have exprience can solve
this issue without recycle database ?
Thanks. |