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
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
...
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>
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
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
show external service <service ID>
list tenant <tenant name> data for service db