About the Property Optimization tool

Basics

XXXXXXXXXXXXXXX REVISE FOR V6.2 NEW FEATURES XXXXXXXXXXXXXXXXXXXXXXXXXXX

xxxxxxxxxxxxxx MENTION THE NEED TO ENABLE THE PEGA-RULESENGINE AGENT FOR BACKGROUND PROCESSING XXXXXXXX

Use the Property Optimization tool in a development system to expose a top-level Single Value property as a database column, and to populate the new column by extracting values from the Storage Stream (BLOB or pzPVStream) column. V6.1SP2

The Property Optimization tool also can "expose" values of an embedded property by automatically creating an appropriate Index- class and Declare Index rule.

This capability is available if your development environment meets these prerequisite conditions:

• the production level of the system is 1 or 2
• the prconfig.xml setting database/AutoDBSchemaChanges is not set to false
• the Data-Admin-DB-Name data instance named PegaRULES identifies, for either the primary database username and password, or the alternate Admin username and password, credentials that allow the ALTER TABLE and CREATE TABLE capabilities for the database.

Starting the Property Optimization tool

From the Application Explorer, right-click a property name and select Optimize for Filtering from the context menu to start a three- step Screen Flow.

• If the property is a top-level Single Value property, no additional inputs are needed. The tool creates a new database column and starts a background process to populate values for the new column (for existing instances of this class only) from BLOB values. Background processing may take minutes or longer, depending on volume, and computations involving the property value may fail or produce incorrect results until all background processing is complete.
• If the property is embedded, you may be prompted for a RuleSet and Version that is to contain the new Index- class, the properties in that class, and the Declare Index rule. Select a RuleSet and Version and click Create. The tool creates a concrete Index- class, properties for the new class, and a Declare Index rule that maintains the indexes. (Background processing creates the instances of the new Index- class. )

Status display

Select > System > Tools >Column Population status to see the status of jobs that are queued for background processing by the Pega-RulesEngine agent.

Logs

xxxxxxxxxxxxxx Log-PropertyOptimizer class , keyed by JOB ID XXXXXXXXXXXXXXXXXXXXX

Notes

• The Property Optimization tool provides an alternative to the Modify Database wizard and the Column Populator tool in specific situations for Single Value properties. For aggregate and embedded property values, this feature provides an alternative to the Declarative Index wizard .
• Column population (or Index- creation) processing occurs in the background and may take minutes or hours or longer to complete, depending on volume and system load.
• On the Advanced tab of the Property form, you can determine which classes can access the exposed column. WHY?

Temporary links: Help1Help2Help3

	exposed column, production level, Storage Stream
	Property Optimization tool — Status display About the Application Explorer Working with the PegaRULES database — Table and column basics Understanding the Pega-RulesEngine agent

About the Application Explorer

Tools, accelerators, and wizards