Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003

    Question Unanswered: 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.


  2. #2
    Join Date
    Nov 2005
    alter tablespace <tbspacename> switch online
    will work?

  3. #3
    Join Date
    Sep 2003
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts