If you run ARIS using an external database management system and the operational database server has moved, you must update the settings, for example, the IP address and the server name.
Procedure
Stop all runnables, except the zoo runnable (service registry).
Determine the service ID of the external database service to be changed. Enter: list external services
Check the current settings of the external database settings. Enter: show external service <service ID>
Example: show external service db0000000000
Depending on the database system in use different settings are displayed.
Output example (Oracle):
Service db0000000000 (Type DB)
Parameters:
...
host sbrva100.com.ad.aaf
...
url jdbc:oracle:thin:@//sbrva100.com.ad.aaf:1521/aris
...
Output example (Microsoft SQL Server):
Service db0000000000 (Type DB)
Parameters:
...
host sbrva100.com.ad.aaf
...
url jdbc:sqlserver://sbrva100.com.ad.aaf;DatabaseName=aris10db;instanceName=aris
...
Change the required settings using the update external service command.
Example (Oracle):
update external service <service ID> url="jdbc:oracle:thin:@//<Oracle server>:<listener port>/<instance name>" host=<Oracle server>
Example (Microsoft SQL Server):
update external service <service ID> url="jdbc:sqlserver://<Microsoft SQL Server>:<listener port>;DatabaseName=<database name>;instanceName=<instance name>" host=<Microsoft SQL Server>
Check the applied database schema. Enter: list tenant <name> data for service db
Output example (default tenant):
Data of tenant default tenant for application db
Key Value
com.aris.cip.db.schema aris_default
com.aris.ecp.db.schema aris_default
name default
Change the schema settings for all tenants, if required. Enter:
set tenant <tenant name> data for service db com.aris.cip.db.schema=<new schema name>
Example (master tenant):
set tenant master data for service db com.aris.cip.db.schema=aris10_master
(com.aris.ecp.db.schema not needed)
Example (default tenant):
set tenant default data for service db com.aris.cip.db.schema=aris10_default com.aris.ecp.db.schema=aris10_default
Check the new settings using the commands:
show external service <service ID>
list tenant <tenant name> data for service db
Start all runnables. Enter: startall