Moving a database containing different schemas 
Author Message
 Moving a database containing different schemas

Hi there

I'm trying to move a DB2 UDB EE 7.2 database from one NT server to
another. The database has tables created under different schemas. I
tried two options : 1. backing up and restoring and 2. using db2move.

1. Backing up created a whole lot of folders and one file, but upon
restoring it, it's telling me that there's a mismatch and that there
isn't a file for the timestamp I specified. I'm sure I specified the
right timestamp and everything, but I think I'm missing something. Is
this backup and restore facility limited to backing up and restoring
the same database in the same server? I have different aliases for the
source and target database, and I have a funny feeling that it is
affecting the restore. Can anyone give me more information on this?

2. db2move exported my data successfully in a number of ixf files, but
when I'm trying to load in the target, it's telling me that the tables
do not exist. First of all, can I load into an empty database?
Secondly, I have my tables created already but since they're in
different schemas, I think that my db2move command might not be
considering that.

Can anyone give me any advise on what I'm missing or what I should do?

Cheers
Moira Camilleri



Mon, 11 Oct 2004 18:08:43 GMT
 Moving a database containing different schemas

Yes, you can tell db2move to do an import with replace-create.
It will then create the tables.

Quote:

> Hi there

> I'm trying to move a DB2 UDB EE 7.2 database from one NT server to
> another. The database has tables created under different schemas. I
> tried two options : 1. backing up and restoring and 2. using db2move.

> 1. Backing up created a whole lot of folders and one file, but upon
> restoring it, it's telling me that there's a mismatch and that there
> isn't a file for the timestamp I specified. I'm sure I specified the
> right timestamp and everything, but I think I'm missing something. Is
> this backup and restore facility limited to backing up and restoring
> the same database in the same server? I have different aliases for the
> source and target database, and I have a funny feeling that it is
> affecting the restore. Can anyone give me more information on this?

> 2. db2move exported my data successfully in a number of ixf files, but
> when I'm trying to load in the target, it's telling me that the tables
> do not exist. First of all, can I load into an empty database?
> Secondly, I have my tables created already but since they're in
> different schemas, I think that my db2move command might not be
> considering that.

> Can anyone give me any advise on what I'm missing or what I should do?

> Cheers
> Moira Camilleri

--
Anton Versteeg
DB2 Specialist
IBM Netherlands


Mon, 11 Oct 2004 19:53:07 GMT
 Moving a database containing different schemas
db2move yourDbName export

db2move yourDbName import  - create tab & import


Quote:
> Hi there

> I'm trying to move a DB2 UDB EE 7.2 database from one NT server to
> another. The database has tables created under different schemas. I
> tried two options : 1. backing up and restoring and 2. using db2move.

> 1. Backing up created a whole lot of folders and one file, but upon
> restoring it, it's telling me that there's a mismatch and that there
> isn't a file for the timestamp I specified. I'm sure I specified the
> right timestamp and everything, but I think I'm missing something. Is
> this backup and restore facility limited to backing up and restoring
> the same database in the same server? I have different aliases for the
> source and target database, and I have a funny feeling that it is
> affecting the restore. Can anyone give me more information on this?

> 2. db2move exported my data successfully in a number of ixf files, but
> when I'm trying to load in the target, it's telling me that the tables
> do not exist. First of all, can I load into an empty database?
> Secondly, I have my tables created already but since they're in
> different schemas, I think that my db2move command might not be
> considering that.

> Can anyone give me any advise on what I'm missing or what I should do?

> Cheers
> Moira Camilleri



Mon, 11 Oct 2004 21:48:45 GMT
 Moving a database containing different schemas


Quote:
> Hi there

> I'm trying to move a DB2 UDB EE 7.2 database from one NT server to
> another. The database has tables created under different schemas. I
> tried two options : 1. backing up and restoring and 2. using db2move.

