Removing index host nodes by using a direct connection to the database
In a multinode cluster system, the index files required for search can be hosted on one or more nodes. To remove an index host node by using a direct connection to the database, complete the following steps.
- 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 index node properties of the
prpcUtils.properties
file.Property name Value removeIndexNode.nodeId
The node ID of the index node to be removed. - Save and close the
prpcUtils.properties
file. - Run the
prpcUtils.bat
orprpcUtils.sh
script with the removeIndexNode option, for example:prpcUtils.bat removeIndexNode
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 Configuring index host nodes from the user interface Next topic Viewing the status of an external search service