SQLCODE-104 after migrating from WebSphere Application Server V4 to WebSphere Application Server V5
 Technote (troubleshooting)
 
Problem(Abstract)
The following errors display when running an application in WebSphere® Application Server for z/OS® version 5.0

SQLException(1): sqlcode=-104 sqlstate=42601 message=DB2JDBCCursor

Received Error in Method prepare:SQLCODE==> -104 SQLSTATE ==> 42601
Error Tokens ==> <<DB2 7.1 SQLJ/JDBC>> ! < > = <> <= ]< ]> ]= >= ?< ?>
?= IN NOT
com.ibm.db2.jcc.DB2SQLException: DB2JDBCCursor Received Error in Method
prepare:SQLCODE==> -104 SQLSTATE ==> 42601 Error Tokens ==> <<DB2 7.1
COM.ibm.db2os390.sqlj.jdbc.DB2SQLJJDBCCursor.setError(DB2SQLJJDBCCursor.
java:1232)
COM.ibm.db2os390.sqlj.jdbc.DB2SQLJJDBCSection.prepare(DB2SQLJJDBCSection
.java:767)
COM.ibm.db2os390.sqlj.jdbc.DB2SQLJConnection.prepareStatement(DB2SQLJCon
nection.java:1360)
COM.ibm.db2os390.sqlj.jdbc.DB2SQLJConnection.prepareStatement(DB2SQLJCon
nection.java:1470) Page
com.ibm.db2.jcc.DB2LogicalConnection.prepareStatement(DB2LogicalConnecti
on.java:487) of
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnec tion.java:1393)
 
Cause
Missing DB2® library SDNSEXIT in steplib
 
Resolving the problem
Place the DB2 modules, SDNSEXIT and SDSNLOAD, in your WebSphere Application Server steplib.
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers WebSphere Application Server for z/OS Migration OS/390, z/OS 5.0, 5.1 Enterprise
 
 


Document Information


Current web document: swg21173903.html
Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server for z/OS > DB Connections/Connection Pooling
Operating system(s): z/OS
Software version: 5.1
Software edition:
Reference #: 1173903
IBM Group: Software Group
Modified date: Jul 8, 2004