APAR status
Closed as program error.
Error description
When using session persistence to a DB2 database, you may see an
arithmetic exception in the logs similar to the below:
[11/29/04 15:39:41:469 EST] 2d05c555 WebGroup I SRVE0180I:
[PMR29341Web] [/PMR29341Web] [Servlet.LOG]: Test: init
[11/29/04 15:44:46:953 EST] 7cc0c555 SessionContex E SESN0036E:
BackedHashtable:doInvalidations - database error. If a
SQLException has
occurred then refer to the appropriate database documentation
for your
environment. Also, ensure that you have properly configured a
datasource
for Session Manager.
[11/29/04 15:44:46:969 EST] 7cc0c555 SessionContex E Sessionid
is:
[11/29/04 15:44:46:969 EST] 7cc0c555 SessionContex E Exception
is:
com.ibm.db2.jcc.a.SqlException: Arithmetic overflow or other
arithmetic
exception occurred.
at com.ibm.db2.jcc.a.cc.c(cc.java:330)
at com.ibm.db2.jcc.a.cc.next(cc.java:259)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.j
ava:2408
)
at
com.ibm.ws.webcontainer.httpsession.BackedHashtable.doInvalidati
ons(Back
edHashtable.java:636)
at
Local fix
N/A
Problem summary
****************************************************************
* USERS AFFECTED: Any WebSphere Application Server customers *
* using DB2 as the repository *
****************************************************************
* PROBLEM DESCRIPTION: com.ibm.db2.jcc.a.SqlException: *
* Arithmetic overflow or other *
* arithmetic exception occurred. *
****************************************************************
* RECOMMENDATION: *
****************************************************************
During the calculation within a SQL statement, the temp value
gets too large to a point that DB2 cannot handle.
Problem conclusion
The DB2 statement is rewritten so that the temp value is
always a value that DB2 can handle.
The fix for this APAR is currently targeted for inclusion
in 5.02.11 and 5.1.1.4.
Please refer to the recommended updates page for delivery
information:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
Temporary fix Comments
APAR information |
APAR number |
PQ98662 |
Reported component name |
WAS BASE 5.0 |
Reported component ID |
5630A3600 |
Reported release |
10A |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2004-12-17 |
Closed date |
2005-04-05 |
Last modified date |
2005-04-05 |
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
Publications Referenced
|
Fix information |
Fixed component name |
WAS BASE 5.0 |
Fixed component ID |
5630A3600 |
Applicable component levels |
R003 PSY |
UP |
R00A PSY |
UP |
R00H PSY |
UP |
R00I PSY |
UP |
R00P PSY |
UP |
R00S PSY |
UP |
R00W PSY |
UP |
R103 PSY |
UP |
R10A PSY |
UP |
R10H PSY |
UP |
R10I PSY |
UP |
R10P PSY |
UP |
R10S PSY |
UP |
R10W PSY |
UP |
|