Hello,
You can move DB2 DB from one platform to the other by using the db2move
utility:
1- db2move dbName export * *Please check the options of the commend for
BLOB**
2- Create a blanc DB on the destination box then run
db2move dbName import -io replace_create ** This will create and insert
all tables previously exported**

Note: db2move does not export stored procedures so you can use db2look
utility

Exporting fast but the import process can be very long about 5 hours for 1GB
of data.
Your exported files are in the ibm\db2\bin by default move them on separate
disk from the DB disk on your destination box then run the import process
from the folder where you have your files. The reason of using to disks is
for I/O perfomance (1 GB exported data will take much less than 5 hours to
load). That my experience.

Cheers

Fadjo

----- Original Message -----
From: "David Cuffee "
<db2udbdba-ezmlmshield-x46483955.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, August 26, 2004 7:55 PM
Subject: Copying Database from Linux to Windows Server


> I have two DB2 Servers. One is a Windows 2003 server and the other is
> p-series running RedHat Enterprise Linux 3. Both servers are running DB2
UDB
> v8.1 fixpak 6 (windows 2003) fixpak 7 (linux).
>
> I would like to copy the entire database (tables, Stored Procedures, etc)
> from the Windows 2003 server to the Linux server.
>
> How do I go about doing this?
>
> The Database name on the Windows 2003 server is WINSTSDB and I want all
the
> information copied into a database on the Linux server called WINSAVE.
>
> Thanks,
> David
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


DB2 & UDB email list listserv db2-l LazyDBA home page