troubleshooting Question

How to Transfer db2--> db2 across platform (win 2000 --> linux red hat) ?

Avatar of kiddstar
kiddstar asked on
5 Comments1 Solution671 ViewsLast Modified:
i have the db2 installed inside my windows 2000 and linux red hat 7.2. And now i want to move the database inside the windows 2000 to linux red hat, i try using backup restore, it cannot work. So, my friend suggest me using db2move as the following show--
1. using cmd  "db2move sample export" in win 2000
2. copy the whole exported files into linux server
3. using cmd "db2move sample import " in linux
after that i open 1 of the .msg file and see, it show

SQL3104N  The Export utility is beginning to export data to file "tab1.ixf".

SQL3105N  The Export utility has finished exporting "252" rows.

SQL3150N  The H record in the PC/IXF file has product "DB2    02.00", date
"20020905", and time "152327".

SQL3050W  Conversions on the data will be made between the IXF file code page
"1252" and the application code page "819".

SQL3153N  The T record in the PC/IXF file has name "tab1.ixf", qualifier "",
and source "            ".

SQL3109N  The utility is beginning to load data from file "tab1.ixf".

SQL3110N  The utility has completed processing.  "252" rows were read from the
input file.

SQL3221W  ...Begin COMMIT WORK. Input Record Count = "252".      

SQL3222W  ...COMMIT of any database changes was successful.

SQL3149N  "252" rows were processed from the input file.  "252" rows were
successfully inserted into the table.  "0" rows were rejected.  
after that i open the database and see, inside still is an empty database

Can any expert help me?

thank you very much.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros