Pega Sites

Tech Papers

These technical papers describe V4 and V5 Process Commander internals and advanced features, in three sections:





PDF Document Automated Testing -- Running Test Cases and Test Suites (1.1MB)
The PegaRULES Process Commander Automated Testing feature helps you to implement testing strategies for your Process Commander applications while you build them.

When this feature is enabled, you can save the test data you used to test a decision table, decision tree, SOAP service, or flow rule with the Run Rule feature as a test case rule. In addition to how to enable the feature, the document describes test cases, test suites, and the Automated Testing window that you use to schedule test suites.

See also Automated Unit Testing.


PDF Document Database LOB Sizing and Performance Optimization  (108KB)
This document explains how to estimate disk usage and tune performance of BLOB (Binary Large Object) data for Oracle, IBM DB2, and Microsoft SQL Server.

Supporting file: (5 KB)

 PDF DocumentDesigning Applications that Ensure Data Integrity  (981 KB)
This document describes how Process Commander locks objects, manages commit operations, it manages and/or participates in transactions. It provides the information you need to design applications that take advantage of Process Commander's default object locking behavior and to configure custom processing for your applications that follows best practices: obtaining object locks as appropriate, and gracefully managing errors when an object lock already exists or when commit operations fail.
5.1, 5.2
PDF Document Migrating Database Character Sets for Oracle (89 KB)
There are many reasons to migrate a database from one character set to another. For example, as companies internationalize their operations, requirements to support new languages necessitate the move to multi-lingual database instances. Typically, the migration requires the movement of the PegaRULES database instance from a specific character set to a multi-lingual character set; for example, from US7ASCII to Unicode.

PDF Document Purging and Archiving Work Objects (935 KB)

Update: Beginning with V5.3, the Purge/Archive wizard should be used to automatically remove and archive old work object data from a production database. See About the Purge/Archive wizard for more information.

If information from older work objects is no longer needed, it makes sense to remove selected older data from the live production database, possibly storing it in a separate archive system. You can implement such purging and archiving with standard relational database operations. This article describes the PegaRULES database tables that hold work object details and the relationships among them, and provides sample SQL statements for specific situations.


PDF Document Writing Effective SQL for PRPC (135 KB)
By following simple guidelines, you can write efficient SQL statements in Rule-Connect-SQL rules that optimize the use of the PegaRULES database with minimal performance impact. This document provides a set of guidelines for writing SQL including:


  • Practical suggestions when writing SQL
  • Recommendations for writing SQL
  • Methods to obtain SQL query plans on various databases


PDF Document Declare Indexing  (437 KB)
Declare indexes, created by Rule-Declare-Index rules allow access to data that was previously not exposed as database columns. This approach is an easier and more efficient way to select data for a variety of reporting and processing purposes.
PDF Document JSP Stream Support  (755 KB)
Introduced in 5.1, JavaServer Pages are the de-facto standard for text and HTML formatting in servlets. Through this technology, performance is improved and the PegaRULES engine is immediately accessible without proprietary "directives" markup. Topics include:


  • JSP tags in manually-written or form-based streams
  • JSP Tags in the pegatag library
  • Converting a rule to JSP tags
  • Known issues
 PDF Document Localizing an Application  (2.63 MB)
The WorkUser and WorkManager portals may be localized, not only for applications, but including basic functionality such as the Portal and standard reports. Topics include:


  • Setting the locale
  • Localized RuleSets
  • Language packs
  • Building a localized application using field values
  • Localized HTML references
4.2, 5.1
PDF Document Rule Caches (697 KB)
To allow the powerful rule resolution process to occur with the required performance levels for enterprise-scale systems, Process Commander uses multiple caches. Some caches are stored in the system memory (JVM), some are stored in the database, and some are stored on disk. This document contains descriptions and tuning information for the following caches:
  • Rule cache
  • Rule Assembly cache
  • Dictionary caches
  • Static Content cache
  • LookupList cache
PDF Document Search Features (Lucene Indexing) (1.10 MB)
This document describes the full-text search facility that makes finding specific rules easier. Topics include:


  • Find Rules tool
  • Lookup Rules tool
  • Find Content (full text search) tool

Reference and miscellaneous


PDF Document Configuration Settings Reference Guide V6.2 (1.1 MB, September 2011)
This document provides a consolidated reference to settings for each Process Commander V5X version, through V6.2:

  • Prconfig.xmlfile entries
  • System settings rules (Rule-Admin-System-Settingsrule type)
  • Dynamic system settings (Data-Admin-System-Settings class).

It describes the various entries for each type of setting, and explains in detail how they may be used.

PDF Document PEGARULES.XML File Settings Reference (470 KB)
The pegarules.xml file holds the preferences that can be set or changed for a Version 4 installation.
PDF Document Understanding System Settings (159 KB)
The System Settings feature (Data-Admin-System-Settings class) provides a place where you can store and manipulate system constants. See also other PDN papers related to this feature:
5.X, 6