Among other things, you can use the transaction Displaying/Changing Integration Data to change a database connection.
Note
To change a dataabase connection when using SAP liveCache technology, the liveCache-specific user menu Change Connection is available.
In the Database Assistant, choose (transaction DB11).
Enter the name of the database connection.
To be able to change integration information, you must be in change mode. Switch to this mode, if necessary.
Check the information about the database connection (Database Name and Database Server) for completeness and accuracy.
If necessary, you can make specifications for the user data or control areas of the automatic monitoring.
Choose
.The system displays a message if the database connection was changed successfully. The connection information is stored in the tables DBCON and DBCONUSR.
Note
After changing the database connection, you must stop and then restart all application servers that have access to the database instance. Otherwise, significant connection problems can occur.
Stop and restart all application servers that have access to the database instance.