More about Database Table
data instances
|
|
Work with a database administrator to
coordinate all changes, create new databases, move data, or change
database schemas. Changes to Database Table instances do not alter the
database or its schema.
If you update a Database Table data instance to map an existing table that contains rows to a different class, first move the data from the original table to another table (at a time when Process Commander is not running). Otherwise, rows from the objects in the new class may overwrite the existing rows.
Click the Test Connectivity button on the Basic tab of a Class form for any concrete class to determine which table and database that Process Commander uses for instances of that class. This button works for both internal classes — classes mapped to the PegaRULES database — and external classes created by the Connector and Metadata wizard. C-1854
To obtain a current record count for a table (identifying Rule-Obj-Class names):
> System > Tools > System Management App to
start the System Management application. BYRNB 2/25/10Consult the schema documentation — an HTML file on the Process Commander installation media — for information on the database schema as it was when your system was installed. To see the current structure and columns of each table, use the Modify Database Schema wizard.
If a database administrator directly updates a PegaRULES database table while the system is running, you do not need to stop and restart the servers. Open and resave the affected database table data instances to cause users to access the modified table schema. CLINB clinic 5/29/07 (Resaving is not necessary when you use the Modify Database Schema wizard to modify the database table schema.)
If your system uses a reports database, be sure to repeat any schema updates made to the PegaRULES database to the affected tables of the reports database.
