Troubleshooting: Unexpected large numbers of queries to pr_engineclasses table causes unnecessary DB traffic (HFix-4114)
Summary
As a database administrator (DBA), you run a Top SQL database report to identify the SQL statements that are producing the highest load on the system. The report reveals an unexpected and excessive number of queries to the pr_engineclasses table coming from PRPC 6.1 SP2.
Problematic Query Syntax
select pzbinarycontent, pzstate
from pr_engineclasses
where pzpackage = ? and pzclass = ? and pzjar = ? and pzcodeset = 'pega-enginecode' and pzcodesetversion = ?
ORDER BY pzpatchdate DESC
HFix-4114 for PRPC 6.1 SP2 changes the implementation to eliminate the unnecessary queries to the pr_engineclasses table which were causing excessive DB traffic.
Suggested Approach
- Contact Pegasystems Global Customer Support (GCS) and request HFix-4114.jar for PRPC 6.1 SP2.
- Follow the instructions in the ReadMe.txt file included with the hotfix.
IMPORTANT: You must contact Pega GCS to obtain HFix-4114.jar for PRPC 6.1 SP2, because the nature of this update precludes it from being installed with the Update Manager.
Previous topic Troubleshooting: JVM hangs on conclusion cache read or update (HFix-10223 replaces HFix-8969) Next topic Known Issues