473,320 Members | 2,098 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.

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 6327
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Andrew E | last post by:
I just took over DBA responsibilities for an Oracle 8i database running on Linux. Although I've been working with relational databases for some time, I'm a bit green on Oracle so forgive me. My...
6
by: Eric Herber | last post by:
I've a question regarding db2 (V8.1) and database backups going to a storage manager like TSM for example. As I can see in the storage manager if I backup the complete database over the TSM API...
4
by: Hardy | last post by:
hi gurus, now I have to backup and restore a 8 T size db2 database. from two s85 to two 670. the partitions,tablespaces of the db should be redesigned then I plan to use redirected restore. but...
3
by: UnixSlaxer | last post by:
Hello, - I have a database, which i want to backup, not only the data, but also the indexes and views/procedures associated with it. Is the backup/restore operations (Through the DB2 Control...
11
by: Chris | last post by:
I have searched this group for answers and tried the responses. I am trying to Use an full online backup from our production server and apply it to our test server. The Tablespaces in the...
5
by: jag | last post by:
hi, I am thinking about backup strategy. I have couple of questions for my db2 community brothers. 1. Can i use full online or offline database backup as base for incremental backup for...
3
by: hikums | last post by:
Source/Production system: AIX 5.2, DB2 8.2 I have a full backup of sample db taken on 05/01/2006(logs included in backups) I have a tablespace backup of userspace1 taken on 05/03/2006(logs...
3
by: dcruncher4 | last post by:
It is possible that we may be asked to restore a production tape, say 3 yrs later. We would prefer redirect restore for that. I am documenting a process to do a redirect restore. We take...
7
by: yellr | last post by:
Hi, i've spent all resources, except this one. Hopefully anyone there out could help me with a idea for this problem. We have a db2 8.2 Enterprise Edition, on AIX 5.3 Platform, this is our...
2
by: modeler | last post by:
Hello, I am trying to restore a DB2 9.1 fp2 backup to another DB2 9.1 fp2 machine, both are on Windows. C:\Program Files\IBM\SQLLIB\BIN>db2 -tvf C:\db2_data\test.db2 UPDATE COMMAND OPTIONS...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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...
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: 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)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shllpp 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
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.