Topic
  • 1 reply
  • Latest Post - ‏2012-07-06T13:18:19Z by SystemAdmin
SystemAdmin
SystemAdmin
708 Posts

Pinned topic Getting error: No user schema found in your database

‏2012-07-06T09:18:53Z |
I'm getting error: No user schema found in your database while trying to connect to DB2 10 on Z/os.

Log:
http://2012-07-06 14.37.58.862 Driver com.ibm.db2.jcc.DB2Driver loaded
http://2012-07-06 14.37.58.907 Database Product Name :DB2
http://2012-07-06 14.37.58.917 Database Product Version :DSN10015
http://2012-07-06 14.37.58.917 JDBC driver IBM DB2 JDBC Universal Driver Architecture
Version = 3.61.65
http://2012-07-06 14.37.58.917 Database Major Version :10
http://2012-07-06 14.37.58.917 Database Minor Version :1
http://2012-07-06 14.37.58.917 Connection to local zdb2 succeeded.
http://2012-07-06 14.37.58.927 Driver com.ibm.db2.jcc.DB2Driver loaded
http://2012-07-06 14.37.58.987 Database Product Name :DB2
http://2012-07-06 14.37.58.987 Database Product Version :DSN10015
http://2012-07-06 14.37.58.987 JDBC driver IBM DB2 JDBC Universal Driver Architecture
Version = 3.61.65
http://2012-07-06 14.37.58.987 Database Major Version :10
http://2012-07-06 14.37.58.987 Database Minor Version :1
com.ibm.db2.jcc.am.SqlException: jcct41026410602http://3.61.65 The required s
tored procedure is not installed on the server. Contact your DBA. ERRORCODE=-44
72, SQLSTATE=null
at com.ibm.db2.jcc.am.ed.a(ed.java:660)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:120)
at com.ibm.db2.jcc.am.jc.a(jc.java:7804)
at com.ibm.db2.jcc.am.jc.Zd(jc.java:6401)
at com.ibm.db2.jcc.am.jc.getSchemas(jc.java:6329)
at ibm.IBMExtractUtilities.GetSchemaList(IBMExtractUtilities.java:2128)
Updated on 2012-07-06T13:18:19Z at 2012-07-06T13:18:19Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: Getting error: No user schema found in your database

    ‏2012-07-06T13:18:19Z  
    The SP which are required for JDBC are not properly installed on mainframe. Contact your mainframe DBA.