Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2015
    Posts
    24

    Answered: Migration of tables from DB2 to ORACLE

    Hi,

    Is there a way to migrate DB2 database tables on mainframes to Oracle tables on solaris.??

    Either through tools or through COBOL anything cold be useful.

    Tables are of very large size..
    Largest table is with records 40million..

    Any reference on this will also be helpful.

    Thanks in advance

  2. Best Answer
    Posted by przytula_guy

    "IBM/DB2 has probably no tool that can help you doing this (going away from DB2)
    you could export the ddl from mainframe-adapt to oracle and apply
    export the data in csv format in mf - convert to ascii on solaris - import in ora..
    maybe other vendors (like ORA) have some tools for this .. check for tools at target DB vendor/supplier.."


  3. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    IBM/DB2 has probably no tool that can help you doing this (going away from DB2)
    you could export the ddl from mainframe-adapt to oracle and apply
    export the data in csv format in mf - convert to ascii on solaris - import in ora..
    maybe other vendors (like ORA) have some tools for this .. check for tools at target DB vendor/supplier..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #3
    Join Date
    Feb 2015
    Posts
    24
    @przytula_guy

    Thanks for the reply

Posting Permissions

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