A fix is available
APAR status
Closed as new function.
Error description
NEW RELEASE OF THE IBM DATA SERVER DRIVER FOR JDBC AND SQLJ 4.31 PROVIDING VARIOUS ENHANCEMENTS.
Local fix
PTF Required
Problem summary
**************************************************************** * USERS AFFECTED: All Users of the IBM Data * * Server Driver for JDBC and SQLJ * **************************************************************** * PROBLEM DESCRIPTION: SQLJ version 4.31.18 is provided by * * this APAR ( JCCV43118 ) * * * * This APAR is applicable to IBM Data * * Sever Driver for JDBC and SQLJ * * for DB2 z/OS V13, DB2 z/OS V12, * * DB2 and z/OS V11 ( JCCZOSDB2V13, * * JCCZOSDB2V12, JCCZOSDB2V11 ) * * * * This APAR delivers a new release (4.31) * * of the IBM Data Server Driver for JDBC * * and SQLJ providing an accumulation of * * defect fixes and enhancements. * * * * Individual items are documented in the * * APAR summary section that follows. * **************************************************************** JCC sub-category keywords: JCCCOMMON, JCCT2ZOS, JCCT4, JCCT4XA, JCCSQLJ The following changes are delivered in this APAR: _______________________________________________________________ Type4 Connectivity: JCC throws com.ibm.db2.jcc.am.SqlException: "Cannot change current package path when pre-existing package sets are in use on the connection. ERRORCODE=-4474, SQLSTATE=null" in a connection pool environment. If Application executes SET CURRENT PACKAGE PATH For every connection from pool this issue can appear. This issue has been fixed.(DBC-12230, IT41270) _______________________________________________________________ Type4 Connectivity: In a connection pool environment If XAER_RMFAIL returned from server during a ResultSet fetch, The connection needs to be cleaned from connection pool. JCC needs to raises appropriate event to the pool for the connection cleanup. This issue has been fixed.(DBC-11624, IT41578)
Problem conclusion
The items described in the APAR Problem Summary have been resolved as noted in the summary and included in this APAR.
Temporary fix
Comments
APAR Information
APAR number
PH47828
Reported component name
DB2 ODBC/JDBC/S
Reported component ID
5740XYR02
Reported release
B12
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-07-07
Closed date
2022-07-21
Last modified date
2022-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI81605 UI81606 UI81607
Modules/Macros
DSNAJ3C0 DSNAJ3C1 DSNAJ3C2 DSNAJ3C3 DSNAJ3C4 DSNAJ3C5 DSNAJ3C6 DSNAJ3C7 DSNAJ3C9 DSNAJ3CC DSNAJ3CE DSNAJ3CF DSNAJ3CM DSNAJ6C0 DSNAJ6C1 DSNAJ6C2 DSNAJ6C3 DSNAJ6C4 DSNAJ6C5 DSNAJ6C6 DSNAJ6C7 DSNAJ6C9 DSNAJ6CC DSNAJ6CE DSNAJ6CF DSNAJ6CM DSNAJJC1 DSNAJJC2
Fix information
Fixed component name
DB2 ODBC/JDBC/S
Fixed component ID
5740XYR02
Applicable component levels
RB12 PSY UI81605
UP22/07/26 P F207
RC12 PSY UI81606
UP22/07/26 P F207
RD12 PSY UI81607
UP22/07/26 P F207
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B12","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 August 2022