Topic
5 replies Latest Post - ‏2013-10-15T20:30:58Z by Amyris
Alex2099
Alex2099
3 Posts
ACCEPTED ANSWER

Pinned topic Transfert a DB with DB2 Windows to DB2 Linux ?

‏2013-09-19T07:17:38Z |

Hi,

I need to transfer a DB with DB2/Windows to DB2/Linux.

I thought about doing a backup then restore it under DB2/Linux.

Could you please tell me if that will work or should I do it differently ?

Thank you for your help.

  • 9RYQ_Kiran_mk
    9RYQ_Kiran_mk
    78 Posts
    ACCEPTED ANSWER

    Re: Transfert a DB with DB2 Windows to DB2 Linux ?

    ‏2013-09-19T09:03:35Z  in response to Alex2099

    Nope. Backup and Restore will not work. 

    You can use db2mov utility to transfer all the tables and other objects.

     

    Best Regards,

    Kiran.M.K.

    • Alex2099
      Alex2099
      3 Posts
      ACCEPTED ANSWER

      Re: Transfert a DB with DB2 Windows to DB2 Linux ?

      ‏2013-09-19T11:40:17Z  in response to 9RYQ_Kiran_mk

      Hi,

      Thank's a lot for your answer.

      I have never used this utility (i am not a dba) but will google it.

      Cheers,

      Alex

      • nivanov1
        nivanov1
        231 Posts
        ACCEPTED ANSWER

        Re: Transfert a DB with DB2 Windows to DB2 Linux ?

        ‏2013-09-19T11:53:14Z  in response to Alex2099

        First, db2look to extract the schema.

        Next, create the schema in the target, using the extracted script.

        Next, extract data using db2move export.

        Finally, load data using db2move load.

        • Alex2099
          Alex2099
          3 Posts
          ACCEPTED ANSWER

          Re: Transfert a DB with DB2 Windows to DB2 Linux ?

          ‏2013-09-20T11:29:48Z  in response to nivanov1

          Hi Nick,

          Thank's a lot for your detailed answer and the links !

          If you don't mind i will prepare the command that i will run step by step, and if you have time, you can tell me if that looks correct for you.

          Cheers,

  • Amyris
    Amyris
    12 Posts
    ACCEPTED ANSWER

    Re: Transfert a DB with DB2 Windows to DB2 Linux ?

    ‏2013-10-15T20:30:58Z  in response to Alex2099

    Alex,

    This topic in the Information Center might help you. It explains how to use db2look and db2move:

    http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.qb.upgrade.doc/doc/t0053156.html

     

    However, the topic is for creating testing databases with a subset of data. So you have to modify the db2move command to extract all data and not just a subset.

     

    Hope this helps,

    Amyris