IBM Support

PM65004: JCC4.13: IBM DATA SERVER DRIVER FOR JDBC AND SQLJ RELEASE 4.13 GENERAL SERVICE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • JCC4.13: IBM DATA SERVER DRIVER FOR JDBC AND SQLJ RELEASE 4.13
    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.13.145 is provided by    *
    *                      this APAR ( JCCV413145 )                *
    *                                                              *
    *                      This APAR is applicable to IBM Data     *
    *                      Sever Driver for JDBC and SQLJ          *
    *                      for both DB2 z/OS V10 and DB2 z/OS V9   *
    *                      ( JCCZOSDB2V10, JCCZOSDB2V9 )           *
    *                                                              *
    *                      This APAR delivers a service bundling   *
    *                      to release 4.13 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: An extra line of text
    "com.ibm.net.SocketKeepAliveParameters" shows in the
    "standard" output stream when running with new version of IBM
    JDK6 and above versions. This has been fixed. (wsdbu01049426)
    ____________________________________________________________
    All Connectivities: When driver connects to DB2 z/OS V10 NFM
    or LUW DB2 V10 that supports Timestamp with Timezone or
    Variable Length Timestamp, driver may issue SQLCODE352 (-352)
    when hopping to or implicit connect to a down level server via
    three part name and that down level server do not support
    Timestamp with Timezone or Variable Length Timestamp. This has
    been fixed. (wsdbu01055039, wsdbu00940161, wsdbu01057936)
    ____________________________________________________________
    Type-2 z/OS Connectivity: Under z/OS Java Stored Procedure
    environment, if the JSP calls another Stored Procedure with an
    Output parameter and the registered type for the Output
    parameter is java.sql.Types.Char, the output length can be
    overridden and cause DB2 to issue a data truncation warning
    and the output data can be truncated. This has been fixed.
    (wsdbu01049375)
    ____________________________________________________________
    Type-2 z/OS Connectivity: Calling a Stored Procedure with an
    INOUT timestamp parameter, the input timestamp data was
    replaced by a null value. This has been fixed. (wsdbu01048541)
    ____________________________________________________________
    Type-2 z/OS Connectivity: JVM abends 0C4 when doing a
    nativeOpen call while running with the new version of IBM JDK6
    and above versions. This has been fixed. (wsdbu01052620)
    ____________________________________________________________
    Type-4 XA Connectivity: During auto failover scenario in a
    workload balancing environment against DB2 zOS server, an
    XAException with XAER_NOTA error may be thrown on an XA Commit
    call even if the driver has successfully failover to a member
    after starting of an XA transaction. The problem has been
    fixed. (wsdbu01058658)
    ____________________________________________________________
    Type-4 XA Connectivity: SQLException with the message
    "Connection to the data server failed. The IBM Data Server for
    JDBC and SQLJ license was invalid or was not activated for the
    DB2 for z/OS subsystem. If you are connecting directly to the
    data server and using DB2 Connect Unlimited Edition for System
    z, perform the activation step by running the activation
    program in the license activation kit. If you are using any
    other edition of DB2 Connect, obtain the license file,
    db2jcc_license_cisuz.jar, from the license activation kit, and
    follow the installation directions to include the license file
    in the class path. ERRORCODE=-4230, SQLSTATE=42968" is thrown
    while attempting to get DB2 XA Connection. This problem has
    been fixed. (wsdbu01046755)
    

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

    PM65004

  • Reported component name

    DB2 ODBC/JDBC/S

  • Reported component ID

    5740XYR02

  • Reported release

    912

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-05-18

  • Closed date

    2012-10-09

  • Last modified date

    2012-11-01

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

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

    UK82475 UK82476

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 UK82475

       UP12/10/15 P F210

  • R912 PSY UK82476

       UP12/10/15 P F210

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.



Document information

More support for: DB2 for z/OS
SQLJ/JDBC

Software version: 912

Reference #: PM65004

Modified date: 01 November 2012


Translate this page: