By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,592 Members | 2,158 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,592 IT Pros & Developers. It's quick & easy.

[Question] DB2 LUW V8, regarding after drop tablespace behavior

P: n/a
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.

Jul 27 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.