473,386 Members | 1,798 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,386 software developers and data experts.

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 5996
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

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

Similar topics

0
by: Steve - DND | last post by:
We are continually receiving timeout, and "Unable to write data to the transport connection" errors while using the System.Net.HttpWebRequest class from an ASP.Net web page. Below are the two...
1
by: Muscha | last post by:
Hello, Every now and then my application throw this exception: "Unable to read data from the transport connection" And when I break into the Visual Studio, the thread where it failed has...
2
by: Janna Deegan | last post by:
Hello all, First off, if there is a better place to post for an answer to this question, please feel free to point me there. I have some very strange behavior happening with my System.web.mail...
0
by: Lori McDonald | last post by:
I have code that I am using to sent an HTML email. (see code below) Intermittently I am getting the following error when I try and send an email message from ASP.Net code on my server. 80% of the...
5
by: Shilpa | last post by:
I am getting the following error. A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - The system cannot open the file.) On...
5
by: Nathan Sokalski | last post by:
I am attempting to send an email using ASP.NET 1.1's Mail.SmtpMail.Send() method. My code contains all of the following: Dim mailmsg As New Mail.MailMessage Mail.SmtpMail.SmtpServer =...
0
by: Buddy Home | last post by:
Hello, I'm trying to upload a file programatically and occasionally I get the following error message. Unable to write data to the transport connection: An established connection was aborted...
3
by: Buddy Home | last post by:
Hello, I'm trying to upload a file programatically and occasionally I get the following error message. Unable to write data to the transport connection: An established connection was aborted...
6
Cintury
by: Cintury | last post by:
Hi all, I've developed a mobile application for windows mobile 5.0 that has been in use for a while (1 year and a couple of months). It was developed in visual studios 2005 with a back-end sql...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.