If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > tablespace offline due to missing container

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-11-05, 14:40
preetim preetim is offline
Registered User
 
Join Date: Jun 2003
Posts: 77
Question tablespace offline due to missing container

Our database is db2 v 7.2, DMS .

One of the tablespaces is damaged, status is offline. By looking at the logs, it was found that one on the containers is missing. A container was accidentally got deleted from the disk.

This tablespace is offline now. It had 6 containers. The container added last is the one that got deleted.
I know that we can not bring back the data that was stored in that missing container.
But, is there any way to make the tablespace online again? Can it connect back to the remaining 5 containers?

Please let me know if you have any information on this.

Thanks.
Reply With Quote
  #2 (permalink)  
Old 11-11-05, 15:20
wangzhonnew wangzhonnew is offline
Registered User
 
Join Date: Nov 2005
Location: Toronto
Posts: 65
alter tablespace <tbspacename> switch online
will work?
Reply With Quote
  #3 (permalink)  
Old 11-11-05, 15:23
dbamota dbamota is offline
Registered User
 
Join Date: Sep 2003
Posts: 237
You have to recreate the missing container; load(at a minimum) the tablespace from the latest backup and recover the tablespace to end of logs. Or load the entire database from backup and recover. Allowing you to continue with 5 out of 6 disks, would make database inconsistent, which is a NO NO.
__________________
mota
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On