Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2012-06-14T19:54:57Z by jbwithers
SystemAdmin
SystemAdmin
708 Posts
ACCEPTED ANSWER

Pinned topic DMT not migrating private synonyms, triggers

‏2012-05-24T04:58:41Z |
Version 2.00-b2118

http://2012-05-23 21.25.25.291 Database Product Version :Oracle Database 10g Express Edition Release
10.2.0.1.0 - Production
http://2012-05-23 21.25.25.292 JDBC driver Oracle JDBC driver Version = 11.2.0.3.0

> db2set
DB2_COMPATIBILITY_VECTOR=ORA
DB2COMM=TCPIP
DB2AUTOSTART=YES

In file IDMTConfig.properties I set:
db2_compatibility=true

but after start Extract DATA/DDL log contains:
http://2012-05-23 21.25.20.320 OUTPUT_DIR is : /home/db2inst/IBMDataMovementTool/migr
http://2012-05-23 21.25.20.323 Configuration file loaded: '/home/db2inst/IBMDataMovementTool/migr/IDMTConfig.properties'
http://2012-05-23 21.25.20.373 Missing values for dstDBRelease in the property file
http://2012-05-23 21.25.20.374 debug : False
http://2012-05-23 21.25.20.374 Encoding : UTF-8
http://2012-05-23 21.25.20.374 sqlFileEncoding : UTF-8
http://2012-05-23 21.25.20.374 RetainColName : True
http://2012-05-23 21.25.20.374 graphic : False
http://2012-05-23 21.25.20.374 loadstats : False
http://2012-05-23 21.25.20.374 norowwarnings : False
http://2012-05-23 21.25.20.374 dstDBName : INSLOAN
http://2012-05-23 21.25.20.374 customMapping : false
http://2012-05-23 21.25.20.375 db2_compatibility : False
..

at the end:
http://2012-05-23 21.34.23.390 done Blade_4
http://2012-05-23 21.34.23.426 Starting extract of other metadata. Please wait ....
http://2012-05-23 21.34.23.426 db2_compatibility is turned off. You may see limited objects extracted.
http://2012-05-23 21.34.23.712 Work completed

file db2synonyms.sql is empty

  • This file was generated on : 05-23-2012 21:25:23
  • IBM Data Movement Tool Version : 2.00-b2118
--
  • This script contains synonyms extracted and it is part of the deployment script.
  • The contents of the file will also be loaded in GUI interactive deployment.

File with triggers not created.

Please help
Updated on 2012-06-14T19:54:57Z at 2012-06-14T19:54:57Z by jbwithers
  • jbwithers
    jbwithers
    2 Posts
    ACCEPTED ANSWER

    Re: DMT not migrating private synonyms, triggers

    ‏2012-06-14T19:54:57Z  in response to SystemAdmin
    I am having the same issues with IDMT. I have followed all of the directions in this paper

    http://www.ibm.com/developerworks/data/library/techarticle/dm-0906datamovement/#N1051C

    My instance is set in compatibility mode but it does not seem to recognize it.