Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2007
    Posts
    3

    Unanswered: Problems on moving db2 dump file generated at Solaris and moved to AIX machine

    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.

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    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
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Feb 2007
    Posts
    3
    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.

  4. #4
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    db2move is the utility u are looking for
    http://www-128.ibm.com/developerwork...nyk/index.html
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  5. #5
    Join Date
    Feb 2007
    Posts
    3
    Thanks Rahul. This is what I am looking.

  6. #6
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •