IBM Support

PM98530: HIGH ECSA USAGE

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Unreleased ECSA storage requested by DSNXRTSC

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: All DB2 10 for z/OS users of SYSPLEX         *
*                 PARALLELISM.                                 *
****************************************************************
* PROBLEM DESCRIPTION: High ECSA storage usage in SYSPLEX      *
*                      PARALLELISM case due to storage leak    *
*                      when parallel threads are cancelled.    *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
High ECSA storage usage in case where parallel threads are
cancelled. The problem is when the parallel threads are
cancelled, in certain cases ECSA storage is not freed during
cancelling process. So ECSA storage will be accumulated without
being freed after a long duration of time.
The problem is not query specific, so we will not have a
sample query here. Any query running in SYSPLEX parallelism
could potentially hit this problem.

    



Problem conclusion


    

  • DB2 has been fixed to free the ECSA storage during
CANCEL process for SYSPLEX parallelism query. The
problem no longer occurs after the fix.

Additional keywords: PARALLELISM SYSPLEX
                     DB2PARALL/K  SQLSYSPLEXP

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PM98530
    • 

  • Reported component name
    DB2 OS/390 & Z/
    • 

  • Reported component ID
    5740XYR00
    • 

  • Reported release
    A10
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2013-10-04
    • 

  • Closed date
    2014-03-31
    • 

  • Last modified date
    2014-05-02
    • 





    

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

    • 

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

    
UI16606
    

    • 



Modules/Macros


    

  • DSNTTRUN DSNXPSEN DSNXRTSC

    



Fix information


    

  • Fixed component name
    DB2 OS/390 & Z/
    • 

  • Fixed component ID
    5740XYR00
    • 



Applicable component levels


    

  • RA10  PSY  UI16606
       UP14/04/30  P  F404
    • 



Fix is available


    

  • Select the PTF appropriate for your component level.
You will be required to sign in. Distribution on physical
media is not available in all countries.
    








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 May 2014
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback