Topic
2 replies Latest Post - ‏2012-07-19T16:18:38Z by umm
umm
umm
2 Posts
ACCEPTED ANSWER

Pinned topic IDMT - Index names changing (zDB2 to DB2 LUW)

‏2012-07-19T15:32:36Z |
I am using IDMT to migrate from DB2 z/OS 9.1.5 to DB2 LUW. The CREATE INDEX statements generated by the tool (b2120) in db2indexes.sql have indexes names totally different from the existing ones in the source database. This used to work fine in version b2114. Is there a setting I need to make to accomplish this?

Any help would be appreciated.
Thanks.
Updated on 2012-07-19T16:18:38Z at 2012-07-19T16:18:38Z by umm
  • SystemAdmin
    SystemAdmin
    708 Posts
    ACCEPTED ANSWER

    Re: IDMT - Index names changing (zDB2 to DB2 LUW)

    ‏2012-07-19T15:37:34Z  in response to umm
    retainConstraintsName=true

    in IDMTConfig.properties file
    • umm
      umm
      2 Posts
      ACCEPTED ANSWER

      Re: IDMT - Index names changing (zDB2 to DB2 LUW)

      ‏2012-07-19T16:18:38Z  in response to SystemAdmin
      Perfect. It is creating index with the same names as source now.

      Thanks Vikram.