Applying hotfixes by using the prpcUtils tool

Use the prpcUtils tool to apply hotfixes from the command line to a single system if you have a direct connection to the database even if you do not have a running instance of the Pega Platform.

All Hotfix Manager operations are available from both the user interface and the command line:

• Scan - compare your system to the hotfixes listed in a hotfix catalog and generate a zip file with the results of the scan. You can share this file with Pegasystems Global Customer Support.
• Generate DDL - create a zip file containing the SQL schema changes for a hotfix archive so that a database administrator can review the changes. If you do not manually apply these SQL changes, the hotfix installation process applies them.
• Install - install a hotfix on your system.
• Rollback - roll back all uncommitted hotfixes and remove them from the system.
• Commit - commit all hotfixes and make them permanent on the system.

1. Open the command-line console for your platform and navigate to the scripts/utils directory.
2. Open the prpcUtils.properties file. The comments in the file include information about valid values for each property.
3. Configure the database properties:
   • pega.jdbc.driver.jar=<path to your database jar file>
   • pega.jdbc.driver.class=<your database driver class>
   • pega.database.type=<database vendor type>
     Enter udb, db2zos, mssql, oracledate, or postgres.
   • pega.jdbc.url=<URL of your current database>
   • pega.jdbc.username=<deployment user name>
     
   • pega.jdbc.password=<deployment user password>
4. Configure the hotfix operation:

   hotfix.operation=<action>
   Valid values are scan, install, rollback, commit, and GenerateDDL.

5. Configure the required hotfix parameters:

   Hotfix operation	Required parameters
   scan	hotfix.CatalogPath= <full path to the Catalog.zip file> hotfix.scan.downloadPath= <full path and .zip file name> where you plan to save the scan results
   install	hotfix.DLFilePath=<comma-delimited list of hotfix package DL file names and paths>
   rollback	There are no additional parameters. If you run rollback, all uncommitted hotfixes uninstall.
   commit	There are no additional parameters. If you run commit, all uncommitted hotfixes become a permanent part of the system. You cannot roll back committed hotfixes.
   GenerateDDL	hotfix.DLFilePath=<comma-delimited list of hotfix package DL file names and paths>

6. Save the file.
7. Run the prpcUtils.bat or prpcUtils.sh utilities script with the manageHotfixes option. For example:
   run prpcUtils.sh manageHotfixes
8. Review the log file. Command-line actions may succeed but still result in partially-installed hotfixes. If the log file lists any additional required actions, complete the action and then repeat step 7.

Open topic with navigation