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 is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Modules/Macros
|
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
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.