Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    1

    Unanswered: DB2 for z/OS Rehosting on Unix

    Hi All,

    Can you suggest any resources/references for migrating the DB2 database (schema and data) from a mainframe box to a Unix box?

    What are the various tools/techniques required to achieve this?

    Thanks for your help.

    Krishna

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    This has been answered several time before in detail. I have done this and I am absolutely convinced that the best way is set up a connection from AIX to the mainframe database using DB2 Connect (if you have version 8.x ESE it comes with a free license) and and then exporting the data in IXF format from the AIX command line (you can also do this on Windows and move the IXF files to AIX later). Then use replace_create on the import/load. You may have to add some of the DDL manually such as foreign keys and some indexes, triggers, SP's, etc.
    Last edited by Marcus_A; 09-15-09 at 05:10.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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