Hi,

First run db2look command from window server:
db2look -d WINSTSDB -e -a -l -xd -f -o WINSTSDB.out

then use db2move to move all the data :
db2move WINSTSDB EXPORT

Now got to your Linux server:
FTP all these files from window to your linux box.
Now login as instance owner
issue the following commands :

db2 create db WINSAVE
db2batch -d WINSAVE -f WINSTSDB.out
db2move WINSAVE LOAD

Hope this helps
Yogesh Kansal


thirumaran <db2udbdba-ezmlmshield-x1456459.[Email address protected] wrote:Dear david,

You can take a full backup thorugh 1) control center , 2) command windows
"backup database" command
3) use DB ARTISIAN which extract all objects as .sql file run this file on
all os windows/unix/AIX .(Eval is also available)

thanks
thiru



----- Original Message -----
From: "David Cuffee "
Sent: Friday, August 27, 2004 5:25 AM
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




"The degree of normality in a database is inversely proportional to
that of its DBA"

---------------------------------
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.

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