Installing hotfixes by using a direct connection to the database
To automate hotfix installation, use the command-line tools by using a direct connection to the database. This is most commonly done for a stopped instance.
- Configure the common properties of the
prpcUtils.properties
file.Property name Value pega.jdbc.driver.jar
Path to the database driver .jar file. pega.jdbc.driver.class
The database driver class. pega.database.type
Database vendor type. pega.jdbc.url
URL of your database. pega.jdbc.username
Database user name. pega.jdbc.password
Database password. rules.schema.name
If you use a split schema, the value for the rules schema name. If you do not use a split schema, the value for the schema name. data.schema.name
If you use a split schema, the value for the data schema name. - Configure the install properties of the
prpcUtils.properties
file.Property name Value hotfix.operation
install
hotfix.dlFilePath
The full path to the hotfix package file. hotfix.bypassSchema
The default value, false
, applies any schema changes automatically. A value oftrue
indicates that you have already manually applied the schema changes.hotfix.force
Set only at the request of Pegasystems Global Client Support to skip hotfix validations and force the hotfix data into the system. hotfix.async
true
orfalse
. The default value,true
, executes the hotfix operation asynchronously. The system queues the job and returns a JobID to use to get the job status. A value offalse
executes the operation synchronously. -
Save and close the
prpcUtils.properties
file. - Run the
prpcUtils.bat
orprpcUtils.sh
script with the manageHotfixes option, for example:prpcUtils.bat manageHotfixes
- Optional: Pass one or more arguments.
prpcUtils script argument Value connPropFile
The full path to the connection.properties
file that includes information for multiple targets.driverClass
Your JDBC driver class. For example, oracle.jdbc.OracleDriver. driverJAR
Location of your JDBC .jar file. dbType
Database vendor type, such as mssql, udb, oracledate, postgres, and db2zos. dbURL
JDBC URL to the database. dbUser
Database user name. dbPassword
Database password. archivePath
Full path to the archive to be imported or exported. propFile
The full path to the properties file, to override the default prpcUtils.properties. hfixAction
If manageHotfixes is selected, sets the hotfix operation. Valid values are commit
,rollback
,generateDDL
,install
, andscan
.rulesSchema
The rules schema. dataSchema
The data schema. noFailOnError
Set to true
orfalse
. When enabled, instances that fail to import are skipped and import continues instead of failing.U
Pega user name. P
Pega password. accessGroup
AccessGroup in which the Rule-Declare-Index of the classes being exposed exists. Applicable for the expose utility if --U or --P are not provided.
Previous topic Installing hotfixes by submitting a request to an active instance Next topic Rolling back hotfixes