Back Forward Working with the Shutdown Rule Usage facility

Overview

For rule types that use rules assembly, PRPC maintains statistics about the number of executions since startup. The system holds these statistics as property values in the Log-RuleUsage class, with additional detail in the Log-RuleUsage-Details class. During system shutdown, the system writes instances of these classes to the PegaRULES database, for later review and analysis. C-2707 KENDM 5.2

Reports from these shutdown statistics can be useful in understanding which rules execute most often, and which execute rarely or not at all.

NoteDon't confuse this Log-RuleUsage data — which cover only rules of those rule types that are converted to Java code by rules assembly — with Log-Usage data, which cover system and requestor performance.

NoteNormally at system startup, the system uses saved snapshot information to "prime" the mostly heavily used rules of the past snapshot into the initially empty Rules Assembly cache. See Working with the Rules Assembly cache.

How it works

As it operates, PRPC maintains statistics in the Rules Assembly cache and the class loader. During application server shutdown, it writes these statistics to the PegaRULES database for later review and analysis.

The rules assembly data presented by the Performance tool covers only your own requestor session. In contrast, these statistics cover all requestors of every type, with cumulative statistics since startup. This can be helpful in identifying the most frequently and least frequently executed rules (for those rule types that are assembled using rules assembly).

By "rule", this topic means "a Java class created by rules assembly". One PRPC activity named Alpha-Mort-.Recalculate may produce multiple such rules, one for each variation in:

You can access these statistics with list view or summary view rules or database reporting tools such as SQL Query Analyzer or Crystal Reports, operating with the pr4_log_rule_usage table.

Key

The value of the pzInsKey key property of a Log-RuleUsage is concatenated from three other property values:

The Java class name identifies the rule type. Three examples are:

DECISIONTREE.RA_DECLARE_DECISIONTREE_RULE_
PARSE_DELIMITED_GETPROMPTKEY_362AD3D39240B644A4CFBE58EA5DA52E

RA_ACTIVITY_DATA_ADMIN_OPERATOR_ID_
SAVEDEVELOPERPREFERENCESXML_0C4D9291362765E0470388C76C1FD527

RA_HTML_FRAGMENT_SMARTPROMPT_
NOINPUT_1EF7F65A6B1B426D7A6E5A270B8DF4DD!

To select rows from a specific node, restrict reporting to those Log-RuleUsage instances that match a fixed pxSystemNode value.

Unlike most other concrete classes derived from the Log- base class, the pxCreateDateTime property is not part of the key of the Log-RuleUsage class.

Statistics

The following properties are of primary interest in each snapshot row. All statistics are since startup of a node or since installation, covering all requestors of all types.

Property

Description

More

pyLabel Identifies the type of snapshot. The value "shutdown" is reserved.  
pxClassName Full Java class name for the rule-assembled rule. rules assembly
pxFamilyName Rule type concatenated with visible key, converted to lowercase characters and converting special characters to underscore characters. For example:

activity_code_pega_list_inuserdesktop

 
pxLastUse Date and time that the rule was last executed, as recorded in the Rules Assembly cache.  
pxNumPeeks Number of times the class loader checked to see whether this entry was loaded.  
pxNumInvalidate Number of times the cache content was invalidated (unloaded), such that the next request forces rules assembly. rules assembly
pxNumLoads Number of times this class was loaded.  
pxNumReload Number of times this class was reloaded without forcing a rules assembly.  
pxRuleCount Number of dependences that this rule has.  
pxCreateDateTime First date and time this rule was captured by this snapshot.  
pxUpdateDateTIme Most recent date and time this rule was captured by this snapshot.  
pxSize Size of the Java CLASS file in bytes.  
pxSystemNode Node ID (hash) on which this snapshot was captured. Node ID
pxUseCount Number of times this rule was requested from the Rules Assembly cache.  

No automatic processing purges rows of the pr4_log_usage table. If your system has been shut down more than once, statistics for pxNumInvalidate, pxRuleCount, pxUseCount, pxNumReload, pxNumPeeks, pxNumLoads are cumulative since installation. Statistics for pxUpdateDateTime, pxLastUse are from the most recent shutdown. KENDM 12/20/06

prconfig.xml settings

Two prconfig.xml settings control this facility. The default values are:

<env name="usage/rules/shapshotonshutdown" value="true" />
<env name="usage/rules/committhreshold" value="100" />

To disable this facility, update the prconfig.xml file to set the value of the shapshotonshutdown setting to false. To change the number of rows added during shutdown before a database commit operation, revise the value for the committhreshold parameter.

As an alternative to the prconfig.xml file, you can use Dynamic System Settings to configure your application.
See How to create or update a prconfig setting.

NoteOn a larger system with thousands of rules in use, set a larger committhreshold value to reduce the shutdown delay

Notes

In the normal table mapping, the system saves these statistics a row of the pr4_log_rule_usage table.

Using the System Management application, you can review these statistics since startup while the system is up, rather than at shutdown:

  1. Start the System Management application.
  2. Select the node of interest.
  3. Select Advanced > Rules Assembly Cache Management.

If desired, you can save interim snapshots of most of these statistics as instances of the Log-RuleUsage class. Run the standard activity Log-RuleUsage.TakeSnapshot, and enter as parameter a snapshot identifier (other than the keywords "shutdown" and "recent", which are reserved). To simplify later retrieval and reporting, enter a snapshot identifier that indicates a date or date and time, such as DEC212006NOON. Unlike the shutdown snapshot, rows of this snapshot contain statistics accumulated since the most recent startup, that is, not consolidated with older snapshot values. KENDM 12/20/06

Definitions prconfig.xml file, rules assembly, System Management application
Related topics Working with the PegaRULES database — Log and miscellaneous tables
Caching in PRPC

UpSysAdmin category