> 1. Backing up created a whole lot of folders and one file, but upon
> restoring it, it's telling me that there's a mismatch and that there
> isn't a file for the timestamp I specified. I'm sure I specified the
> right timestamp and everything, but I think I'm missing something. Is
> this backup and restore facility limited to backing up and restoring
> the same database in the same server? I have different aliases for the
> source and target database, and I have a funny feeling that it is
> affecting the restore. Can anyone give me more information on this?

This should work without a problem. A short example:

dbname = ORGDB
New dbname: NEWDB
Create folder on 'old' server: d:\dbbackup

backup command:
   db2 backup db orgdb to d:\dbbackup

copy the d:\dbbackup folder to the new server, just
use d:\dbbackup for ease of use

restore command:
   db2 restore db ORGDB from d:\dbbackup into NEWDB

Hope this helps



Tue, 12 Oct 2004 01:03:51 GMT
 Moving a database containing different schemas
Is there a way to backup a db2 database from Linux then restore it to NT?



Quote:


> > Hi there

> > I'm trying to move a DB2 UDB EE 7.2 database from one NT server to
> > another. The database has tables created under different schemas. I
> > tried two options : 1. backing up and restoring and 2. using db2move.

> > 1. Backing up created a whole lot of folders and one file, but upon
> > restoring it, it's telling me that there's a mismatch and that there
> > isn't a file for the timestamp I specified. I'm sure I specified the
> > right timestamp and everything, but I think I'm missing something. Is
> > this backup and restore facility limited to backing up and restoring
> > the same database in the same server? I have different aliases for the
> > source and target database, and I have a funny feeling that it is
> > affecting the restore. Can anyone give me more information on this?

> This should work without a problem. A short example:

> dbname = ORGDB
> New dbname: NEWDB
> Create folder on 'old' server: d:\dbbackup

> backup command:
>    db2 backup db orgdb to d:\dbbackup

> copy the d:\dbbackup folder to the new server, just
> use d:\dbbackup for ease of use

> restore command:
>    db2 restore db ORGDB from d:\dbbackup into NEWDB

> Hope this helps



Tue, 12 Oct 2004 07:19:19 GMT
 Moving a database containing different schemas

says...

Quote:





> > > Hi there

> > > I'm trying to move a DB2 UDB EE 7.2 database from one NT server to
> > > another. The database has tables created under different schemas. I
> > > tried two options : 1. backing up and restoring and 2. using db2move.

> > > 1. Backing up created a whole lot of folders and one file, but upon
> > > restoring it, it's telling me that there's a mismatch and that there
> > > isn't a file for the timestamp I specified. I'm sure I specified the
> > > right timestamp and everything, but I think I'm missing something. Is
> > > this backup and restore facility limited to backing up and restoring
> > > the same database in the same server? I have different aliases for the
> > > source and target database, and I have a funny feeling that it is
> > > affecting the restore. Can anyone give me more information on this?

> > This should work without a problem. A short example:

> > dbname = ORGDB
> > New dbname: NEWDB
> > Create folder on 'old' server: d:\dbbackup

> > backup command:
> >    db2 backup db orgdb to d:\dbbackup

> > copy the d:\dbbackup folder to the new server, just
> > use d:\dbbackup for ease of use

> > restore command:
> >    db2 restore db ORGDB from d:\dbbackup into NEWDB

> > Hope this helps

> Is there a way to backup a db2 database from Linux then restore it to NT?

No, you can't do that, you need to export/import them.


Tue, 12 Oct 2004 08:31:29 GMT
 Moving a database containing different schemas
This combination is not supported at this time... sorry.

Bob Harbus

Quote:

> Is there a way to backup a db2 database from Linux then restore it to NT?





> > > Hi there

> > > I'm trying to move a DB2 UDB EE 7.2 database from one NT server to
> > > another. The database has tables created under different schemas. I
> > > tried two options : 1. backing up and restoring and 2. using db2move.

