SEO

#1 (**permalink**) 02-27-2008, 05:21 AM

One of our tablespaces is in an offline state:

Tablespace ID = 9
Name = xxx_xxxx
Type = Database managed space
Contents = Any data
State = 0x4000
Detailed explanation:
Offline

I believe this is because it ran out of space. What's the best way to
apporach this situation? I have additional space I'd like to add, but I
can't find a way to get it online/normal again.

Any ideas?

#2 (**permalink**) 02-27-2008, 05:21 AM

<cbielins@gmail.com> wrote in message
news:1131643307.669508.289350@g14g2000cwa.googlegr oups.com...
> One of our tablespaces is in an offline state:
>
> Tablespace ID = 9
> Name = xxx_xxxx
> Type = Database managed space
> Contents = Any data
> State = 0x4000
> Detailed explanation:
> Offline
>
> I believe this is because it ran out of space. What's the best way to
> apporach this situation? I have additional space I'd like to add, but I
> can't find a way to get it online/normal again.

alter tablespace xxx_xxxx switch online;

If this fails, check db2diag.log for details on why it couldn't be brought
online.

--
Matt Emmerton

#3 (**permalink**) 02-27-2008, 05:21 AM

yeah.......

the container that WAS tblspace xxx_xxx is GONE!!!

Is there any chance of recovering the tablespace? I can't add another
container due to it being offline, yet I can't switch it online due to
the container missing....

ideas??

#4 (**permalink**) 02-27-2008, 05:21 AM

Mount your most recent backup.
Use DB2CKBKP -h command to find thew value of the parm that will describe
the containers of that tablespace.
Use RESTORE DB .... TABLESPACE command with redirect option
Redefine all containers (Valid ones as same and then the one that is gone)
Then use RESTOR DB .... CONTINUE.

That should do it.

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<cbielins@gmail.com> a écrit dans le message de news:
1131654823.873553.257500@g43g2000cwa.googlegroups. com...
> yeah.......
>
> the container that WAS tblspace xxx_xxx is GONE!!!
>
> Is there any chance of recovering the tablespace? I can't add another
> container due to it being offline, yet I can't switch it online due to
> the container missing....
>
> ideas??
>

#5 (**permalink**) 02-27-2008, 05:21 AM

In addition to Pierre's comments..
You may also be able to restore the tablespace from a full offline
tablespace or database backup without redirection.
Let us assume you had sms tablespace container defined as:
/db2/smstsp1/
and smstsp1 and everything underneath has been lost for some reason.
You can restore the tablespace and DB2 engine would
recreate directory and populate it.
If the underlying filesytem has been lost, you can create one with same
name/paths and db2 would restore to it.
In summary, restore would work ok as long as db2 can create the
container paths as recorded in backup image.
....Yasir.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Tablespace in Offline State...