Is anyone out there running WM 6.1 on a non-IBM server with a need to connect to DB2 on the mainframe? We recently started getting a lot of errors (see below) and the only way to recover is to restart the IS. We also found that there are no good supported DB23 driver configurations by webMethods and IBM. Let me explain. WebMethods only supports the DB2 type 3 and type 4 drivers when connecting to the mainframe. We are currently using the type 2 driver (because we didn’t know any better - WM does support the type 2 driver when connecting to DB2 on AIX). We can’t use the type 4 driver because our DB2 team requires an encrypted password. The only way to encrypt the password is to get some JCE class files from IBM - but they only support these class files if you’re using the IBM JDK. We can’t use the IBM JDK because we’re running on Sun Hardware and OS and IBM doesn’t support their JDK on non-IBM hardware unless you’re running an IBM product like WebSphere. So that rules out the type-4 driver. The type-3 driver is not appealing to us because it requires another intermediate process (I think it’s called DB2 Connect) which we think is just going to further complicate things and slow down respponse time. Is anyone else in the same situation? We would like WM to support the type 2 driver.
[ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource Connections.JDBC.DB2:MDS. [ADA.1.204] Cannot connect to the database with DataSource class "COM.ibm.db2.jdbc.DB2DataSource". [IBM][JDBC Driver] CLI0600E Invalid connection handle or connection is closed. SQLSTATE=S1000 2006-10-27 08:27:15 EDT [ISC.0088.0001E] SOAPException: [ISS.0088.9134] Exception occurred while processing the body of the message 2006-10-27 08:30:02 EDT [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ADA.1.204] Cannot connect to the database with DataSource class "COM.ibm.db2.jdbc.DB2XADataSource". [IBM][JDBC Driver] CLI0600E Invalid connection handle or connection is closed. SQLSTATE=S1000 2006-10-27 08:30:02 EDT [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ART.117.4012] Adap ter Runtime (Adapter Service): Unable to run adapter service. Error occured when connecting to resource Connections.JDBC.DB2: OMPM_WFD.