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

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

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

    ‏2013-10-07T15:03:03Z  

    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

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

    ‏2013-10-07T15:56:12Z  
    • nivanov1
    • ‏2013-10-07T15:03:03Z

    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.

    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

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

    ‏2013-10-07T16:16:07Z  

    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
     

    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

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

    ‏2013-10-07T16:24:03Z  
    • nivanov1
    • ‏2013-10-07T16:16:07Z

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

     

    <pre class="pre codeblock" dir="ltr" id="vcc_sp_pre_121" style="font-family: monospace; background-color: rgb(218, 218, 218); padding: 5px; white-space: pre-wrap; word-wrap: break-word; color: rgb(0, 0, 0); font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" tabindex="84"> jdbc: db2://hostname:port/databasename </pre>
    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

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

    ‏2013-10-09T13:31:14Z  
    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