How to use a reports database

Execution of reports — summary view rules and list view rules — by application users or by agent processing may provide a substantial source of database processing database demand in some cases.

To reduce the performance impact of report execution, you can direct that some reports obtain data from a separate reports database, which is a copy (a replicated mirror) of all or part of the live PegaRULES database.

The reports database must have the same structure (tables and columns ) of the live database, but may contain only a subset of the tables needed for reporting, and may contain slightly stale data.

To use a reports database:

1. Work with a database administrator to create the reports database, identifying the tables, indexes, and views that need to be included.
2. Work with a database administrator to set up the replication, which may use master-slave or other mirroring techniques.
3. Create a database data instance (Data-Admin-DB-Name) for the reports database and establish connectivity.
4. Update Database Table instances to identify this database in the Reports Database field.
5. Select the Use alternate database? option on the Content tab of list view or summary view rules that are to extract data from the reports database.

To disable use of a reports database even when the Use alternate database? option is set and the Reports Database field is not blank, add the following entry to your prconfig.xml file.

<env name = "database/useReportingDatabase" value="false" />

The default value is true.

Use of a reports database is less helpful in situations where JVM memory, CPU processing, or network traffic are more serious bottlenecks than database processing.

To force the use of a reports database even for standard reports (for which the Use alternate database? option is not checked), set the pyUseAlternateDb parameter to true when calling the Rule-Obj-ListView.ShowView or Rule-Obj-SummaryView.ShowView activities.

	reports database
	About Database Table data instances List View form — Completing the Content tab Summary View form — Completing the Content tab
	Atlas — Standard Database Table instances

SysAdmin category