PQ53331: STATEMENT CACHE HANGS ON RELEASESTATEMENT CALL

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
Application server is hanging in connection manager, and in the
cm trace we can see that the time is lost in the statement cache
 releaseStatement:
.
04:36:40:062    StatementCach > releaseStatement
04:37:18:760    CacheManager > addStatement
.
The system is hanging in this code
releaseStatement:., 04:36:40:062 StatementCach>, releaseStatement, 04:37:18:760 CacheManager>, addStatement.The system is hanging in this code
Local fix
Problem summary
****************************************************************
* USERS AFFECTED: All WebSphere Application Server users of    *
*                 cache prepared statements.                   *
****************************************************************
* PROBLEM DESCRIPTION: Performance problem in                  *
*                      PreparedStatementCache                  *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Cacheing prepared Statements took too long
Problem conclusion
Code was changed to improve performance with in cache
prepared statements.
Temporary fix
Comments
APAR information
APAR numberPQ53331
Reported component nameWAS ADVANCED SU
Reported component ID5648C8402
Reported release350
StatusCLOSED PER
PENoPE
HIPERNoHIPER
Submitted date2001-10-11
Closed date2001-10-30
Last modified date2001-12-17

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 ADVANCED SU
Fixed component ID5648C8402

Applicable component levels
R350 PSYUP
R300 PSNUP











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, General
Software version: 350
Reference #: PQ53331
IBM Group: Software Group
Modified date: 2001-12-17