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":"SSEP7J","label":"Cognos Business Intelligence"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"841","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
06 March 2023