couple of questions
Does each database (MDS_PRD and MDS_UAT) already have an existing domain database with content created?
Why are you trying to switch the domain level database from production to a lower env?
Was the intent to switch the PwC repository service database?
If you are trying to change Repository database details then you need to make changes to the Repository. Updategatewaynode will make changes to the domian database.
1.Revert changes made to the nodemeta.xml file using updategatewaynode command or by replacing nodemeta.xml file if you have taken backup bfore making changes.
2.Bring up the service
3.Login to Adminconsole -> Repository service -> Edit database properies and change the below
to point to new database.
As Smitha mentioned, Updategatewaynode is for Domain DB, you would need to revert the changes and update the connection string for Repository from the Admin console.
You can refer to KB 108709 for details on how to migrate Repository as well as Domain DB
No need / use in giving advice for questions which may not have been asked at all.
We should first have asked which repositories we're talking about, if it's PowerCenter repositories, Model repositories, or the domain repository. Everything else depends on this answer.
I would also like to understand why are you changing the domain database to point to UAT from PROD ? Does both the database schema have same contents in them?
Were there any changes done at the server level as well?
Are the services running in different domains?
I assume so since you are mentioning a sitekey issue.
If I remember well you need to perform an upgrade of the repository when running it under a different Informatica domain. You can do this by copying the sitekey file from the previous domain and renaming it to sitekey_old.
The sitekey_old file must be copied to the same location as the sitekey file in the new domain and in the Admin console you need to perform an upgrade of the repository when this is in place.
Please also check documentation on this in the KB.
Its better not to suggest anything related to sitekey now. First lets understand what they want to do and the suggest next steps.