IBM Support

JR45562: DB2 MAY TRAP AT THE DESTRUCTOR OF SQLQG_REMOTE_STMTS.

Fixes are available

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 might trap in the destructor of sqlqg_remote_stmts. The
stack trace is like as below:

sqlqg_remote_stmts::~sqlqg_remote_stmts
sqlqg_remote_stmts
sqm_rollup_djagent
sqlmon_agent_cleanup
sqeAgent::AppDisassoc
sqeApplication::AppStopUsing
sqlesrspWrp
sqleUCagentConnectReset
sqljsCleanup
sqljsDrdaAsInnerDriver
sqljsDrdaAsDriver
sqeAgent::RunEDU
sqlzRunEDU
sqloEDUEntry

This problem can happen when one agent is deleting all remote
statement information, and another agent also deletes one of the
remote statement at the same time.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* Users who use federation functionality.                      *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Please upgrade to V9.7 FixPack 9.                            *
****************************************************************

    



Problem conclusion


    

  • This problem was first fixed in DB2 V9.7 FixPack 9.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR45562
    • 

  • Reported component name
    FEDERATION SERV
    • 

  • Reported component ID
    5724N9700
    • 

  • Reported release
    970
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2013-01-29
    • 

  • Closed date
    2014-03-24
    • 

  • Last modified date
    2014-03-24
    • 





    

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

    • 

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

    
IC95435 IC96256
    

    • 



Fix information


    

  • Fixed component name
    FEDERATION SERV
    • 

  • Fixed component ID
    5724N9700
    • 



Applicable component levels


    

  • R970  PSN
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPY","label":"General Issues"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"","label":""}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            24 March 2014
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback