PQ48194: CONNECTION MGR IS NON-PARITY FOR SQLSTATE 58004 DBERROR.

A fix is available
3.5.4-3.5.7, 4.0.2-4.0.7: Component cumulative Connection Manager fix

APAR

APAR status
Closed as program error.

Error description
The situation using SQLJ and application DB
UDB6.1/OS390 through DB2connect.
If connection pooling are time out , the next
new DB connection spawn SQL58004. The result is
the DB connection is not available with following
error till WAS restart.
.
  01.03.29 10:56:22:277 JST  9a68ce43 ServletInsta
n X Uncaught service() exception thrown by servlet
 {0}: {1}
              "honda.jp.hm.obt.servlets.OBLILI00Se
rvlet"
             javax.servlet.ServletException: OBT20
02E unexpected error occuered on DB. Keep a copy o
f exhibited error   message and contact HelpDesk.
SQLSTATE=58004,SQLCODE=-99999, IBM  CLIDriver  CLI
0119E  An unexpected system error occurred. SQLSTA
TE=58004  at honda.jp.hm.obt.servlets.OBLILI00Serv
let.performTask(OBLILI00Servlet.java:179)
   at honda.jp.hm.obt.servlets.OBLILI00Servlet.doG
et(OBLILI00Servlet.java:42)

   at javax.servlet.http.HttpServlet.service(HttpS
ervlet.java:740)
   at javax.servlet.http.HttpServlet.service(HttpS
ervlet.java:853)
.
.
.
.
So the SQLSTATE=58004 is out of handling.
Local fix
 add the following code to
      com.ibm.ejs.cm.portability.DB2PortabilityLayer
  // Fix for ErrorCode:CLI0119E SQLstate:58004 (SQLJ,DB2/390)
  errorMap.put("58004", StaleConnectionException.class);
Problem summary
CLI0119E An unexpected system error occurred SQLSTATE 58004
when the connection pool has timed out.
Problem conclusion
com/ibm/ejs/cm/portability/DB2PortabilityLayer.java
was changed to add StaleConnectionException mapping for DB2
layer: SQLState 58004
Temporary fix
Comments
APAR information
APAR numberPQ48194
Reported component nameWAS STANDARD AI
Reported component ID5648C8300
Reported release350
StatusCLOSED PER
PENoPE
HIPERNoHIPER
Submitted date2001-04-27
Closed date2001-05-08
Last modified date2001-05-08

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:APAR is sysrouted FROM one or more of the following:


Modules/Macros
JDBC
APAR is sysrouted TO one or more of the following:Modules/Macros

Fix information
Fixed component nameWAS STANDARD AI
Fixed component ID5648C8300

Applicable component levels
R350 PSYUP











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, General
Software version: 350
Reference #: PQ48194
IBM Group: Software Group
Modified date: 2001-05-08