Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2009

    Unanswered: data migration from db2 6.1 to db2 9.1

    i need to migrate the datas present in DB2 DataBase 6.1(present in SunOS 5.7) to DB2 9.1(AIX 5.3) ,
    from ibm website it says migration of data between different platform is not possible ,
    plus if you want to migrate a db2 version 7 or earlier , first you have to migrate it to db2 version 8 ,then from db2 8 migrate to db9
    ,so can it possible to simply export the data in IXF file from db2 6.1 and import the same into db2 9.1(seems silly!!!!), or there any tool kits available of data migration ,since all i need is few table data and structure .
    please help me .
    thank you ,

  2. #2
    Join Date
    Aug 2001
    if you just want the data and table structures, then have a look at db2look and export/import/load commands. Or you can use db2move which is a combination of the above two (to some extent) .. Have a look at the features of these commands and make use of the ones that suit your needs.


    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Feb 2009
    thank you very much

Posting Permissions

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