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.
No replies
jeaku_mf_db
jeaku_mf_db
1 Post
ACCEPTED ANSWER

Pinned topic IBM DATA MOVEMENT TOOL - Stored Procedure Error

‏2012-07-09T09:45:47Z |
Dear Forum,

We re supporting DB2 V10.1 on Z.OS 1.13. On of our user is trying to connect DB2 on z/os but unfortunately the user is ending up with below error message. Seeing error message : -4472 I tried running up the utility DB2LOB creator but still no luck. I understand the error message says that the stored procedure for JDBC is missing but whereas I could see the stored procedure for JAVA is active under SYS1.PROCLIB(DSN1WLMJ). If someone has already resolved this issue and has a fix for this so please share with me so that I can try resolve.

http://2012-07-09 11.21.27.064 Driver com.ibm.db2.jcc.DB2Driver loaded
http://2012-07-09 11.21.27.105 Database Product Name :DB2
http://2012-07-09 11.21.27.105 Database Product Version :DSN10015
http://2012-07-09 11.21.27.105 JDBC driver IBM DB2 JDBC Universal Driver Architecture
Version = 3.61.65
http://2012-07-09 11.21.27.115 Database Major Version :10
http://2012-07-09 11.21.27.115 Database Minor Version :1
http://2012-07-09 11.21.27.115 Connection to local zdb2 succeeded.
http://2012-07-09 11.21.27.135 Driver com.ibm.db2.jcc.DB2Driver loaded
http://2012-07-09 11.21.27.155 Database Product Name :DB2
http://2012-07-09 11.21.27.155 Database Product Version :DSN10015
http://2012-07-09 11.21.27.155 JDBC driver IBM DB2 JDBC Universal Driver Architecture
Version = 3.61.65
http://2012-07-09 11.21.27.165 Database Major Version :10
http://2012-07-09 11.21.27.165 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: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 Sour
ce)
Jake
SYSTEM PROGRAMMER