Basics
This wizard allows you to view, and in some cases modify, the schema
of the PegaRULES database. iewmodifyschema0 When viewing the
database, you can determine:
- Which concrete classes are mapped to each database table
- Which properties in each class are exposed as distinct
columns
- Which
Single Value
properties in each class are not
exposed but are contained in the Storage Stream (BLOB) column
With appropriate database account and password, you can also use this
wizard to copy a Single Value
property from the Storage
Stream and expose it as a column.
To start the wizard
To start the Modify Database Schema wizard:
- Select> Data Model > Tools > Modify Database Schema.
The wizard starts.
- Click the help button () on any
form for guidance on completing that form.
Notes
Changes to expose additional properties as columns
require planning and care:
- To expose one or a few Single Value, top-level property and populate values in a development system, consider the Property Optimization tool as an alternative to the Modify Database Schema wizard.
- Only database administrators who are familiar with SQL, DDL, and
database schemas are qualified to make changes to the schema to expose
additional properties.
- In most cases, changes made to a table structure in a development or test system must also be made to the similar table in a production system.
- Exposing additional columns may affect the performance and
tablespace requirements of the database. Column populator operations
may require minutes or hours to complete. Perform column populator
processing at a time when rows of the affected table are not locked by
other Process Commander users (so no add, delete, or update operations
occur during this process).
- If, in the Storage Stream (BLOB) column, the selected property or
properties has non-blank values for at least some rows, you must
extract (copy) the existing values into the new column. Use the Column
Populator utility. See Working with
the PegaRULES database — Using the Column Populator
utility.
- To expose a property, obtain a database account and password that
allows such database restructuring (SQL ALTER TABLE grant). The
database account password used for normal Process Commander operations
may lack this capability. If so, you can explore, but not update, the
schema with this tool.
- As an alternative to immediate alteration of the database, the
Modify Database Schema tool can generate an SQL statement (as a text
file) to be applied later.
- In a multinode cluster, new database columns are not visible on
nodes other than the node that was used to expose the column, until
the node is stopped and restarted. To make the new column visible
simultaneously on all nodes, stop and restart the entire system.
CLINIC 3/13/09
- If the Process Commander server connects to the selected database
using JDBC URL, the URL may include < and > characters. Some
authentication and security software can be configured to reject URLs
containing these characters, as a security precaution. As a
workaround, change the software settings to allow these characters in
this situation. SR-448
-
The Storage Stream column
(pzPVStream) of the
pr_operators
table
contains Operator ID passwords in encrypted form. For maximum security
of your Process Commander system, do not alter the schema for this
table to expose the password property as a column. OLSOK CLINIC
1/20/06
- By design, you can't select the
pr_other
table,
because no Data-Admin-DB-Table instance is linked to it.
Use database utilities to move the rows to a more appropriate table,
create an associated Data-Admin-DB-Table instance, then
use this wizard to expose the columns.
Tools, accelerators, and wizards