Topic
2 replies Latest Post - ‏2012-06-30T15:05:11Z by SystemAdmin
SystemAdmin
SystemAdmin
708 Posts
ACCEPTED ANSWER

Pinned topic IBM Data Movement Tool issue....

‏2012-06-29T20:10:19Z |
Hello Grus,
I am trying to use IBM Data Movement Tool for my POC to migrate z/OS DB2 Database to LUW DB2.
I am using following JDBC Drivers.
db2jcc.jar
db2jcc4.jar
db2jcc_license_cisuz.jar

but when I push "Connect to ZBD2" button to connect to z?os database, it gives me following message.
No user schema found in your database.
Following is message from console.

http://2012-06-29 16.03.23.272 Current Version = 2.00-b2119
http://2012-06-29 16.03.23.272 New Available Version = 2.00-b2119
http://2012-06-29 16.03.23.272 Download latest version = http://www.ibm.com/services/forms/preLogin.do?lang=en
_US&source=idmt
JAR file 'C:\Program Files\IBM\DSAC3.1.1\plugins\com.ibm.datatools.db2_2.1.403.v20120228_2105\driver\db2j
cc.jar' found
JAR file 'C:\Program Files\IBM\DSAC3.1.1\plugins\com.ibm.datatools.db2_2.1.403.v20120228_2105\driver\db2j
cc4.jar' found
JAR file 'C:\Program Files\IBM\DSAC3.1.1\plugins\com.ibm.datatools.db2_2.1.403.v20120228_2105\driver\db2j
cc_license_cisuz.jar' found
http://2012-06-29 16.03.41.850 Driver com.ibm.db2.jcc.DB2Driver loaded
http://2012-06-29 16.03.42.537 Database Product Name :DB2
http://2012-06-29 16.03.42.537 Database Product Version :DSN09010
http://2012-06-29 16.03.42.537 JDBC driver IBM DB2 JDBC Universal Driver Architecture Version = 3.63.108
http://2012-06-29 16.03.42.537 Database Major Version :9
http://2012-06-29 16.03.42.537 Database Minor Version :1
http://2012-06-29 16.03.42.537 Connection to local zdb2 succeeded.
http://2012-06-29 16.03.42.584 Driver com.ibm.db2.jcc.DB2Driver loaded
http://2012-06-29 16.03.42.662 Database Product Name :DB2
http://2012-06-29 16.03.42.662 Database Product Version :DSN09010
http://2012-06-29 16.03.42.662 JDBC driver IBM DB2 JDBC Universal Driver Architecture Version = 3.63.108
http://2012-06-29 16.03.42.662 Database Major Version :9
http://2012-06-29 16.03.42.662 Database Minor Version :1
com.ibm.db2.jcc.am.SqlDataException: jcct41027510041http://3.63.108 Unsupported ccsid, encoding, or lo
cale: "Cp037". ERRORCODE=-4220, SQLSTATE=22021
at com.ibm.db2.jcc.am.fd.a(fd.java:671)
at com.ibm.db2.jcc.am.fd.a(fd.java:60)
at com.ibm.db2.jcc.am.fd.a(fd.java:85)
at com.ibm.db2.jcc.am.n.a(n.java:453)
at com.ibm.db2.jcc.t4.dc.a(dc.java:2414)
at com.ibm.db2.jcc.t4.cb.a(cb.java:3419)
at com.ibm.db2.jcc.t4.cb.a(cb.java:1896)
at com.ibm.db2.jcc.t4.cb.b(cb.java:1830)
at com.ibm.db2.jcc.t4.cb.a(cb.java:1796)
at com.ibm.db2.jcc.t4.cb.m(cb.java:590)
at com.ibm.db2.jcc.t4.cb.l(cb.java:349)
at com.ibm.db2.jcc.t4.cb.f(cb.java:98)
at com.ibm.db2.jcc.t4.q.e(q.java:81)
at com.ibm.db2.jcc.t4.sb.k(sb.java:160)
at com.ibm.db2.jcc.am.yn.jb(yn.java:2266)
at com.ibm.db2.jcc.am.zn.b(zn.java:4319)
at com.ibm.db2.jcc.am.CallableStatement.cc(CallableStatement.java:144)
at com.ibm.db2.jcc.am.kc.a(kc.java:7810)
at com.ibm.db2.jcc.am.kc.Zd(kc.java:6412)
at com.ibm.db2.jcc.am.kc.getSchemas(kc.java:6340)
at ibm.IBMExtractUtilities.GetSchemaList(IBMExtractUtilities.java:2120)
at ibm.StateExtractTab.actionPerformed(StateExtractTab.java:878)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.io.UnsupportedEncodingException: Cp037
at sun.io.Converters.getConverterClass(Unknown Source)
at sun.io.Converters.newConverter(Unknown Source)
at sun.io.ByteToCharConverter.getConverter(Unknown Source)
at com.ibm.db2.jcc.am.t.<init>(t.java:10)
at com.ibm.db2.jcc.am.r.a(r.java:10)
at com.ibm.db2.jcc.am.n.a(n.java:449)
... 54 more
http://2012-06-29 16.03.43.990 The error of Unsupported ccsid, encoding, or locale is a known problem.
http://2012-06-29 16.03.43.990 This error occurs mostly due to incorrect JVM on your machine which does not ha
ve proper international language support.
http://2012-06-29 16.03.43.990 Follow these steps:
http://2012-06-29 16.03.43.990 1. Close this tool.
http://2012-06-29 16.03.43.990 2. For Windows:
http://2012-06-29 16.03.43.990 Add this entry in your IBMDataMovementTool.cmd file before java statement
http://2012-06-29 16.03.43.990 SET PATH="C:\Program Files\IBM\SQLLIB\java\jdk\jre\bin\";%PATH%
http://2012-06-29 16.03.43.990 3. For Unix:
http://2012-06-29 16.03.43.990 Add this entry in your IBMDataMovementTool.sh file before java statement
http://2012-06-29 16.03.43.990 For 64 bit:
http://2012-06-29 16.03.43.990 PATH=~/sqllib/java/jdk64/jre/bin:$PATH
http://2012-06-29 16.03.43.990 For 62 bit:
http://2012-06-29 16.03.43.990 PATH=~/sqllib/java/jdk/jre/bin:$PATH
http://2012-06-29 16.03.43.990 4. Re-run the tool. Tool will now use IBM provided JRE that comes with DB2

