IBM Support

PM84886: PERFORMANCE PROBLEM WHEN SETTING COGNOSMDX.CELLCACHEENABLE=TRUE IN TM1S.CFG

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as unreproducible.

Error description

  • There are performance differences between TM1 10.1.0 FP1 and TM1
    10.1.1, as below. Slow performance observed in TM1 10.1.0 FP1
    should be fixed under the condition of
    (CognosMDX.CellCacheEnable=True and provider crossjoin is turned
    off)  - TM1 10.1.0 FP1 (Turn off provider crossjoin):
    CognosMDX.CellCacheEnable=True (Slow) vs
    CognosMDX.CellCacheEnable=False (Fast)  - TM1 10.1.1 (Turn off
    provider crossjoin):  CognosMDX.CellCacheEnable=True (Fast) vs
    CognosMDX.CellCacheEnable=False (Fast)  The performance
    improvement is observed with the customer 's report under the
    following 3 conditions: 1. Add zero suppression 2. Use TM1
    10.1.1 (not TM1 10.1.0 FP1) 3. Use the same configuration as the
    customer's current Tm1s.cfg except the turn off provider
    crossjoin on both BI and TM1  However the performance
    improvement is *not* observed with TM1 10.1.0 FP1 (customer's
    environment).   CognosMDX.CellCacheEnable=True has been made the
    default setting as of TM1 10.1 see the APAR PM67469.
    

Local fix

  • Set CognosMDX.CellCacheEnable=False in Tm1s.cfg
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to IBM Cognos TM1 10.2                        *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM84886

  • Reported component name

    COG CONNECTION

  • Reported component ID

    5724W12CC

  • Reported release

    A11

  • Status

    CLOSED UR3

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-15

  • Closed date

    2014-11-04

  • Last modified date

    2014-11-04

  • 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 CONNECTION

  • Fixed component ID

    5724W12CC

Applicable component levels

  • RA20 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWN","label":"Portal v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A11","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 November 2014