Informatica help

Informatica help and metadata report query

Update DB node for failover

Update DB node for fail-over

This page will guide you step by step how to update the data base host name of a Power-center 9.x for Fail-over

STEP 1: Shut down the node that you want to modify.

STEP 2: Run one of the the following commands to update the host name:

Note: Update the parameters in between the <>. All other entries must remain the same.
$INFA_HOME/isp/bin/infasetup.sh UpdateGatewayNode -cs “jdbc:informatica:oracle://<DB vip alias name>:<DB port>;ServiceName= <Service name>;AlternateServers = (<Second DB vip alias name>:<Second DB port>); Load Balancing=true” -du <Domain User> -dp <Domain Password> -dt oracle -dn <Domain Name> -rst

STEP 3: Start up your node.

ALL DONE.

Some additional information.

  • To change the hostname for other nodes, follow the same command according to gateway node or worker node.
  • There is no need to take a backup of domain metadata and change the hostname there.
  • Once the infasetup.sh UpdateGatewayNode is run, the hostname changes in the nodemeta.xml and when PowerCenter domain is started, it synchronizes the new host to the domain database. Thus, the hostname in the database will automatically change to the new one.
  • Configuration on PowerCenter Client can be updated with Domain Configuration through the PowerCenter Repository Manager > File menu.

Leave a Reply

Your email address will not be published.Email address is required.

Sponsored Content


Canon EOS 5D Mark IV Full Frame Digital SLR Camera Body


Canon EF 24-70mm f/2.8L II USM Standard Zoom Lens

GoPro HERO5 Black

Canon EF 100-400mm f/4.5-5.6L IS II USM Lens

Firefield FF16001 NVRS 3x 42mm Gen 1 Night Vision Riflescope, Black

Visitors


Quantcast