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

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

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

    ‏2013-09-19T09:03:35Z  

    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

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

    ‏2013-09-19T11:40:17Z  

    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.

    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

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

    ‏2013-09-19T11:53:14Z  
    • Alex2099
    • ‏2013-09-19T11:40:17Z

    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

    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

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

    ‏2013-09-20T11:29:48Z  
    • nivanov1
    • ‏2013-09-19T11:53:14Z

    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.

    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

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

    ‏2013-10-15T20:30:58Z  

    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