472,805 Members | 1,043 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,805 software developers and data experts.

[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 2184

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Paul | last post by:
I have several databases running on Solaris 2.8 and Oracle I only have this problem with one of them. The temp tablespace always fills up and Oracle does not clear it out. If I expand...
by: robert | last post by:
the real DBAs aren't around for a few days, so rather than shoot myself in a tender spot, i thought i'd ask first. what docs i can find say that the syntax is: DROP TABLESPACE FOO seems...
by: chessplayer | last post by:
Greetings Folks, I am trying to understand how DB2 locks data and can't believe my eyes. Have read the literature about the difference isolation levels and have a general understanding about...
by: Raghava | last post by:
hi all, i was working on DB2 and came across an issue. i.e. can a tablespace be rollforwarded to POINT-IN-TIME? the scenario is as follows: i created a data base and a tablespace in it. i have...
by: vj_dba | last post by:
Hi Group, I have a problem in restoring my tablespace, my database is running in ARCHIVAL logging, I created a tablespace, did some transaction, then took the ONLINE BACKUP of the tablespace....
by: jainarayan5484 | last post by:
hi All, Sir i want to know That What is the need to Create Tablespace,Alter TableSpace,Drop Tablespace.Whereas database use default tablespace. plz help me ...
by: bujjus173 | last post by:
Hi, I need to drop a tablespace, I am unable to drop because it says the containers it uses is inaccessible, because a process deleted the container. the tablespace went into pending state. I just...
by: holdingbe | last post by:
Hi , I am deleting the large amount of data in table using the delete statements .After that I have checked tablespace, there is no change in tablespace memory. But when using truncate statements,I...
by: Michel Esber | last post by:
Hi all, DB2 V8 LUW FP 15 There is a table T (ID varchar (24), ABC timestamp). ID is PK. Our application needs to frequently update T with a new value for ABC. update T set ABC=? where ID...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.