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.