IBM Support

PM69032: COGADMIN PERFORMANCE ISSUE TO RETRIEVE ACTIVITIES INFORMATION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed with unknown close code.

Error description

  • The admin page is constructed to filter the output of the
    current activities/and others by time period (default 4 hours)
    and number of activities (default 15).  To improve productivity,
    people often change the list length to 999 (maximum allowed) to
    avoid pagination.  This works fine for report pagination.
    However, this setting also apply to admin pages.   When the
    system is in trouble, administrators often go to admin page to
    check the system status.   The system like BACC just has too
    many activities in the short period of the time,  this lead to
    large queries to retrieve all current activities/past
    activities/upcoming activities.  We saw a query to retrieve
    report names of 600 saved output, and many of them are in
    personal folder area that involves permission check.  The query
    is non blocking, therefore causes no harm to the system
    directly, however, the load it put on the system is not disable
    as the system is already under stress.  Often, the admin page
    comes back blank because we did not wait long enough for the
    result to come back.  The query runs over 10 mins in the log.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
    * Pack 1                                                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM69032

  • Reported component name

    COG8 BI INST CO

  • Reported component ID

    5724W12IC

  • Reported release

    841

  • Status

    CLOSED URX

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-17

  • Closed date

    2013-06-11

  • Last modified date

    2013-06-11

  • 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":"SSCHM94","label":"Administration and Configuration v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"841","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 June 2013