Update gateway settings

To enable bi-directional data replication, you must update your on-premises ObjectServer gateway settings with cloud native analytics component mappings.

1. On the server where you installed the on-premises aggregation gateway, edit the $NCHOME/omnibus/etc/AGG_GATE.map on-premises gateway map definition file. Append the following lines to the CREATE MAPPING StatusMap entry:

   ###############################################################################
   #
   # CEA Cloud Event Analytics
   #
   ###############################################################################
   'AsmStatusId' = '@AsmStatusId',
   'LastOccurrenceUSec' = '@LastOccurrenceUSec',
   'CEAAsmStatusDetails' = '@CEAAsmStatusDetails',
   'CEACorrelationKey' = '@CEACorrelationKey',
   'CEACorrelationDetails' = '@CEACorrelationDetails',
   'CEAIsSeasonal' = '@CEAIsSeasonal',
   'CEASeasonalDetails' = '@CEASeasonalDetails',

2. On the server where you installed the on-premises aggregation server, edit the $NCHOME/omnibus/etc/AGG_GATE.map on-premises gateway map definition file. Append the following new mapping entries to the file:

   ###############################################################################
   #
   # CEA Cloud Event Analytics Mapping
   #
   ###############################################################################
   CREATE MAPPING CEAProperties
   (
   'Name' = '@Name' ON INSERT ONLY,
   'CharValue' = '@CharValue',
   'IntValue' = '@IntValue'
   );
   
   CREATE MAPPING CEASiteName
   (
   'SiteName' = '@SiteName' ON INSERT ONLY,
   'CEACorrelationKey' = '@CEACorrelationKey' ON INSERT ONLY,
   'Identifier' = '@Identifier',
   'CustomText' = '@CustomText',
   'CustomTimestamp' = '@CustomTimestamp',
   'CustomWeight' = '@CustomWeight',
   'HighImpactWeight' = '@HighImpactWeight',
   'HighImpactText' = '@HighImpactText',
   'HighCauseWeight' = '@HighCauseWeight',
   'HighCauseText' = '@HighCauseText'
   );
   
   CREATE MAPPING CEACKey
   (
   'CEACorrelationKey' = '@CEACorrelationKey' ON INSERT ONLY,
   'LastOccurrence' = '@LastOccurrence',
   'Identifier' = '@Identifier',
   'ExpireTime' = '@ExpireTime',
   'CustomText' = '@CustomText',
   'CustomTimestamp' = '@CustomTimestamp',
   'CustomWeight' = '@CustomWeight',
   'HighImpactWeight' = '@HighImpactWeight',
   'HighImpactText' = '@HighImpactText',
   'HighCauseWeight' = '@HighCauseWeight',
   'HighCauseText' = '@HighCauseText'
   );
   
   CREATE MAPPING CEACKeyAliasMembers
   (
   'CEACorrelationKey' = '@CEACorrelationKey' ON INSERT ONLY,
   'CorrelationKeyAlias' = '@CorrelationKeyAlias'
   );
   
   CREATE MAPPING CEAPriorityChildren
   (
   'Identifier' = '@Identifier' ON INSERT ONLY,
   'CustomText' = '@CustomText',
   'CustomTimestamp' = '@CustomTimestamp',
   'CustomWeight' = '@CustomWeight',
   'HighImpactWeight' = '@HighImpactWeight',
   'HighImpactText' = '@HighImpactText',
   'HighCauseWeight' = '@HighCauseWeight',
   'HighCauseText' = '@HighCauseText'
   );

3. On the server where you installed the on-premises aggregation server, edit the $NCHOME/omnibus/etc/AGG_GATE.tblrep.def gateway table replication definition file. Append the following replication statements to the file:

   ###############################################################################
   #
   # # CEA Cloud Event Analytics Replication Definition
   #
   ###############################################################################
   REPLICATE ALL FROM TABLE 'master.cea_properties'
   USING map 'CEAProperties';
   
   REPLICATE ALL FROM TABLE 'master.cea_sitename'
   USING map 'CEASiteName';
   
   REPLICATE ALL FROM TABLE 'master.cea_ckey'
   USING map 'CEACKey';
   
   REPLICATE ALL FROM TABLE 'master.cea_ckey_alias_members'
   USING map 'CEACKeyAliasMembers';
   
   REPLICATE ALL FROM TABLE 'master.cea_priority_children'
   USING map 'CEAPriorityChildren';

4. Restart the aggregation gateway for the changes to take effect.
   1. Stop the gateway with the following command.

      kill -9 $(ps -ef | grep nco_g_objserv_bi | grep .props | awk -F ' ' {'print $2'})

   2. Start the gateway with the following command.

      $NCHOME/omnibus/bin/nco_g_objserv_bi -propsfile $NCHOME/omnibus/etc/AGG_GATE.props &

      For more information, see Running gateways in the IBM Tivoli® Netcool/OMNIbus documentation.