Informatica Power Center : Update Master DB refresh interval

Master DB refresh interval can be updated using the update domain options. The refresh interval typically updated to avoid frequent shutdown due to following error.

Error

FATAL [Domain Monitor] [DOM_10094] Cannot update the data for the master gateway node [node01_bi] within the refresh interval time [96000]. The node will not continue as a master gateway node. Verify that the connection to the domain configuration repository database is valid.

Master DB refresh interval

Use following command to update the refresh interval.

$INFA_HOME/isp/bin/infacmd.sh  UpdateDomainOptions -dn DomainName -un Administrator -pd password -do MasterDBRefreshInterval=n

** n is in seconds

Example :

To update from default 96 seconds to 120 seconds

$INFA_HOME/isp/bin/infacmd.sh UpdateDomainOptions -dn DOM_INFA_PROD -un Administrator -pd ********** -do MasterDBRefreshInterval=120

UpdateDomainOptions - Properties

Here are some of the other properties those can be updated with "UpdateDomainOptions".

• LicenseUsageDetailMinDays - Licence usage events logging Minimum number of days.
• LicenseUsageSummaryMinDays - Licence usage database records Minimum number of days.
• ResilTimeout - Amount of time in seconds services attempt to connect as clients to other services.
• RestartsMaxAttempts - Number of times the domain attempts to restart an application service process.
• RestartsWithinSeconds -  Maximum period of time in seconds that the domain spends attempting to restart an application service process.
• ServiceResilTimeout - Amount of time in seconds that a service tries to reestablish a connection to another service.
• TaskDispatchMode - Load Balancer dispatch mode for tasks.
• TLSMode - Configures secure communication between services within the domain.