473,390 Members | 1,673 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,390 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 5998
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: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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
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
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

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.