IBM Support

PI11593: APPLYING TM1 10.2 FP1 AFFECT NEGATIVE IMPACT FOR MTQ ON USING CPU EFFECTIVELY THEN IT CAUSE PERFORMACE ISSUE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • Prerequisite:?Applying FP1 to TM1 10.2 AIX.?It gave negative
    impact for MTQ  on using CPU effectively.?Then this leads
    performance issue when user execute report from BI AIX. Reports'
    data source is TM1. MTQ is set as 8 intm1s.cfg.?the AIX server
    has 3 physical cores (and 4 logical cpus are assigned for each
    physical core so the sar command shows 12
    cpu).??Findings:?Process of creating stargate cube  on TM1 10.2
    FP1 may take longer than that on TM1 10.2??execution time
    comparison?TM1 10.2 FP1 - that of TM1 10.2 = delay??1)from
    execution result of scheduled report?5m10s - 1m41s= 3m29s =
    approx. 3m30s??2)from debug level tm1server.log?267205ms -
    56806ms = 210,399 ms = approx. 3m30s (210s)???Result?1)Execution
    time?--------?TM1 10.2?sar- p result/physc =3.00?Time required
    execution report=?1m41s??--------???? ??TM1 10.2 FP1?sar- p
    result/physc =1.08?Time required execution
    report=?5m10s?-------- ??2)tm1server.log?Extracted records of
    stargate operation from TM1 10.2 and TM1 10.2 FP1??TM1 10.2
    GA?tm1server.log.20140211.test1(12512): 4115   [2]   DEBUG
    2014-02-11 06:43:44.855   TM1.Cube.Stargate   New Stargate
    Created (0x344ca44c0) in 6388ms SGSize=1180Kb workPoolSize=0Kb
    hPoolSize=159Kb.?tm1server.log.20140211.test1(33601): 4115   [2]
      DEBUG   2014-02-11 06:43:50.922   TM1.Cube.Stargate   New
    Stargate Created (0x3493db5a0) in 1560ms SGSize=2204Kb
    workPoolSize=0Kb
    hPoolSize=159Kb.?tm1server.log.20140211.test1(55463): 4115   [2]
      DEBUG   2014-02-11 06:43:55.032   TM1.Cube.Stargate   New
    Stargate Created (0x349c3b5e0) in 485ms SGSize=1180Kb
    workPoolSize=0Kb
    hPoolSize=159Kb.?tm1server.log.20140211.test1(79619): 4115   [2]
      DEBUG   2014-02-11 06:44:46.009   TM1.Cube.Stargate   New
    Stargate Created (0x34acdb660) in 48373ms SGSize=2204Kb
    workPoolSize=0Kb hPoolSize=159Kb.??TM1 10.2
    FP1?tm1server.log.20140211.test2(12810): 4115   [2]   DEBUG
    2014-02-11 06:58:35.319   TM1.Cube.Stargate   New Stargate
    Created (0x344bc6580) in 28889ms SGSize=1180Kb workPoolSize=0Kb
    hPoolSize=159Kb.?tm1server.log.20140211.test2(33647): 4115   [2]
      DEBUG   2014-02-11 06:58:41.539   TM1.Cube.Stargate   New
    Stargate Created (0x344bf3f60) in 1752ms SGSize=2204Kb
    workPoolSize=0Kb
    hPoolSize=159Kb.?tm1server.log.20140211.test2(55453): 4115   [2]
      DEBUG   2014-02-11 06:58:45.009   TM1.Cube.Stargate   New
    Stargate Created (0x3534e84a0) in 466ms SGSize=1180Kb
    workPoolSize=0Kb
    hPoolSize=159Kb.?tm1server.log.20140211.test2(76291): 4115   [2]
      DEBUG   2014-02-11 07:02:43.215   TM1.Cube.Stargate   New
    Stargate Created (0x353521380) in 236098ms SGSize=2204Kb
    workPoolSize=0Kb hPoolSize=159Kb.
    

Local fix

  • not apply FP1
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to TM1 10.2.2                                 *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI11593

  • Reported component name

    TM1 SERVER

  • Reported component ID

    5724W49SE

  • Reported release

    A11

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-02-12

  • Closed date

    2014-05-13

  • Last modified date

    2014-05-13

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

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

Fix information

Applicable component levels

  • RA22 PSN

       UP



Document information

More support for: Cognos TM1
TM1 Server

Software version: 10.1.1

Reference #: PI11593

Modified date: 13 May 2014