Results 1 to 6 of 6
  1. #1
    Join Date
    May 2009
    Posts
    3

    Unanswered: IBM Mainframe DB2 Migration to DB2 UDB for windows

    I need some information on how Migration activity can be planned to Migrate from Mainframe DB2 to DB2 UDB for Windows.

    If you have any documents, pdf or any links where in the required information is provided please provide it.

    Thanks and regards,
    Srini

  2. #2
    Join Date
    Feb 2009
    Posts
    114
    I would use MS Project for this purpose

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you can do it, the best way to move the data is to catalog the remote DB2 z/OS database from a Linux or Windows DB2 client and export the tables in IXF format from the client. You may have to do a remote bind of DB2 client CLI and utility packages to the DB2 z/OS subsystem (use the Configuration Assistant).

    For the DDL, I would see if there is a tool you have z/OS that will recreate the DDL and then you can manually make some minor changes to tablespaces, etc. However, the IXF files will create the tables for you, but not any indexes and maybe not in the tablespaces you want.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    May 2009
    Posts
    3
    Hi Marcus,

    How can we go about recreating Indexes in that case? Please reply.

    Also, if you have any document on Migration procedures from DB2 Z/OS to DB2 UDB for windows. Please help to share.

    Regards,
    Srini

  5. #5
    Join Date
    May 2009
    Posts
    3
    Hi Marcus,

    Thanks for your reply.

    In that case, how can we go about for recreating Indexes?

    Also, if you have any documents please share.

    Regards,
    Srini

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Most z/OS shops have a tool that will reproduce the DDL. If you don't have one, you can write a query using the catalog tables to do it (probably SYSIBM.SYSINDEXES, etc). Catalog tables are documented in the appendix of the SQL Reference manual.
    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
  •