IC75549: JDBC DRIVER STUCK IN CLIENT REROUTE
Fixes are available
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
-
When the JDBC/JCC driver receives an invalid packet from the server it may become stuck in an infinite client re-route loop. This fix will limit the number of retries to 10 retries and then throw the -4228 error.
Local fix
-
In SYSPLEX environments set the JDBC driver parameter enableSysplexWLB=false
Problem summary
-
See ERROR DESCRIPTION.
Problem conclusion
-
First fixed in the JDBC driver (db2jcc.jar) included with v9.7 Fixpack 4. Download the IBM Data Server Driver for JDBC and SQLJ for v9.7 Fixpack 4.
Temporary fix
-
See LOCAL FIX.
Comments
APAR Information
APAR number
IC75549
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
970
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-04-04
Closed date
2011-05-13
Last modified date
2011-05-13
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
R910 PSN
UP
R950 PSN
UP
R970 PSN
UP
R980 PSN
UP
Document information
More support for:
DB2 for Linux, UNIX and Windows
Software version: 9.7
Reference #: IC75549
Modified date: 13 May 2011