Skip to Content
avatar image
Former Member

DB2 V8 Database copy from windows to AIX

Hi,

I want to setup a clone of my DB2 v8 database on windows 2000 on a AIX 5.3 server via TSM.

Has someone already done this kind of backup / restore ?

Thanks in advance

Yves

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 26, 2006 at 03:14 PM

    Hi Yves,

    it is not possible to usebackup/restore to clone databases between Windows and AIX, because of the different endiness.

    If you want to clone your db from Windows to AIX, you have to perform a so called heterogeneous system copy, which is described in a SAP guide.

    Regards, Jens

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 26, 2006 at 03:49 PM

    Yves,

    just as an addition: the SAP Guide mentioned above by Jens is available under

    http://service.sap.com/instguideshttp://service.sap.com/instguides">http://service.sap.com/instguides>

    Navigate to your SAP Release and then choose 'Installation'. For newer releases there are different Guides for ABAP and Java. The Guide for a 'Heterogeneous System Copy' with SAP Netweaver 04 SR1 is e.g. available

    herehttps://service.sap.com/~sapidb/011000358700009331552004E">here>.

    Regards,

    Johannes

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 11, 2006 at 07:46 AM

    I just recently did a system copy (SAP ECC 6.0) from Windows 2003 to AIX 5.3 via sapinst (db export/load), it worked perfectly without any errors - the tools has really improved in the latest NetWeaver sapinst ...

    The only downside of using db export, is that the source should be shut down, or at least have no activity on the system, so ensure data consistency in the target system.

    /Frank

    Add comment
    10|10000 characters needed characters exceeded