IBM Support

PM89459: ABEND04E RC00E2000C LOC=DSNXPCRT.DSNSVSVB+0B10 CAN OCCUR WHEN USING PARALLELISM

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

  • ABEND04E RC00E2000C LOC=DSNXPCRT.DSNSVSVB+0B10 can occur when
using parallelism.  Some storage could remain unfreed, leading
to a storage shortage.                               (d166945)

Local fix

  • n/a

Problem summary

  • ****************************************************************
* USERS AFFECTED: All DB2 10 and 11 for z/OS users             *
*                 of parallelism.                              *
****************************************************************
* PROBLEM DESCRIPTION: ABEND04E RC00E2000C at location         *
*                      DSNXPCRT DSNSVSVB +0B10 can occur when  *
*                      using parallelism.                      *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
ABEND04E RC00E2000C at location DSNXPCRT.DSNSVSVB+0B10
can occur when using parallelism.

Storage allocated for parallelism internal structures are
not completely freed under certain circumstances, when DB2
goes through an error path. Accumulated storage leaked will
cause storage abend observed in this problem.

The problem is not query specific, and it could happen when
a query is running in parallel. The query abend could be a
victim of storage leak by previous queries.

Problem conclusion

  • DB2 has been fixed to free parallel storage completely
for a query running under parallel plan. The storage
leak no longer occurs for this circumstance.

Additional keywords: DB2PARALL/K  PARALLELISM SQLPARALLELISM
                     DB2STGLK/K    SQLSTORAGE

Temporary fix

  • *********
* HIPER *
*********

Comments

  • 



APAR Information




    

  • APAR number
    PM89459
    • 

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

  • Reported component ID
    5740XYR00
    • 

  • Reported release
    A10
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    YesHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2013-05-21
    • 

  • Closed date
    2013-09-06
    • 

  • Last modified date
    2013-10-03
    • 





    

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

    • 

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

    
UK97369 UK97370
    

    • 



Modules/Macros


    

  • DSNXPDAL DSNXPDST DSNXRTSS

    



Fix information


    

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

  • Fixed component ID
    5740XYR00
    • 



Applicable component levels


    

  • RA10  PSY  UK97369
       UP13/09/27  P  F309
    • 

  • RB10  PSY  UK97370
       UP13/09/27  P  F309
    • 



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:
            

            03 October 2013
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback