Topic
5 replies Latest Post - ‏2013-10-09T13:31:14Z by FrancisRodrigues
FrancisRodrigues
FrancisRodrigues
4 Posts
ACCEPTED ANSWER

Pinned topic Problem in migrate tables MySQL to DB2 with IBM Migration ToolKit

‏2013-10-04T20:23:23Z |

Dear

I intend to migrate MySQL database to DB2 by company policy but I am experiencing several problems with the tool IBM Migration Toolkit.



The driver stated that db2jcc_license_cu.jar was not loaded, and had already informed in this jar path.


Would you like some help or know a way to migrate at least 200 MySQL to DB2 tables so quickly and effectively.

http://ubuntuforums.org/showthread.php?t=2178452&p=12807277#post12807277

 

  • nivanov1
    nivanov1
    22 Posts
    ACCEPTED ANSWER

    Re: Problem in migrate tables MySQL to DB2 with IBM Migration ToolKit

    ‏2013-10-07T15:03:03Z  in response to FrancisRodrigues

    Apparently you are trying to use the JDBC Type 2 driver, which requires native libraries. You'll have to install at least the complete Data Server Runtime Client package for this to work. However, you should instead use the Type 4 (JCC) driver, as Type 2 connectivity may not be supported by the more recent DB2 servers. The JCC driver is pure Java and does not require any native libraries.

    • FrancisRodrigues
      FrancisRodrigues
      4 Posts
      ACCEPTED ANSWER

      Re: Problem in migrate tables MySQL to DB2 with IBM Migration ToolKit

      ‏2013-10-07T15:56:12Z  in response to nivanov1

      I changed the db2jcc.jar to db2jcc4.jar and zip file but still generated the following errors.

      Mon Oct 07 11:47:50 EDT 2013 ERROR DeploymentExtensionUNO The DB2 Connection to the database HCAMPREV failed (rc=-6) with the following error message:[jcc][10389][12245][4.16.53] Failure in loading native library db2jcct2, java.lang.UnsatisfiedLinkError: no db2jcct2 in java.library.path:  ERRORCODE=-4472, SQLSTATE=null
      Mon Oct 07 11:47:50 EDT 2013 ERROR VERIFICATION The connection to the DB2 database HCAMPREV failed.
      Mon Oct 07 11:47:50 EDT 2013 ERROR VERIFICATION [jcc][10389][12245][4.16.53] Failure in loading native library db2jcct2, java.lang.UnsatisfiedLinkError: no db2jcct2 in java.library.path:  ERRORCODE=-4472, SQLSTATE=null
      Mon Oct 07 11:47:50 EDT 2013 INFO DEPLOYMENTMODEL Deployment completed. rc=-6
       
      • nivanov1
        nivanov1
        22 Posts
        ACCEPTED ANSWER

        Re: Problem in migrate tables MySQL to DB2 with IBM Migration ToolKit

        ‏2013-10-07T16:16:07Z  in response to FrancisRodrigues

        The JDBC URL determines what connectivity type the driver attempts to use. For JCC the URL should look like:

         

        
        jdbc:
        db2://hostname:port/databasename
        
        • FrancisRodrigues
          FrancisRodrigues
          4 Posts
          ACCEPTED ANSWER

          Re: Problem in migrate tables MySQL to DB2 with IBM Migration ToolKit

          ‏2013-10-07T16:24:03Z  in response to nivanov1
          Yes, I tried to use a java class and the connection fails.
          Now, using the migration tool IBM Migration Toolkit had this connection problem that can not solve.

           

          I wonder if there is any extra specification for use.
          I use ubuntu 04.12 in a VirtualBox VM.
           
          1GB RAM
  • FrancisRodrigues
    FrancisRodrigues
    4 Posts
    ACCEPTED ANSWER

    Re: Problem in migrate tables MySQL to DB2 with IBM Migration ToolKit

    ‏2013-10-09T13:31:14Z  in response to FrancisRodrigues
    I export the jars to the CLASSPATH system and the same instance terminal run the tool, yet not I connect to DB2 via the IBM tools.
     
    Only I connect to DB2 database via linux terminal.
    I use ubuntu linux.

     

    Export PATH to TOOLS IBM DB2:
     
    export CLASSPATH=$CLASSPATH:/usr/share/java/mysql.jar:/usr/share/java/db2jcc.jar:/usr/share/java/db2jcc_license_cu.jar:/usr/share/java/sqlj.zip
     
    export PATH=$PATH:/usr/share/java/mysql.jar:/usr/share/java/db2jcc.jar:/usr/share/java/db2jcc_license_cu.jar:/usr/share/java/sqlj.zip
     

    Logs:

    DeploymentExtensionUNO Adding MTK UDFs and JAR to deployment script
    Wed Oct 09 09:18:37 EDT 2013 INFO DeploymentExtensionUNO The creation of the script file (/home/daysoft/DB2MigrationToolKit/projects/hcamprev/Deploy_mtkWizard.sh) succeeded
    Wed Oct 09 09:18:37 EDT 2013 INFO DEPLOYMENTMODEL Number of error messages in DB2 file:
    Wed Oct 09 09:18:37 EDT 2013 INFO DEPLOYMENTMODEL * * 652 Messages of category Input Script Error [20xxxx]
    Wed Oct 09 09:18:37 EDT 2013 INFO DEPLOYMENTMODEL * * 247 Messages of category Translator Warning [60xxxx]
    com.ibm.db2.jcc.am.SqlException: [jcc][10389][12245][3.66.46] Failure in loading native library db2jcct2, java.lang.UnsatisfiedLinkError: no db2jcct2 in java.library.path:  ERRORCODE=-4472, SQLSTATE=null
    at com.ibm.db2.jcc.am.dd.a(dd.java:725)
    at com.ibm.db2.jcc.am.dd.a(dd.java:60)
    at com.ibm.db2.jcc.am.dd.a(dd.java:94)
    at com.ibm.db2.jcc.t2.a.a(a.java:37)
    at com.ibm.db2.jcc.t2.T2Configuration.<clinit>(T2Configuration.java:95)
    at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:435)
    at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:115)
    at java.sql.DriverManager.getConnection(DriverManager.java:620)
    at java.sql.DriverManager.getConnection(DriverManager.java:200)
    at com.ibm.mtk.util.MTKDB2Connection.open(MTKDB2Connection.java:101)
    at com.ibm.mtk.util.MTKDB2Connection.open(MTKDB2Connection.java:73)
    at com.ibm.mtk.model.deployment.MTKDeploymentExtensionUNO.upgradeDB(MTKDeploymentExtensionUNO.java:579)
    at com.ibm.mtk.model.deployment.MTKDeploymentModelElement.deploy(MTKDeploymentModelElement.java:798)
    at com.ibm.mtk.wizard.MTKWizardModel.startTargetDatabase(MTKWizardModel.java:913)
    at com.ibm.mtk.wizard.MTKWizardTaskToRun.startTargetDB(MTKWizardTaskToRun.java:343)
    at com.ibm.mtk.wizard.MTKWizardTaskToRun.access$600(MTKWizardTaskToRun.java:30)
    at com.ibm.mtk.wizard.MTKWizardTaskToRun$ActualTask.<init>(MTKWizardTaskToRun.java:201)
    at com.ibm.mtk.wizard.MTKWizardTaskToRun$1.construct(MTKWizardTaskToRun.java:172)
    at com.ibm.mtk.util.SwingWorker$2.run(SwingWorker.java:128)
    at java.lang.Thread.run(Thread.java:679)
    com.ibm.db2.jcc.am.SqlException: [jcc][10389][12245][3.66.46] Failure in loading native library db2jcct2, java.lang.UnsatisfiedLinkError: no db2jcct2 in java.library.path:  ERRORCODE=-4472, SQLSTATE=null
    at com.ibm.db2.jcc.am.dd.a(dd.java:725)
    at com.ibm.db2.jcc.am.dd.a(dd.java:60)
    at com.ibm.db2.jcc.am.dd.a(dd.java:94)
    at com.ibm.db2.jcc.t2.a.a(a.java:37)
     

     

    Updated on 2013-10-09T13:32:39Z at 2013-10-09T13:32:39Z by FrancisRodrigues