Updating Database Properties of a Server Instance
Use the update command to update the database properties when Integration Server is in the offline mode.
Note: | If the Integration Server instance is using embedded database, you cannot update the database properties. |
To update database properties of an Integration Server instance
1. Stop the Integration Server instance.
2. Navigate to the following directory:
Integration Server_directory \instances
3. Run the is_instance script as follows:
is_instance.bat update -Dinstance.name=instance_name
-Ddb.alias=database_alias_name
-Ddb.type=database_type
-Ddb.username=database_username
-Ddb.password=database_password
-Ddb.url=database_URL
Where... | Specify... |
instance_name | The name of the instance for which you want to update the database properties. |
database_alias_name | The alias name for the database. |
database_type | Optional. The type of database. Specify one of the following databases:  sqlserver - Microsoft SQL Server oracle - Oracle db2 - DB2 These values are not case-sensitive. |
database_username | Optional. User name to connect to the database. This parameter is mandatory only if you specify the database_type. |
database_password | Optional. Password of the database user. This parameter is mandatory only if you specify the database_type. |
database_URL | Optional. The connection URL for the database. This parameter is mandatory only if you specify the database_type. |
Note: | On restart, if the Integration Server instance fails to connect to the database due to incorrect database configuration, Integration Server falls back to the previous database configuration. |
