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
....