Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009

    Question Unanswered: Migrating from 9.5 LUW to 8.0 z/OS

    I'm fairly new to DB2, but I've been asked to assist in porting our DB2 setup from 9.5 on Windows to 8.0 on z/OS. I realize full well that there are many commands/features that aren't supported going backwards like this. That actually isn't my problem. The task at hand that I need help with is: What is the suggested/easiest way to move the schema/data to z/OS?

    I've been googling around a lot and found _tons_ of information on how to export from z/OS to LUW but not the reverse. In fact someone else just built a ton of IXF files with everything in it, but I read last night that IXF LUW is not the same as IXF z/OS. Is there any conversion software?

    Any info at all, even just a general direction to point me in would be appreciated. Thanks in advance.

  2. #2
    Join Date
    May 2009
    Provided Answers: 1
    ShakataGaNai, Here are some very basic steps I would take:

    Use DB2LOOK to generate the DDL. You will need to create your own Database and Table space DDL and create Stogroups as these z/OS items do not have matching/compatible DDL. The tables, Indexes, Constraints should be pretty close without much change. You will need to reference Database, Tablespace, and Stogroups in the Table and/or Indexes.

    To move the data, one of the easiest ways is to unload in CSV format. These files can be transferred to z/OS and loaded to the tables. If you can connect the two systems (you will need DB2 Connect), you can load the tables with a cursor (but I think the CSV/Transfer/Load will be faster).

    There is more involved around Authorizations and Stored Procedures / Functions and these can introduce some problems. For example, if any of your SQL uses OLAP functions, they are not available in z/OS v8 (I think they are available in z/OS v9 but haven't checked).

Posting Permissions

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