IBM Support

PI14264: After upgrade, performance degradation is observed in Dynamic Query Mode (DQM) crosstab report connecting to TM1

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Performance degradation is observed in specific reports (DQM
crosstab reports) upgraded from C10.1.1 to C10.2.1, and
problematic reports are about 1.5 times slower than C10.1.1,
while most DQM reports connecting to TM1 data source run faster
than C10.1.1.  NOTE: This degradation issue occurs even in BI
server environment applying performance-related
fix(10.2.5001.1038) for APAR(PM98021). Also, C10.2.1FP2 produces
the same issue.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* All Users                                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See error description.                                       *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack  *
* 4                                                            *
****************************************************************

    



Problem conclusion


    

  • Code Fix

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PI14264
    • 

  • Reported component name
    COG ADMINISTRAT
    • 

  • Reported component ID
    5724W12AD
    • 

  • Reported release
    A21
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2014-03-21
    • 

  • Closed date
    2014-08-15
    • 

  • Last modified date
    2014-08-15
    • 





    

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

    • 

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

    • 



Fix information


    

  • Fixed component name
    COG ADMINISTRAT
    • 

  • Fixed component ID
    5724W12AD
    • 



Applicable component levels


    

  • RA21  PSN
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"","label":""}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            06 March 2023
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback