PM96295: JCC 4.15: IBM DATA SERVER DRIVER FOR JDBC AND SQLJ NEW RELEASE 4.15 GENERAL SERVICE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• JCC 4.15: IBM DATA SERVER DRIVER FOR JDBC AND SQLJ NEW RELEASE
  4.15 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 4.15.105 is provided by    *
  *                      this APAR ( JCCV415105 )                *
  *                                                              *
  *                      This APAR is applicable to IBM Data     *
  *                      Sever Driver for JDBC and SQLJ          *
  *                      for DB2 z/OS V11, DB2 z/OS V10 and      *
  *                      DB2 z/OS V9( JCCZOSDB2V11,              *
  *                      JCCZOSDB2V10, JCCZOSDB2V9 )             *
  *                                                              *
  *                      This APAR delivers a new release (4.15) *
  *                      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 zos Connectivity: DB2 V10 NFM or higher server supports
  TIMESTAMP with TIME ZONE type. When application sends data like
  9999-12-31 23:59:59.0 to a timestamp column into these DB2
  servers results SQLCODE181(-181). This is because by default
  the driver was sending TIME ZONE information to the server.
  In the boundary values case, the server is not able to process
  it. With the current fix, the driver is NOT sending TIME ZONE
  information to theserver if the date part is 9999-12-31 or
  0001-01-01.(RTC 37158)
  _______________________________________________________________
  All zos Connectivity: When application calls setBytes() method,
  this may fail with SQLCODE4474(-4474) if the target column type
  is VARCHAR on ZOS Databases. This issue is fixed.(RTC 36106)
  _______________________________________________________________
  Type-2 zos Connectivity: JCC driver not able to send the jcc
  property currentSchema to the DB2 server. This results
  SQLCODE204(-204) while executing statements. This issue is
  fixed.(RTC 36321)
  _______________________________________________________________
  Type-4 Connectivity: A batch update may fail if its using
  setDBStringAsByte to set Unicode text and the first
  row of the same batch had null for the same column.(RTC 31674)
  _______________________________________________________________
  Type-4 Connectivity: When using XADatasource with
  enableSysplexWLB=true, a gradual and permanent growth in
  transport objects occur which results SQLCODE4210(-4210).
  This issue is fixed.(RTC 35561)
  

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:

  UI12415 UI12420 UI12421

Modules/Macros

•    DSNAJJC1 DSNAJJC2 DSNAJ3CC DSNAJ3CE DSNAJ3CF
  DSNAJ3CM DSNAJ3C0 DSNAJ3C1 DSNAJ3C2 DSNAJ3C3 DSNAJ3C4 DSNAJ3C5
  DSNAJ3C6 DSNAJ3C7 DSNAJ3C9 DSNAJ6CC DSNAJ6CE DSNAJ6CF DSNAJ6CM
  DSNAJ6C0 DSNAJ6C1 DSNAJ6C2 DSNAJ6C3 DSNAJ6C4 DSNAJ6C5 DSNAJ6C6
  DSNAJ6C7 DSNAJ6C9
  

Fix information

• Fixed component name

  DB2 ODBC/JDBC/S

• Fixed component ID

  5740XYR02

Applicable component levels

• RA12 PSY UI12415

     UP13/11/14 P F311

• RB12 PSY UI12420

     UP13/11/14 P F311

• R912 PSY UI12421

     UP13/11/14 P F311

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.