IBM Support

IC68643: A LOAD WITH CLIENT KEYWORD THAT IS INTERRUPTED MAY TRAP IF CONNECT-RESET IS INVOKED AFTERWARD.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This problem affects V9.1fixpak8, V9.1fixpak9.
    When a Load is invoked from a remotely connected client using
    the CLIENT option (also know as a 'remote client Load' or
    'remote Load'), if the Load is interrupted it will rollback and
    complete as expected.  However a subsequent connect-reset may
    cause a trap.
    
    The trap file will contain a signal #11 and a stack like this:
    <StackTrace>
    -------Frame------
    sqluRemapReturnCode
    sqluvload
    call_sqluvload
    sqluLoadPartition
    sqlu_register_table_load
    sqluvtld_route_in
    sqluTermConnect
    sqleUCagentConnectReset
    
    In this case the connect-reset 'sqleUCagentConnectReset' is
    incorrectly invoking a Load-specific connect-reset callback
    function 'sqluTermConnect'.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users using client load.                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error description field for more information.            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Version 9.1 FixPack 10.                           *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.1 FixPack 10.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC68643

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-05-13

  • Closed date

    2011-06-16

  • Last modified date

    2011-06-16

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

    IC68626

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R910 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1"}]

Document Information

Modified date:
16 September 2021