IBM Support

PK21528: EDMP DISPLAY OF TOTAL PAGES INCLUDES DYNAMIC SQL CACHE WHEN IN DATASPACE

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

  • From Classic Main Menu - ZMENU select
R  RESOURCE MANAGERS .... Resource manager, other DB2 subsystem
information
results screen ZRMMENU - select
C  EDM POOL ............... EDM Pool Information
results ZEDMP

When SQL CACHE is in data space the pages are being accumulated
in the Total Pages. The Dynamic SQL Cache pages should only be
accumulated in Total Pages when the pages are part of the region
and not in a dataspace.

There will be a corresponding APAR and fix for AKD5300

Local fix

  • The page counts are correct, so the totals can be manually
recalculated.

Problem summary

  • ****************************************************************
* USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM V310            *
****************************************************************
* PROBLEM DESCRIPTION: INVALID EDM POOL TOTAL PAGE WHEN SQL    *
*                      CACHE IS IN DATASPACE.                  *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

Problem conclusion

  • SQL CACHE PAGE IS EXCLUDED FROM EDM POOL TOTAL PAGE WHEN CACHE
IS IN DATASPACE.
SYSMOD Title: Various forward fits
Keywords: INCORROUT EDM TOTAL PAGE ZEDMP

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PK21528
    • 

  • Reported component name
    OM XE DB2PE/PM
    • 

  • Reported component ID
    5655OPE00
    • 

  • Reported release
    310
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2006-03-14
    • 

  • Closed date
    2006-03-27
    • 

  • Last modified date
    2006-04-05
    • 





    

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

    
OA15579
    

    • 

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

    
UK13001
    

    • 



Modules/Macros


    

  •    KO2ACAPS KO2ACAP2 KO2ARSBS KO2ARSB2 KO2ASPFB
KO2ASUBS KO2ASUB2 KO2ATRCB KO2ATRPB KO2ATRTB KO2CLOGB KO2CNSRB
KO2CNTPS KO2CNTP2 KO2CSTSB KO2DAUDS KO2DAUD2 KO2DBCIB KO2DCS2B
KO2DDSBS KO2DDSB2 KO2DMSCS KO2DMSC2 KO2DTHDS KO2DTHD2 KO2DXSTB
KO2DXS1S KO2DXS12 KO2DXS2S KO2DXS22 KO2DXS3S KO2DXS32 KO2HARCB
KO2HDTIB KO2HDTPB KO2HPRCB KO2HPR2B KO2HSQIB KO2HVINB KO2ICOLS
KO2ICOL2 KO2MI00B KO2MSBDB KO2MSB1B KO2MSB2B KO2MSB3B KO2MSB4B
KO2MSUMB KO2ODCNB KO2OEDSB KO2OINTB KO2OLOGB KO2OSTDB KO2OSUBB
KO2OTHDB KO2OZM2B KO2TSB1B KO2TSB2B KO2TSB3B KO2TSB4B KO2VDINB
KO2XLKDS KO2XLKD2 KO2XSYSS KO2XSYS2 KO2XSY2S KO2XSY22

    



Fix information


    

  • Fixed component name
    OM XE DB2PE/PM
    • 

  • Fixed component ID
    5655OPE00
    • 



Applicable component levels


    

  • R310  PSY  UK13001
       UP06/03/29  P  F603
    • 



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":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"310","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"310","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            05 April 2006
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback