Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / January 2008

Tip: Looking for answers? Try searching our database.

Dropped Tablespace

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ravi Padmakar - 07 Jan 2008 19:58 GMT
Hello,
   In the process of making my database work (I started with not
being able to insert records because of tablespace issues) , I dropped
the tablespace for it. Now I am not able to access the data in any of
the tables because the tablespace on those tables is invalid. Is there
any way I can attach a new Table space to the existing tables(I get a
SQL3022N error code -204 message) . I don't work with databases and am
more into the DRDA aspect of DB2. So any information on this that can
keep me going is appreciated.

Thanks,
Ravi Veparala
Serge Rielau - 07 Jan 2008 20:44 GMT
> Hello,
>     In the process of making my database work (I started with not
[quoted text clipped - 5 lines]
> more into the DRDA aspect of DB2. So any information on this that can
> keep me going is appreciated.
You cannot replace the tablespace of an existing table.
When you dropped the tablespace you dropped all its tables with it.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.