refresh_sql_connections

Definition

To force the update of the connections to the database

Command Usage

Command Arguments

Name	Description
<INST_TARGETS>	Optional: The list of target instances of the SAP CC system (instance IDs or instance types)

Detailed Information

The refresh_sql_connections command updates the database connections of all the instances of the SAP CC system. Each instance of the SAP CC system disconnects and immediately reconnects to the database system. You can not select a specific instance of the SAP CC system.

The back-end database system has a unique instance.

Use

In a non HA environment including a mono-instance database system, the SAP CC system provides a database disconnection detection function that automatically tries to establish the connection back. You use this refresh_sql_connections command if this automated function failed.

Troubleshooting Operations (System and User)

You force the refresh of all the database connections.

Authorization

You must have a specific role in your SAP CC user profile. Refer to the SAP CC Security Guide for more information about the necessary authorizations.

See Also

admin_sql_connection - To disconnect from or to force the reconnection of the selected instances of the SAP CC system with a selected instance of the database system

Additional Information

Consult the SAP CC System Parameter Reference documentation for more information about the configuration settings dedicated to the database management: JDBC URI, reconnection period, reconnection attempts.

Message(s)

Code	Message	Action
err.bad_targets	Error: Bad target: {target}.
refreshSQLConnections.ok	The SQL connections are now updated.
refreshSQLConnections.nok	Error: An error occurred during the update of the SQL connections.