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.
![*](icon_task_xpe.png)
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.