PM77184: JCC3.64: IBM DATA SERVER DRIVER FOR JDBC AND SQLJ RELEASE 3.64 GENERAL SERVICE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• JCC3.64: IBM DATA SERVER DRIVER FOR JDBC AND SQLJ RELEASE 3.64
  GENERAL SERVICE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users of the IBM Data                    *
  *                 Server Driver for JDBC and SQLJ              *
  ****************************************************************
  * PROBLEM DESCRIPTION: IBM Data Sever Driver for JDBC and      *
  *                      SQLJ version 3.64.119 is provided by    *
  *                      this APAR ( JCCV364119 )                *
  *                                                              *
  *                      This APAR is applicable to IBM Data     *
  *                      Sever Driver for JDBC and SQLJ          *
  *                      for DB2 z/OS V10 and DB2 z/OS V9 and    *
  *                      the alternate supplemental driver       *
  *                      for DB2 z/OS V8. ( JCCZOSDB2V10,        *
  *                      JCCZOSDB2V9, JCCZOSDB2V8 )              *
  *                                                              *
  *                      This APAR delivers a new release (3.64) *
  *                      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.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  JCC sub-category keywords:
      JCCCOMMON, JCCT2ZOS, JCCT4, JCCT4XA, JCCSQLJ
  
  The following changes are delivered in this APAR:
  _______________________________________________________________
  All Connectivities: Driver returns an SQLCODE401 (-401) While
  updating a column defined in DB2 as SMALLINT using the
  setBoolean() API of the java.sql.PreparedStatement interface.
  This issue is fixed.(wsdbu01060873)
  _______________________________________________________________
  Type-4 XA Connectivity: In a workload balancing and XA
  transaction environment, an SQLCODE4228 (-4228) error might
  return to the application if auto failover has occurred during
  a local transaction. (wsdbu01060779)
  _______________________________________________________________
  Type-4 connectivity:A java.lang.ArrayIndexOutOfBoundsException:
  Array index out of range: 255, may be thrown by the driver
  when invoking a stored procedure that has array types as
  parameters and number of parameters are more than 83.
  The problem has been fixed. (wsdbu01061046)
  _______________________________________________________________
  Type-2 z/OS Connectivity: For an IMS MPP/BMP/IFP application
  executing in a Persistent JVM environment and calling a Java
  application which makes DB2 calls through the driver, this
  driver provides a new partial Reset interface to allow reuse of
  the JDBC Connection object which can boost performance. For
  more detailed information, please refer to IMS APAR PM80880.
  (wsdbu01061827)
  

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 is sysrouted FROM one or more of the following:

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

  PM84340 UK92320 UK92321 UK92322

Modules/Macros

•    DSNAQJBA DSNAQJBB DSNAQJB1 DSNAQJB2 DSNAQJB3
  DSNAQJB4 DSNAQJB5 DSNAQJB6 DSNAQJB7 DSNAQJB8 DSNAQJC1 DSNAQJC2
  DSNAQJC3 DSNAQJC4 DSNAQJRM DSNAQJS1 DSNAQJS2 DSNAQ3BA DSNAQ3BB
  DSNAQ3B1 DSNAQ3B2 DSNAQ3B3 DSNAQ3B4 DSNAQ3B5 DSNAQ3B6 DSNAQ3B7
  DSNAQ3B8 DSNAQ3B9 DSNAQ3CA DSNAQ3CC DSNAQ3CE DSNAQ3CF DSNAQ3CM
  DSNAQ3C0 DSNAQ3C1 DSNAQ3C2 DSNAQ3C3 DSNAQ3C4 DSNAQ3C5 DSNAQ3C6
  DSNAQ3C7 DSNAQ3C8 DSNAQ3C9 DSNAQ3E1 DSNAQ3F1 DSNAQ3F2 DSNAQ3F3
  DSNAQ3F4 DSNAQ3L2 DSNAQ3L9 DSNAQ3RM DSNAQ3S1 DSNAQ3S2 DSNAQ6CC
  DSNAQ6CE DSNAQ6CF DSNAQ6CM DSNAQ6C0 DSNAQ6C1 DSNAQ6C2 DSNAQ6C3
  DSNAQ6C4 DSNAQ6C5 DSNAQ6C6 DSNAQ6C7 DSNAQ6C9
  

Fix information

• Fixed component name

  DB2 ODBC/JDBC/S

• Fixed component ID

  5740XYR02

Applicable component levels

• RA12 PSY UK92320

     UP13/03/09 P F303

• R812 PSY UK92321

     UP13/03/09 P F303

• R912 PSY UK92322

     UP13/03/09 P F303

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.