Hi,

I am having DB2 running on Solaris machine.
IJust want to know If I generate a DB2 dump file and If I try to import it on DB2 same version running on AIX machine will there be any issues ( because of change in operating system ) ?

Please let me know any known issues on this and possible errors and problems on doing this.

Thanks
Srikanth.

cant say for sure but i think ixf format will help.
or u can export table with specifing Codepage value.

i assume that by dump files u mean exported file after export on a table

Hi Rahul,

Thanks for the response.
Its not actually export of single table, what I meant for dump is "whole database" for a DB instance includes everything on that instance.
As you mention it can be ixf format but it will contains whole DB ( Tables with data, Triggeres, Sequences, Constraints , Functions and procedures etc....).

Thanks
Srikanth K.

db2move is the utility u are looking for
http://www-128.ibm.com/developerwork...nyk/index.html

Thanks Rahul. This is what I am looking.

You are talking about backups and not dumps? A dump is written be DB2 if the instance should happen to crash, for example.

With DB2 V9 you can move backups pretty much between platforms. There is a restriction that source and target platforms must have the same endianess.

You can backup a DB2 database on Sparc Solaris and restore on AIX, since they are both Big Endian bit order. This is true for V8 or V9.

Please do not call it a dump, since it is done with the DB2 backup command. Do not try to move the file systems using UNIX utilities, etc.