IBM Support

PM92732: Manage Console freeze during running multiple prjects

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 1. Problem description
    Management Console freezes during running multiple projects.
    
      symptom)
       - database is Oracle 11gR2
       - CPU usage is increasing to almost 100% by oracle
       - most of the oracle process is consumed by below 2 SQLs;
    
        UPDATE bf_buildenventry SET bf_seq=:P1 WHERE bf_id=:P2
        SELECT * FROM bf_store WHERE bf_id=:P1 ORDER BY bf_part
    
       - the SQL does full table scan bf_store table
       - after completing the projects, problem disappear
       - problem is getting worse as database is growing
       - the problem occurs twice a day when they run 20 projects
    simultaneously
    
    2.  Environment
        BF Console 7.1.3.5
        Windows 2008 R2 x64
        Oracle 11gR2
    
    3. Prepuce steps.
        Simply running many project at one time.
        Then, MC freeze until complete the projects
    

Local fix

Problem summary

  • This is a performance issue. After adjusting the oracle data
    type and NLS_LANG process, this issue is relieved
    

Problem conclusion

  • Enhance the database performance by changing the data type and
    NLS_LANG process
    Fixed in 8.0.0.1
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM92732

  • Reported component name

    BF SE QUICKREPO

  • Reported component ID

    5724S2708

  • Reported release

    712

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-11

  • Closed date

    2013-11-25

  • Last modified date

    2013-11-25

  • 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

    BF SE QUICKREPO

  • Fixed component ID

    5724S2708

Applicable component levels

  • R713 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSB2MV","label":"Rational Build Forge"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1.2","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
04 May 2022