Let me know if you more informarion.
Updated on 2012-06-30T15:05:11Z at 2012-06-30T15:05:11Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    708 Posts
    ACCEPTED ANSWER

    Re: IBM Data Movement Tool issue....

    ‏2012-06-29T20:53:20Z  in response to SystemAdmin
    No user defined schema means that their is no schema other than default. We hide all system and known schemas that come with database.

    The solution to the other error is given in the error message itself. Please scroll all the way to your console message and the solution is given there right itself.

    2012-06-29 16.03.43.990 The error of Unsupported ccsid, encoding, or locale is a known problem.
    2012-06-29 16.03.43.990 This error occurs mostly due to incorrect JVM on your machine which does not ha
    ve proper international language support.
    2012-06-29 16.03.43.990 Follow these steps:
    2012-06-29 16.03.43.990 1. Close this tool.
    2012-06-29 16.03.43.990 2. For Windows:
    2012-06-29 16.03.43.990 Add this entry in your IBMDataMovementTool.cmd file before java statement
    2012-06-29 16.03.43.990 SET PATH="C:\Program Files\IBM\SQLLIB\java\jdk\jre\bin\";%PATH%
    2012-06-29 16.03.43.990 3. For Unix:
    2012-06-29 16.03.43.990 Add this entry in your IBMDataMovementTool.sh file before java statement
    2012-06-29 16.03.43.990 For 64 bit:
    2012-06-29 16.03.43.990 PATH=~/sqllib/java/jdk64/jre/bin:$PATH
    2012-06-29 16.03.43.990 For 62 bit:
    2012-06-29 16.03.43.990 PATH=~/sqllib/java/jdk/jre/bin:$PATH
    2012-06-29 16.03.43.990 4. Re-run the tool. Tool will now use IBM provided JRE that comes with DB2
    • SystemAdmin
      SystemAdmin
      708 Posts
      ACCEPTED ANSWER

      Re: IBM Data Movement Tool issue....

      ‏2012-06-30T15:05:11Z  in response to SystemAdmin
      Thanks Anabas,

      It solved my problem and now I am not getting that message of No user defined schema message.

      Thanks once again.