PQ84215: CAN NOT REMOVE NODE AFTER DB2 FIXPACK UPGRADE

APAR status
Closed as program error.

Error description
When removing node from websphere cluster, websphere work load
manager invoke the executeQuery method with an SQL statement
to perform an update.  DB2 versions before Fixpak 6 and later
fixpak does not allow the the use of executeQuery.
ExecutePreparedUpdate need to be implemented.
Local fix
NO local fix.
Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server users of WLM    *
*                 or Workload Management.                      *
****************************************************************
* PROBLEM DESCRIPTION: When attempting to remove a node from   *
*                      a domain an SQL exception is thrown.    *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
When attempting to remove a node from a domain an SQL
exception is thrown.  The following is an example of the error
that occurs when trying to remove a node from a domain.

StaleConnecti A CONM7007I: Mapping the following SQLException,
with ErrorCode -99,999 and SQL State S1000, to a
StaleConnectionException: COM.ibm.db2.jdbc.DB2Exception:
[IBM][JDBC Driver] CLI0637E  QUERY cannot be found.at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator
.throwInvalidQueryError(SQLExceptionGenerator.java
(Compiled Code))
at COM.ibm.db2.jdbc.app.DB2PreparedStatement
.executeQuery(DB2PreparedStatement.java(Compiled Code))

at com.ibm.ejs.cm.cache.CachedStatement
.executeQuery(CachedStatement.java(CompiledCode))

at com.ibm.ejs.cm.proxy.StatementProxy
.executeQueryCommon(StatementProxy.java(CompiledCode))

at com.ibm.ejs.cm.proxy.PreparedStatementProxy
.executeQuery(PreparedStatementProxy.java(CompiledCode))

at com.ibm.ejs.sm.util.db.DBMgr
.executePreparedQuery(DBMgr.java(Compiled Code))

at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl
.updateTablesOnServerDelete(WLMBootstrapImpl.java:800)

at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl
.serverDeleted(WLMBootstrapImpl.java:185)

at com.ibm.ejs.sm.beans.NodeBean.ejbRemove(NodeBean.java:549)

at
com.ibm.ejs.container.EntityBeanO.remove(EntityBeanO.java:887)

at com.ibm.ejs.container.EJSContainer
.removeBean(EJSContainer.java(CompiledCode))

at com.ibm.ejs.container.EJSWrapper.remove(EJSWrapper.java:330)

at com.ibm.ejs.sm.beans._Node_Stub.remove(_Node_Stub.java:225)
at com.ibm.ejs.sm.beans.RepositoryObjectImpl
...
...
Problem conclusion
The wrong SQL statement was being used.
Temporary fix
There is no temporary fix for this problem.
Comments
APAR information
APAR number PQ84215
Reported component name WEBSPHERE AE AI
Reported component ID 5630A2200
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2004-02-04
Closed date 2004-06-09
Last modified date 2004-06-09

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
wlm          

Fix information

Applicable component levels
R400 PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > General
Operating system(s):
Software version: 400
Software edition:
Reference #: PQ84215
IBM Group: Software Group
Modified date: Jun 9, 2004