IBM Support

JR44506: QUERY FOR INBOX REFRESH NOT OPTIMIZED RESULTING IN PERFORMANCE IMPACT FOR END USERS

Fixes are available

Version 8.0 Refresh Pack 1 for the IBM Business Process Manager products
Version 8.0.1 Fix Pack 1 for the IBM Business Process Manager products
Version 7.5.1 Fix Pack 2 for the IBM Business Process Manager products

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Bottleneck in the database impacting refresh time due to
original structure of query for inbox refresh. When an inbox
refresh occurs, users experience slow refresh times due to time
spent by the query in the database.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:  Users of BPM Express, BPM Standard, and     *
*                  BPM Advanced on 7.5.1.0.                    *
****************************************************************
* PROBLEM DESCRIPTION: Bottleneck in the database impacting    *
*                      refresh time due to original            *
*                      structure of query for inbox refresh.   *
*                      Slow refresh times due to time spent    *
*                      by the query in the database.           *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Slowness was occurring due to the un-optimized process search
query.

    



Problem conclusion


    

  • Fix optimizes the query used for Process Portal Inbox refresh.

Fix is available on FixCentral.

Install/Dependency information is available in the readme.txt
on FixCentral. When the user goes to the download files page
in FixCentral, the readme will be available with the fix
package as a separate download.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR44506
    • 

  • Reported component name
    BPM ADVANCED
    • 

  • Reported component ID
    5725C9400
    • 

  • Reported release
    751
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2012-10-23
    • 

  • Closed date
    2012-11-14
    • 

  • Last modified date
    2012-11-14
    • 





    

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

    • 

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

    
IC95205
    

    • 



Fix information


    

  • Fixed component name
    BPM ADVANCED
    • 

  • Fixed component ID
    5725C9400
    • 



Applicable component levels


    

  • R750  PSY
       UP
    • 








      
              
                            

              

              [{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            07 October 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback