A fix is available
APAR status
Closed as program error.
Error description
Each time when invoking saved search, two sql cmds will be invoked internally. One is to query the content, while the other is to count the query resultset number. But these two query are really heavy. And the second one is not really necessary for end user. And It could be very helpful for performance improvement, if the SQL "select count (distinct t.bpd_instance_id)..." could be avoided.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: Users of BPM Express, BPM Standard and BPM * * Advanced. * **************************************************************** * PROBLEM DESCRIPTION: Saved searches in Portal can be time * * consuming if the result set is large. * **************************************************************** * RECOMMENDATION: * **************************************************************** For each time when invoke saved search, two sql cmds will be invoked internally. One is query the content, while the other is to count the query resultset number. But these two query are really heavy. And the second one is not really necessary for end user. And It could be very helpful for performance improvement, if the SQL "select count (distinct t.bpd_instance_id)..." could be avoided.
Problem conclusion
The fix was to remove the count query and is available on fix central. The fix is included in the JR42280 fix package: http://www-01.ibm.com/support/docview.wss?uid=swg1JR42280 JR42280 prereqs JR42012: http://www-01.ibm.com/support/docview.wss?uid=swg1JR42012 Install Instructions: - Install JR42012 and JR42280 on both Process Designer and Process Center/Server using IM (install PD fixes one at a time) - On Process Center/Server run bpmprofileUpgrade as outlined in http://www-01.ibm.com/support/docview.wss?uid=swg27022245#recove rFailure - On Process Center/Server run upgrade7x using the instructions outlined in http://publib.boulder.ibm.com/infocenter/dmndhelp/v7r5m1/topic/c om.ibm.wbpm.imuc.doc/upgrade/topic/upgrading_existing_dbs_751.ht ml
Temporary fix
Comments
APAR Information
APAR number
JR42160
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
751
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-03-06
Closed date
2012-04-18
Last modified date
2012-04-23
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
BPM ADVANCED
Fixed component ID
5725C9400
Applicable component levels
R750 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
12 October 2021