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

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

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

    ‏2012-07-19T15:37:34Z  
    retainConstraintsName=true

    in IDMTConfig.properties file
  • umm
    umm
    2 Posts

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

    ‏2012-07-19T16:18:38Z  
    retainConstraintsName=true

    in IDMTConfig.properties file
    Perfect. It is creating index with the same names as source now.

    Thanks Vikram.