IBM Support

PH47913: CONNECTING FAILURE IS OBSERVED VIA JDBC TO DB2 V12R1M504 IN RBD V9.6.0.1 WITH EXISTING DRIVERS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • The exception thrown is : com.ibm.db2.jcc.am.SqlException: DB2
    SQL Error: SQLCODE=-30025, SQLSTATE=56073,
    SQLERRMC=DB2S;DSN12015:*:V12R1M504;0600;0002, DRIVER=4.19.56
    This failure occurs where Db2 12 is applied with DSNHDECP parm
    APPLCOMPAT and is resolved by connecting with a driver higher
    than 4.22.0.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users connecting to DB2 datasources via EGL connection       *
    * preferences                                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Connection exception thrown is :                             *
    * com.ibm.db2.jcc.am.SqlException: DB2 SQL Error:              *
    * SQLCODE=-30025, SQLSTATE=56073                               *
    * via EGL connection wizard                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • Fixed in RBD 9.7.0.1 and 9.6.1
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH47913

  • Reported component name

    RATL BUS DEV

  • Reported component ID

    5724S5000

  • Reported release

    960

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-07-12

  • Closed date

    2023-11-14

  • Last modified date

    2023-11-14

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

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

Fix information

  • Fixed component name

    RATL BUS DEV

  • Fixed component ID

    5724S5000

Applicable component levels

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"960","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
14 November 2023