IBM Support

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

Fixes are available

DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

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
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback