469,609 Members | 1,574 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Transport database to another system

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 ....
Mar 12 '08 #1
6 5811
sakumar9
127 Expert 100+
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
Mar 12 '08 #2
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?
Mar 14 '08 #4
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.
Mar 18 '08 #5
docdiesel
297 Expert 100+
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:

Expand|Select|Wrap|Line Numbers
  1. yourpc> db2 backup mydbname to c:\some\path\
  2. collpc> db2 restore db mydbname from x:\usb\stick\
Regards,

Bernd
Mar 18 '08 #6
sakumar9
127 Expert 100+
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
Mar 19 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Lori McDonald | last post: by
5 posts views Thread by Nathan Sokalski | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.