IBM Support

PM72035: STORAGE LEAK ON CREATE VIEW CAUSING ABEND04E 00E20003 IN DSNSVBK OFFSET05D2 AND/OR 00E20016 IN DSNSVSTK OFFSET0634

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

  • STORAGE LEAK on CREATE VIEW resulted in an ABEND 04E in DSNSVBK
with RC00E20003 at OFFSET 05D2 and/or an ABEND04E in DSNSVSTK
was seen at OFFSET 0634

DB2STGLK/K

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: DB2 9 for z/OS users of CREATE VIEW          *
****************************************************************
* PROBLEM DESCRIPTION: ABEND04E occurs at locations            *
*                      DSNSVBK+05D2 and DSNSVSTK+0634 on       *
*                      application running thousands of CREATE *
*                      VIEWs                                   *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Users may experience storage problems in DBM1 due to storage
not being properly cleaned up from long running threads creating
thousands of views. Some symptoms may include ABEND04E
RC00E20003 at DSNSVBK OFFSET05D2 and ABEND04E RC00E20016 at
DSNSVSTK OFFSET0634. Other unexpected results may occur.

    



Problem conclusion


    

  • DB2 has been fixed to properly clean up storage on CREATE VIEW.

Additional Keywords:
SQLCREATE
SQLVIEW
DB2STGLK/K

    



Temporary fix


    

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

    



Comments


    

  • 



APAR Information




    

  • APAR number
    PM72035
    • 

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

  • Reported component ID
    5740XYR00
    • 

  • Reported release
    910
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    YesHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2012-08-31
    • 

  • Closed date
    2012-11-07
    • 

  • Last modified date
    2012-12-04
    • 





    

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

    • 

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

    
UK83346
    

    • 



Modules/Macros


    

  • DSNXICVW

    



Fix information


    

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

  • Fixed component ID
    5740XYR00
    • 



Applicable component levels


    

  • R910  PSY  UK83346
       UP12/11/27  P  F211
    • 



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":"9.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":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            04 December 2012
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback