473,320 Members | 2,000 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Tablespace in Offline State...

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?

Nov 12 '05 #1
4 11119

<cb******@gmail.com> wrote in message
news:11**********************@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
Nov 12 '05 #2
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??

Nov 12 '05 #3
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
<cb******@gmail.com> a écrit dans le message de news:
11**********************@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??


Nov 12 '05 #4
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.

Nov 12 '05 #5

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

Similar topics

1
by: valexena | last post by:
I am attempting to take tablespace offline and receiving the following error: ORA-01546- cannot take tablespace offline. What I am doing wrong? -- Posted via http://dbforums.com
7
by: tracy | last post by:
hi, i need advise and guidance from experts. Today, I discovered about 1464 tables created in SYSTEM tablespace and the owner is dev_user. As, i read from ORACLE 101 DBA's it said :'System...
8
by: Amy DBA | last post by:
OK, I'm stumped now. I need help restoring a tablespace that has been marked offline. Here's a little background on the problem: 1) There was a hardware failure that caused the tablespace to...
4
by: mairhtin o'feannag | last post by:
Hello, I have a tablespace striped across three drives, call them 1,2,3, just to be clever. :) I allocated a lot more space (DMS) than I should have, since I didn't know a way to estimate the...
2
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...
8
by: Raj | last post by:
-Is it possible to recover a tablespace just from a full offline backup and offline incremental backup? If not possible -Can we recover tablespace from Full backup , Wednesdays incremental backup...
6
by: Konstantin Andreev | last post by:
Hello, all. Let the tablespace SY810T4K is almost full: --------------- db2 =list tablespaces show detail ... Name = SY810T4K Type = Database managed space Contents...
4
by: Raj | last post by:
For tablespace level recovery of the db is the following strategy good enough? Sunday's Table - Full offline backup Mondays incremental to tape Monday's offline incremental backup + Monday's logs...
6
by: morch | last post by:
Hello, I have an oddity on a production database. I get the following from the DB CFG : Backup pending = NO Database is consistent ...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.