Integration Server 10.11 | Integration Server Administrator's Guide | Running Multiple Integration Server Instances | Updating Database Properties of a Server Instance
 
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.