IBM Support

IC80623: IF THE CONNECTION IS DROPPED DUE TO INTERRUPT, IF ACR IS ENABL ED CLI SHOULD NOT TRY SEAMLESS AFTER FAIL-OVER TO NEW MEMBER

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • If the user sets the interrupt=2 in the CLI configuration file.
    On a given statement timeout occurs and the connection is
    dropped due to interrupt on disconnect processing and ACR is
    enabled ACR should be triggered.  The connection does not know
    its socket was closed due to interrupt handling.  In this case
    CLI should not drive a seamless retry if the statement was
    interrupted after re-route.
    
    If seamalessACR is enabled, CLI should not try seamlessACR
    instead throw SQL30108N error.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * CLI users with interrupt is set to 2                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * If the user sets the interrupt=2 in the CLI configuration    *
    * file.                                                        *
    * On a given statement timeout occurs, connection is           *
    * re-routing to another member seamlessly.                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.07.6                                *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC80623

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-01-02

  • Closed date

    2012-10-24

  • Last modified date

    2012-10-24

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

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

Fix information

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC80623

Modified date: 24 October 2012