IBM Support

PK49244: CPU IMPACT OF FACTOR 4

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

  • After migration to DB2 V8 program   DB2BP took  4- 5 times
longer to finish

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
*                 users of component:                          *
*                 -   Buffer Pool Analyzer                     *
****************************************************************
* PROBLEM DESCRIPTION: CPU IMPACT OF FACTOR 4                  *
****************************************************************
* RECOMMENDATION: Apply this PTF.                              *
****************************************************************
Old BPOQRIOA IFCID(6 7) processing algorithm suffers performance
degradation with DB2 V8 data. That happens in BPA batch report
and file generation with the bulk amount of input data.

    



Problem conclusion


    

  • Algorithm reworked to eliminate performance degradation with
DB2 V8 data.

KEYWORDS : BPACTIVITY PERFORMANCE V8

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PK49244
    • 

  • 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
    2007-07-19
    • 

  • Closed date
    2007-10-09
    • 

  • Last modified date
    2007-11-02
    • 





    

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

    
PK45068
    

    • 

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

    
UK29956 UK29957
    

    • 



Modules/Macros


    

  •    BPOQACHP BPOQADTL BPOQAEOF BPOQAEXT BPOQALVP
BPOQAPVA BPOQARFL BPOQASCD BPOQCREC BPOQCREP BPOQECHP BPOQEDTL
BPOQELVP BPOQERFL BPOQESCD BPOQFCAT BPOQFCBU BPOQFCCA BPOQFCDT
BPOQFCGB BPOQFCOB BPOQFHOB BPOQFUGB BPOQFWAT BPOQFWBU BPOQFWCA
BPOQFWGB BPOQFWOB BPOQINEX BPOQIREC BPOQRHGT BPOQRHOB BPOQRHST
BPOQRIOA BPOQRPLN BPOQRPOB BPOQRUDT BPOQRUGT BPOQRULN BPOQRUOB
BPOQRUST BPOQSHAT BPOQSHCA BPOQSHGB BPOQSPAT BPOQSPCA BPOQSPGB
BPOQSRGB BPOQSUGB BPOQTPFA BPOQTPFC BPOQTPFG BPOQXDTL BPOQXHGT
BPOQXPFA BPOQXPFG BPOQXSCD BPOQZREC FPEUCXPX

    



Fix information


    

  • Fixed component name
    OM XE DB2PE/PM
    • 

  • Fixed component ID
    5655OPE00
    • 



Applicable component levels


    

  • R310  PSY  UK29956
       UP07/10/11  P  F710
    • 

  • R410  PSY  UK29957
       UP07/10/11  P  F710
    • 



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:
            

            02 November 2007
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback