Populating database columns using the Column Populator

Use the Column Populator when the Pega Platform is not running.

You can run the Database Column Populator utility when Pega Platform is in use. However, the utility does not acquire a database lock on the rows it modifies. If a requestor updates an object at the same time that the Database Column Populator updates the corresponding database row, one of the updates might be overwritten and lost.

To populate database columns:

1. Install a JDK (Java 7 or later) and define the path to that JDK in a JAVA_HOME environment variable.
2. Navigate to the scripts/utils subdirectory in the installation directory.
3. Edit the prpcUtils.properties file:
   • Provide the database connection information in the DB CONNECTION section.
   • Set the column populator parameters in the SETTINGS FOR EXPOSE TOOL section.
   • Save the properties file.
4. Run the appropriate utilities script for your platform, prpcUtils.bat for Windows or prpcUtils.sh for Unix systems, with the expose option. For example:

   ./prpcUtils.sh expose

The column populator utility:

1. Assembles a list of concrete classes to be processed.
2. Determines which database tables contain the rows corresponding to instances of these classes.
3. Performs an SQL Open statement immediately followed by an SQL Save statement for each row corresponding to those classes.

Open topic with navigation