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.
5 replies Latest Post - ‏2012-05-15T12:50:13Z by SystemAdmin
SystemAdmin
SystemAdmin
708 Posts
ACCEPTED ANSWER

Pinned topic use DMT connect to db2 v7 get error "no user schema found in your database"

‏2012-03-14T05:32:49Z |
hello~

I tried to use DMT on windows to connect db2 v7 on AIX, and I got the error "no user schema found in your database". In the command windows showed below. Any help would be appreciated.

JAR file 'C:\Program Files\IBM\SQLLIB\java\db2jcc.jar' found
JAR file 'C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cu.jar' found
http://2012-03-14 12.23.45.512 Driver com.ibm.db2.jcc.DB2Driver loaded
http://2012-03-14 12.23.45.668 Database Product Name :DB2/6000
http://2012-03-14 12.23.45.684 Database Product Version :SQL07029
http://2012-03-14 12.23.45.684 JDBC driver IBM DB2 JDBC Universal Driver Architecture
Version = 2.3.63
http://2012-03-14 12.23.45.684 Database Major Version :7
http://2012-03-14 12.23.45.684 Database Minor Version :2
http://2012-03-14 12.23.45.699 Driver com.ibm.db2.jcc.DB2Driver loaded
http://2012-03-14 12.23.45.730 Database Product Name :DB2/6000
http://2012-03-14 12.23.45.730 Database Product Version :SQL07029
http://2012-03-14 12.23.45.730 JDBC driver IBM DB2 JDBC Universal Driver Architecture
Version = 2.3.63
http://2012-03-14 12.23.45.730 Database Major Version :7
http://2012-03-14 12.23.45.730 Database Minor Version :2
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -10013, SQLSTATE: null,
SQLERRMC: /home/db2inst1/sqllib/function/SYSIBM.SQLTABLES
at com.ibm.db2.jcc.b.zc.d(zc.java:1351)
at com.ibm.db2.jcc.a.db.l(db.java:366)
at com.ibm.db2.jcc.a.db.e(db.java:102)
at com.ibm.db2.jcc.a.r.e(r.java:72)
at com.ibm.db2.jcc.a.sb.i(sb.java:194)
at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
at com.ibm.db2.jcc.b.bd.U(bd.java:188)
at com.ibm.db2.jcc.b.s.a(s.java:7833)
at com.ibm.db2.jcc.b.s.Wd(s.java:6428)
at com.ibm.db2.jcc.b.s.getSchemas(s.java:6355)
at ibm.IBMExtractUtilities.GetSchemaList(IBMExtractUtilities.java:2120)
at ibm.StateExtractTab.actionPerformed(StateExtractTab.java:857)
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 Sour
ce)
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$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Sour
ce)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Sour
ce)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Sour
ce)
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)
Updated on 2012-05-15T12:50:13Z at 2012-05-15T12:50:13Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    708 Posts
    ACCEPTED ANSWER

    Re: use DMT connect to db2 v7 get error "no user schema found in your database"

    ‏2012-03-14T15:59:10Z  in response to SystemAdmin
    This is probably due to the fact that IDMT hides known schema or this could be DB2 7 issue since I never tested tool with DB2 9.7.

    This could be a simple fix.

    Post your db2level and I will see if I can find that db2.
    • SystemAdmin
      SystemAdmin
      708 Posts
      ACCEPTED ANSWER

      Re: use DMT connect to db2 v7 get error "no user schema found in your database"

      ‏2012-03-14T15:59:42Z  in response to SystemAdmin
      My typos.

      I never tested tool with DB2 7.x
      • SystemAdmin
        SystemAdmin
        708 Posts
        ACCEPTED ANSWER

        Re: use DMT connect to db2 v7 get error "no user schema found in your database"

        ‏2012-03-15T06:26:08Z  in response to SystemAdmin
        hqflo:/home/db2inst2>db2level
        DB21085I Instance "db2inst2" uses DB2 code release "SQL07029" with level
        identifier "030A0105" and informational tokens "DB2 v7.1.0.98", "s040510" and
        "U497037".
        thanks
      • SystemAdmin
        SystemAdmin
        708 Posts
        ACCEPTED ANSWER

        Re: use DMT connect to db2 v7 get error "no user schema found in your database"

        ‏2012-03-20T08:29:23Z  in response to SystemAdmin
        got any result? Any help would be appreciated.
  • SystemAdmin
    SystemAdmin
    708 Posts
    ACCEPTED ANSWER

    Re: use DMT connect to db2 v7 get error "no user schema found in your database"

    ‏2012-05-15T12:50:13Z  in response to SystemAdmin
    In the IBMDataMovementTool.jar file, please see ExcludeSchema.properties file and it has a list of schema to be excluded from the extract and mostly those are system schema which have nothing to do with actual data schema. Chances are that you do not have actual schema to extract.