IBM Support

LI75820: IN DPF, LOAD-RESTART FROM CURSOR WITH DATABASE CLAUSE INTO TABLE DEFINED IN SNNG MAY TRAP

Fixes are available

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 fixed if next.

Error description

  • In a DPF environment, if a table resides in a tablespace that
belongs to a single-dbpartition-dbpartitiongroup, and the table
contains a Unique Index, and Load is invoked into this table and
fails in the DELETE phase (ie. this might happen if log space is
exhausted while the DELETE phase is removing duplicate records),
and a Load-RESTART is invoked, then a seg-fault could occur and
bring the instance down.

Stack trace would contain sqlusCUserExitSubAgent::iRun() module
at top
<StackTrace>
-------Frame------ ------Function + Offset------
0x0900000005C88ED8 iRun__22sqlusCUserExitSubAgentFv + 0x570
0x090000000560E478
sqlusSubAgentRouter__FP20sqle_agent_privatecbi + 0x630
0x09000000056090B0 sqleSubRequestRouter__FP13sqle_agent_cbPUiT2
+ 0x7E4
0x090000000569FBC4 sqleProcessSubRequest__FP13sqle_agent_cb +
0x22C
0x0900000004E9FBC0 sqleRunAgent__FPcUi + 0x920
0x09000000047B3E8C
sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x25C
0x09000000047B0364 sqloSpawnEDU + 0x230

Local fix

  • Instead of using Load-RESTART, use Load-TERMINATE instead and
then re-execute the original Load-INSERT/REPLACE

Problem summary

  • ****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* IN DPF, LOAD-RESTART FROM CURSOR WITH DATABASE CLAUSE INTO   *
* TABLE                                                        *
* DEFINED IN SNNG MAY TRAP                                     *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to fixpak that includes this APAR fix.               *
****************************************************************

Problem conclusion

  • 



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    LI75820
    • 

  • Reported component name
    DB2 UDB ESE LIN
    • 

  • Reported component ID
    5765F4106
    • 

  • Reported release
    910
    • 

  • Status
    CLOSED  FIN
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2011-01-21
    • 

  • Closed date
    2012-02-13
    • 

  • Last modified date
    2012-02-13
    • 





    

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

    • 

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

    
IC73962 IC73966
    

    • 



Fix information


    



Applicable component levels


    

  • R910  PSY
       UP
    • 








      
              
                            

              

              [{"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":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            15 October 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback