469,602 Members | 1,777 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

Backup/Restore from one tablespace ot another tablespace in the same database

How does this work?

I have one database SBO_DB (SAP BusinessOne)
I want to copy tablespace TS_SEW_ACCESS_DEMO to TS_TEST2.

The directory of the database is: F:\DB2\NODE0000\SQL00002

Please help!

Frank
Jul 3 '06 #1
6 6182
Frank Fiene wrote:
How does this work?

I have one database SBO_DB (SAP BusinessOne)
I want to copy tablespace TS_SEW_ACCESS_DEMO to TS_TEST2.

The directory of the database is: F:\DB2\NODE0000\SQL00002

Please help!

Frank
Hi!

If you are using vesion 8 then you have to export tables from one tablespace
and import then into the other.

--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| Gregor Kovac | Gr**********@mikropis.si |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Jul 3 '06 #2
Gregor Kovač wrote:
If you are using vesion 8 then you have to export tables from one
tablespace and import then into the other.
Thanks for your answer!
But: can i export/import a complete tablespace at once? There are many many
tables in this tablespace!
Jul 3 '06 #3
Frank Fiene wrote:
Gregor Kovač wrote:
>If you are using vesion 8 then you have to export tables from one
tablespace and import then into the other.

Thanks for your answer!
But: can i export/import a complete tablespace at once? There are many
many tables in this tablespace!
There is a command db2move
(http://publib.boulder.ibm.com/infoce...e/r0002079.htm)

--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| Gregor Kovac | Gr**********@mikropis.si |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Jul 4 '06 #4
Gregor Kovač wrote:
Frank Fiene wrote:
>Gregor Kovač wrote:
>>If you are using vesion 8 then you have to export tables from one
tablespace and import then into the other.

Thanks for your answer!
But: can i export/import a complete tablespace at once? There are many
many tables in this tablespace!

There is a command db2move
Yes, i found this, too!

What i've tried:
1.) db2move sample export -ts USERSPACE1
2.) db2 create db temp
3.) db2move temp import
4.) db2 CONNECT TO TEMP;
5.) db2 RENAME TABLESPACE USERSPACE1 TO MYSPACE1;
6.) db2 CONNECT RESET;
7.) rm tab*
7.) db2move temp export -ts MYSPACE1
8.) db2move sample import
9.) db2 connect to sample
10.) db2 list tablespaces

No tablespace MYSPACE1 in sample, but in temp!
The output of db2move import (partially):
* IMPORT: table "DB2INST1"."SALES"
-Rows read: 41
-Inserted: 41
-Rejected: 0
-Committed: 41

....

Jul 4 '06 #5
if you just want to replace the TS_SEW_ACCESS_DEMO to TS_TEST2? if so,
try "rename tablespace TS_SEW_ACCESS_DEMO to TS_TEST2"

Frank Fiene 写道:
How does this work?

I have one database SBO_DB (SAP BusinessOne)
I want to copy tablespace TS_SEW_ACCESS_DEMO to TS_TEST2.

The directory of the database is: F:\DB2\NODE0000\SQL00002

Please help!

Frank
Jul 4 '06 #6
sorry, i just didn't see your later replay and make the mistake.
Hardy 写道:
if you just want to replace the TS_SEW_ACCESS_DEMO to TS_TEST2? if so,
try "rename tablespace TS_SEW_ACCESS_DEMO to TS_TEST2"

Frank Fiene 写道:
How does this work?

I have one database SBO_DB (SAP BusinessOne)
I want to copy tablespace TS_SEW_ACCESS_DEMO to TS_TEST2.

The directory of the database is: F:\DB2\NODE0000\SQL00002

Please help!

Frank
Jul 4 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Andrew E | last post: by
6 posts views Thread by Eric Herber | last post: by
4 posts views Thread by Hardy | last post: by
3 posts views Thread by UnixSlaxer | last post: by
11 posts views Thread by Chris | last post: by
5 posts views Thread by jag | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.