IBM Support

IC72950: JCC DRIVER MIGHT MAKE TWICE AS MANY CLIENT REROUTE CONNECTION ATTEMPTS AS ARE CONFIGURED BY MAXRETRIESFORCLIENTREROUTE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When the IBM Data Server Driver for JDBC and SQLJ
    (also called the JCC driver) tries to connect to a port on
    which there is no DB2 database server listening
    then if either or both of the properties enableSysplexWLB and
    enableConnectionConcentrator are "true"
    it makes twice as many client reroute connection attempts
    as are configured by the property maxRetriesForClientReroute.
    

Local fix

  • As a workaround you can set the IBM Data Server Driver for JDBC
    and SQLJ property maxRetriesForClientReroute to half the number
    of client reroute connection attempts you really want.
    

Problem summary

  • When the IBM Data Server Driver for JDBC and SQLJ
    (also called the JCC driver) tries to connect to a port on
    which there is no DB2 database server listening
    then if either or both of the properties enableSysplexWLB and
    enableConnectionConcentrator are "true"
    it makes twice as many client reroute connection attempts
    as are configured by the property maxRetriesForClientReroute.
    

Problem conclusion

  • Problem was fixed in DB2 9.5 Fix Pack 8
    

Temporary fix

  • As a workaround you can set the IBM Data Server Driver for JDBC
    and SQLJ property maxRetriesForClientReroute to half the number
    of client reroute connection attempts you really want.
    

Comments

APAR Information

  • APAR number

    IC72950

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-12-02

  • Closed date

    2011-09-02

  • Last modified date

    2011-09-02

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

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

    IC72962

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 September 2011