Thank you @CliffCahill for providing this trick!
Ensure to back up the UIM/P(Unified Infrastructure Manager for Provisioning) DB before you begin. The following provides detailed steps on how to modify IP settings for ESXi host service offerings stored in the UIM DB.
Login to the UIM CLI via putty.
#To login to uim voyencedb database:
su – pgdba
psql voyencedb uim
To pull back all ESXi O/S settings:
select *, from ossettings;
To update the gateway for all service offerings / ESXi host:
update ossettings set gateway = ‘10.10.1.254’;
To update the IP address on individual ESXi host – id is listed when you run “select” command:
update ossettings set ip_address = ‘10.10.1.10’ where id = 2338;
update ossettings set ip_address = ‘10.10.1.11’ where id = 2302;