Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2010
    Posts
    11

    Unanswered: IXF backward compatability from DB2 v9.7 to v9.1.

    I am trying to db2move a database created in DB2 9.7 to DB2 9.1 but I can't. Firstly, 9.1 does not understand all of the syntax in the file generated by v9.7 db2look and secondly, I'm pretty sure IDENTITY columns are a problem as well when trying to do a straight move.

    Systems used - Windows 2008R2, DB2 v9.7P3, v9.1P4.

    Is there a workaround?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I suspect you will just have to fix the DDL where it is not compatible with previous release.

    For identity columns, I exclude them from db2move and load them back with identity override option on load command. Other option is to change them to "generated by default" instead of "generated always" in the new DDL.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    AFAIK, ixf generated on 9.7 is compatible to load into 9.1

    As Marcus suggested, syntax of db2look has to be checked ..
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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