Transport database to another system

[crazyspider4u]

hello....
i have created one database with 24 tables on my sytem and now i wanna transport it to another system....problem is how to export it and how to import it another system


please explain ....

[sakumar9]

You can use db2move command to do this.

Refer to this link for more details and examples:
http://publib.boulder.ibm.com/infocenter....doc/doc/r0002079.html

Regards
-- Sanjay

[sakumar9]

Some more links you might want to have a look:

http://publib.boulder.ibm.com/infocenter/...dbobj.doc/doc/r0052064.html

http://publib.boulder.ibm.com/infocenter/.../r0024482.html

Regards
-- Sanjay

[crazyspider4u]

but the links refer to move command of pc which are connected but my pc's are nt connected ones in my college and other in my home...

i created table in default user space...

now i wanna transport it from my home pc to college pc how?

[db2dbdba]

but the links refer to move command of pc which are connected but my pc's are nt connected ones in my college and other in my home...

i created table in default user space...

now i wanna transport it from my home pc to college pc how?

try db2look -db urdbaname -l -x -e -f -o filename.
You can use this file to create database.
But you first have to create a database with the same name in your home system.

[docdiesel]

Hi,

assuming that you and your colleague are both using a Windows PC, you could transport the database as backup file and restore it on the remote pc: Open a db2 command line windows (db2cmd) and make a backup on your pc. Perhaps you like to zip/compress the file with some tool before copying it to cd or usb stick - depending in its size. Then on the other pc just restore it from db2cmd window:

yourpc> db2 backup mydbname to c:\some\path\
collpc> db2 restore db mydbname from x:\usb\stick\

Regards,

Bernd

[sakumar9]

Another possibility, if you can catalog your database (from one system to another), then you can use db2move utility.

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/...r0002079.html


Regards
-- Sanjay