> > > 1. Backing up created a whole lot of folders and one file, but upon
> > > restoring it, it's telling me that there's a mismatch and that there
> > > isn't a file for the timestamp I specified. I'm sure I specified the
> > > right timestamp and everything, but I think I'm missing something. Is
> > > this backup and restore facility limited to backing up and restoring
> > > the same database in the same server? I have different aliases for the
> > > source and target database, and I have a funny feeling that it is
> > > affecting the restore. Can anyone give me more information on this?

> > This should work without a problem. A short example:

> > dbname = ORGDB
> > New dbname: NEWDB
> > Create folder on 'old' server: d:\dbbackup

> > backup command:
> >    db2 backup db orgdb to d:\dbbackup

> > copy the d:\dbbackup folder to the new server, just
> > use d:\dbbackup for ease of use

> > restore command:
> >    db2 restore db ORGDB from d:\dbbackup into NEWDB

> > Hope this helps



Tue, 12 Oct 2004 08:46:34 GMT
 Moving a database containing different schemas
Tony,

it's not possible with BACKUP/RESTORE. If your Linux database is still
up and running you can use a combination of DB2LOOK/DB2MOVE to move
this database to NT.

"Tony Do"  wrote on 2002-04-26 09:19:19:

TD> Is there a way to backup a db2 database from Linux then restore it to NT?
TD>
TD>
TD>
TD>


TD> > In article ,

TD> > > Hi there
TD> > >
TD> > > I'm trying to move a DB2 UDB EE 7.2 database from one NT server to
TD> > > another. The database has tables created under different schemas. I
TD> > > tried two options : 1. backing up and restoring and 2. using db2move.
TD> > >
TD> > > 1. Backing up created a whole lot of folders and one file, but upon
TD> > > restoring it, it's telling me that there's a mismatch and that there
TD> > > isn't a file for the timestamp I specified. I'm sure I specified the
TD> > > right timestamp and everything, but I think I'm missing something. Is
TD> > > this backup and restore facility limited to backing up and restoring
TD> > > the same database in the same server? I have different aliases for the
TD> > > source and target database, and I have a funny feeling that it is
TD> > > affecting the restore. Can anyone give me more information on this?
TD> > >
TD> >
TD> > This should work without a problem. A short example:
TD> >
TD> > dbname = ORGDB
TD> > New dbname: NEWDB
TD> > Create folder on 'old' server: d:\dbbackup
TD> >
TD> > backup command:
TD> >    db2 backup db orgdb to d:\dbbackup
TD> >
TD> > copy the d:\dbbackup folder to the new server, just
TD> > use d:\dbbackup for ease of use
TD> >
TD> > restore command:
TD> >    db2 restore db ORGDB from d:\dbbackup into NEWDB
TD> >
TD> > Hope this helps



Tue, 12 Oct 2004 17:57:01 GMT
 Moving a database containing different schemas
Moira,
I frequently restore backups with real data on another machine
(LINUX).
Have you tried RESTORE with REDIRECT, redefine tablespace containers,
then RESTORE CONTINUE?
Cheers,
AK
Quote:

> Hi there

> I'm trying to move a DB2 UDB EE 7.2 database from one NT server to
> another. The database has tables created under different schemas. I
> tried two options : 1. backing up and restoring and 2. using db2move.



Tue, 12 Oct 2004 22:19:53 GMT
 
 [ 9 post ] 

 Relevant Pages 

1. Moving 6.5 database to another 6.5 database with different character set

2. moving master to different server on different drive

3. move a mouse pointer to a different location without moving the mouse

4. Moving Database to Different Partition/Drive

5. Moving a data to a different database- Newbie Question

6. Move database to different drive

7. Move MSDB database to a different location

8. Move database to new server with Different Character Set/Sort Order

9. Moving databases to different server

10. Moving a Database device to a different drive

11. Moving Database on Same Machine to Different Drive

12. Moving database to a different server


 
Powered by phpBB® Forum Software