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