Issue

Multiple users are encountering slow engine startups ranging from 40 minutes to 1 hour on starting the Pega server.

Symptoms and Impact

• Pega server takes more than 20 minutes to start.
• Stuck queries display on the pr_engineclasses table.

Steps to reproduce

1. Start the Pega server.
2. Observe the behavior.

Root Cause

The pr_engineclasses table does not contain database indexes.

Solution

Add the following indexes to the pr_enginesclasses table in the mentioned order of columns only:

1. CREATE INDEX RULES_SCHEMA.PR_EC_EXCL_MODIFIED_GCS ON RULES_SCHEMA.PR_ENGINECLASSES ( PZPACKAGE, PZCLASS , PZJAR, PZCODESET, PZCODESETVERSION, PZPATCHDATE );
2. CREATE INDEX RULES_SCHEMA.PR_ENGINECLASSES_ALL ON RULES_SCHEMA.PR_ENGINECLASSES("PZCLASS","PZJAR","PZCODESET","PZCODESETVERSION","PZPATCHDATE","PZPACKAGE","PZLASTMODIFIED");