473,836 Members | 2,221 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to export/import DB2 database

2 New Member
I want to export my DB2 version 8 database to another DB2 version 9 database. Can someone tell me the commands to do so? I did research on the net before asking this question but all I found are related to extracting data from a table to an OS file. I want to be able to export a whole database. Thanks for any thoughts.
Apr 4 '08 #1
3 27017
SuperKuper
7 New Member
Research on the net is nice, but reliable information is in DB2 documentation (http://www-1.ibm.com/support/docview...d=swg27009552). There is no concept of "exporting a database" in DB2. You can export one table at a time (see command EXPORT) and IMPORT or LOAD into another database. You can also do a BACKUP for the entire database and RESTORE (perhaps REDIRECTed). You can also set up federated nicknames and LOAD directly from one database to another (also one table at a time).
Apr 5 '08 #2
kjwchu
2 New Member
Thanks for correcting me. Could you repost the DB2 documentation link? The link you posted is error.
Apr 6 '08 #3
docdiesel
297 Recognized Expert Contributor
Hi,

for using the link posted by SuperKuper just delete the final ")" in the URL. Besides, there's a way to move parts of or a whole databases from one DB2 to another without using backup/restore. First you'll have to use "db2look" to extract the definitions of the database objects (tables, indexes ,...) and then run the resulting sql/ddl script against the destination database. Then you may move the data by exporting and importing/loading with "db2move".

Have a look at an older post here in bytes.com at http://bytes.com/forum/thread781679-db2move.html . The article at IBM website at http://www-128.ibm.com/developerwork...nyk/index.html may be useful, too.

Regards,

Bernd
Apr 7 '08 #4

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

Similar topics

3
2376
by: Bennett Haselton | last post by:
I'm working on an ASP.Net project where I want to test code on a local machine using a local database as a back-end, and then export it to the production machine where it uses the hosting provider's SQL Server database on the back-end. Is there a way to export tables from one SQL Server database to another in such a way that if a table already exists in the destination database, it will be updated to reflect the changes to the local...
6
33842
by: Oliver Stratmann | last post by:
Hello all, is there another way to export data to a csv-file (comma-separated format)? We tried the EXPORT-command and got the following error " SQL1325N The remote database environment does not support the command or one of the command options. Explanation: An attempt has been made to issue a DB2 workstation database specific command or command option against a host database through DB2
3
4020
by: Iavor Raytchev | last post by:
Hello, We a situation with a central database that contains the data that needs to be presented at N off-line terminals (N can be 5 000 can be 15 000). Each terminal presents unique data. The central database is used for data preparation. Then the data for each terminal is exported as separate SQL file. The terminals run the same application that is used to prepare the data - only in user mode. So what we do is - we export the full database...
7
33424
by: phillip.s.powell | last post by:
We're looking at a GUI interface for our MySQL DB and I am interested in MySQL Administrator, however, one of our requirements is to be able to import/export databases. Is this possible or do I need to know else (e.g. Navicat)? Thanks Phil
2
17054
by: mike_dba | last post by:
I am attempting to move data between 2 DB2 Linux databases using a pipe. I can't seem to get it working. Any assistance is appreciated. I first issue: mkfifo -m777 mypipe db2 "connect to src_db" db2 "export to mypipe of DEL MODIFIED BY COLDEL, MESSAGES exp.msg select * from myschema.old_table"
0
19191
by: jen78 | last post by:
Hi, I am new to Oracle administration and hope someone can help me out on this as i am struggling to make it work.... I am doing development work using oracle database on my own development pc.. the oracle database is installed locally on my pc... how should i port the whole database (including tables, pl sql, triggers, indexes, etc) to another server after all development/testing is completed? I have tried using toad function (DBA ->...
5
31930
by: Simon | last post by:
Dear reader, With the export command you can export a query to Excel. By activate this command a form pop's up with the following text:
0
9967
by: A3AN | last post by:
Hi. I receive a database backup on a daily basis. I then import this dump on another server which I use for software development. There is two db's being hosted on this server. We test software upgrades against these two db's. The "refresh" needs to be completed at least once a day, sometimes 4-5 times a day. I need the quickest way of doing this task. I have extremely limited knowledge on scripting. What I need is something that I can just...
5
2504
by: Harris Kosmidhs | last post by:
Hello there, I have access to a DB2 database through operation navigator. What I would like to do is find a tool to export the database into create table, insert into statements. Like what phpmyadmin does. Is there a free tool for such a job? Thanks
0
2895
by: kkshansid | last post by:
i cannot export my sql server database to msaccess database which i usually did successfully 3weeks ago pls help me to find the error so that i can correct it in future error is - Validating (Error) Messages * Error 0xc02020f6: Data Flow Task: Column "Project ID" cannot convert between unicode and non-unicode string data types. (SQL Server Import and Export Wizard)
0
9656
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10821
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10575
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9358
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6975
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5642
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5812
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4001
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3102
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.