Hi! I am facing a tricky issue here that I am not sure if anybody has solved before.
We had to change the IP address of a mysql server that is central to our data infrastructure.
Therefore we were forced to change for each of the TAS and activities that referred to this connection IP to the new one.
2 weeks after the change I still keep an eye on new processes that are triggered just in case they are still pointing to the old server.
I though that only changing the IP address of the connection in TOAD it would “inform” to the activities somehow but I have realized that this is not the case…
I am considering using a domain name dataserver.domain.com and make changes in the IP under the domain… but I am worried about impacts in performance.
My question is very simple, how can I change the connection settings of all the TAS and activities that pointed to the old server to the new one in a way that does not imply to go one by one? Any original idea on how to manage this the next time the issue appears?