Topic
  • 5 replies
  • Latest Post - ‏2012-05-15T12:50:13Z by SystemAdmin
SystemAdmin
SystemAdmin
708 Posts

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

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

    ‏2012-03-14T15:59:10Z  
    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

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

    ‏2012-03-14T15:59:42Z  
    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.
    My typos.

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

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

    ‏2012-03-15T06:26:08Z  
    My typos.

    I never tested tool with DB2 7.x
    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

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

    ‏2012-03-20T08:29:23Z  
    My typos.

    I never tested tool with DB2 7.x
    got any result? Any help would be appreciated.
  • SystemAdmin
    SystemAdmin
    708 Posts

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

    ‏2012-05-15T12:50:13Z  
    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.