IBM Support

PM96293: JCC 3.65: IBM DATA SERVER DRIVER FOR JDBC AND SQLJ RELEASE 3.65 GENERAL SERVICE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • JCC 3.65: IBM DATA SERVER DRIVER FOR JDBC AND SQLJ RELEASE
    3.65 GENERAL SERVICE
    
    Additional symptoms/KEYWORDS:
    =============================
    SQLCODE812 (RTC36321)
    CurrentSchema, CurrentFunctionPath,
    CurrentSQLID, CurrentPackageSet,
    

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.65.102 is provided by    *
    *                      this APAR ( JCCV365102 )                *
    *                                                              *
    *                      This APAR is applicable to IBM Data     *
    *                      Sever Driver for JDBC and SQLJ          *
    *                      for DB2 z/OS V11, DB2 z/OS V10,         *
    *                      DB2 z/OS V9 and alternate supplemental  *
    *                      driver for DB2 z/OS V8 ( JCCZOSDB2V11,  *
    *                      JCCZOSDB2V10, JCCZOSDB2V9, JCCZOSDB2V8) *
    *                                                              *
    *                      This APAR delivers a new release (3.65) *
    *                      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 number

    PM96293

  • Reported component name

    DB2 ODBC/JDBC/S

  • Reported component ID

    5740XYR02

  • Reported release

    A12

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2013-09-03

  • Closed date

    2013-11-12

  • Last modified date

    2014-05-02

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

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

    UI12400 UI12401 UI12402 UI12403

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 UI12400

       UP13/11/14 P F311

  • RB12 PSY UI12401

       UP13/11/14 P F311

  • R812 PSY UI12402

       UP13/11/14 P F311

  • R912 PSY UI12403

       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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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":"A12"}]

Document Information

Modified date:
03 March 2021