467,134 Members | 961 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

Copy of database

Hello all.
I need transfer a db2 database ( tables, records ecc. ) from a server1 to
server2.
The operating system of server1 and server2 is win2000 server.
I have installed db2 to server2. Now how can i copy the database from
server1 to server2 ?
Can i simple copy the directory db2 and all subdirs ?

Thanks and best regards

Fabio
Nov 12 '05 #1
  • viewed: 6559
Share:
2 Replies
Fabius wrote:
Hello all.
I need transfer a db2 database ( tables, records ecc. ) from a server1 to
server2.
The operating system of server1 and server2 is win2000 server.
I have installed db2 to server2. Now how can i copy the database from
server1 to server2 ?
Can i simple copy the directory db2 and all subdirs ?

Thanks and best regards

Fabio

No.

Use backup/restore instead.

Jan M. Nelken
Nov 12 '05 #2
Best and safest way to do this is to backup the db to tape and restore
it on the target server. Use DB2 BACKUP, RESTORE commands.
If you use backup to disk, once done then copy the whole path over to
the target and restore from that path, as in:
db2 backup db <dbname> to X:\backup .....
The path built wil be:
X:\backup\dbname.0\instancename\node0000\catn0000\ 20041007\hhmmss.001
Move all that path to target system, then:
restore <dbname> ... from x:\backup taken at 20041007hhmmss ....

HTH, Pierre

Fabius wrote:
Hello all.
I need transfer a db2 database ( tables, records ecc. ) from a server1 to
server2.
The operating system of server1 and server2 is win2000 server.
I have installed db2 to server2. Now how can i copy the database from
server1 to server2 ?
Can i simple copy the directory db2 and all subdirs ?

Thanks and best regards

Fabio


--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot com
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Catherine Jo Morgan | last post: by
7 posts views Thread by lgbjr | last post: by
4 posts views Thread by JIM.H. | last post: by
8 posts views Thread by Abandoned | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.