470,814 Members | 868 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,814 developers. It's quick & easy.

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

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.

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 ?


Jul 27 '07 #1
0 2081

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Paul | last post: by
2 posts views Thread by robert | last post: by
7 posts views Thread by chessplayer | last post: by
2 posts views Thread by Raghava | last post: by
2 posts views Thread by vj_dba | last post: by
1 post views Thread by bujjus173 | last post: by
3 posts views Thread by Michel Esber | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.