PQ72457: SQLCODE -900 AFTER FAILURE IN THE DB2 SUBSYSTEM OR COMMUNICATIONBETWEEN DB/2 INSTANCES. CONNECTION IS NOT RE-ESTABLISHED.

APAR status
Closed as unreproducible in next release.

Error description
Customer received a -900 sql error
com.ibm.ejs.persistence.EJSJDBCPersister after shutting down
the Distributed Data Facility.  The error occured because
the connection was brought down by stopping DDF causing the
-900 sqlcode which says that the application is still in a
connected state to the application server so the statement
cannot be executed.  The EJSJDBCPersister used for CMP beans
is caching the connections, and it will try to reuse the
connection, but the connection is no longer usable by the
application resulting in the -900.
Local fix
1)  Resolve the initial communication error
2)  Stop and start ( recycle ) WebSphere Application Server
    to clear out the cache.
3)  If you want to disable the caching you can add the following
    environment variable to your jvm.properties file:
    .
    com.ibm.websphere.cmp.connection.policy=inTrans
    .
    but this will slow the performance of the application.
    The default when not specified is "acrossTrans".
Problem summary
****************************************************************
* USERS AFFECTED: All users of WebSphere Application Server    *
*                 version 4.0.1 for z/OS and OS/390            *
****************************************************************
* PROBLEM DESCRIPTION: -900 sql exception can be received when *
*                      DDF facility is shutdown or recycled.   *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Connections within the CMP Connection Cache become unusable
when the DB2 Distributed Data Facilty is shutdown or recycled.
Problem conclusion Temporary fix Comments
The APAR is being closed UR1 which the concurrence of the
reporting customer. The problem does not occur in WebSphere
V5.0 for z/OS.
APAR information
APAR number PQ72457
Reported component name WASKBASE
Reported component ID 5655A9801
Reported release 401
Status CLOSED UR1
PE NoPE
HIPER NoHIPER
Submitted date 2003-03-25
Closed date 2003-08-19
Last modified date 2003-08-19

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros

Fix information
Fixed component name WASKBASE
Fixed component ID 5655A9801

Applicable component levels
R401 PSN    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server for z/OS
Operating system(s):
Software version: 401
Software edition:
Reference #: PQ72457
IBM Group: Software Group
Modified date: Aug 19, 2003