Configuring schemas and gateway settings for a multitiered architecture

On a multitiered hybrid deployment, you must update the display layer ObjectServer schema and the aggregation to display gateway to enable the cloud native components at the display layer.

Procedure

Update the display ObjectServer schema

  • To update the display ObjectServer schema, complete the following steps.
    1. Copy the cea_display_schema.sql file from the noi-ea-noi-layer-eanoiactionservice pod, by running the following command:
      oc cp <ea-noi-layer-eanoiactionservice_pod_name>:/app/ea-noiomnibus-config/objectserver/cea_display_schema.sql cea_display_schema.sql
      Where <ea-noi-layer-eanoiactionservice_pod_name> is the name of your noi-ea-noi-layer-eanoiactionservice pod.
    2. Copy the cea_display_schema.sql file to the host where the display layer ObjectSever is running.
    3. Apply the cea_display_schema.sql file to each display layer ObjectServer, by running the following command:
      cd /opt/IBM/tivoli/netcool/omnibus/bin
      ./nco_sql -server DIS_1 -user root -password <ObjectServer_root_password> < ~/cea_display_schema.sql

Update the aggregation to display gateway (A_TO_D_GATE.map) map

  • On the host where the display layer A_TO_D_GATE ObjectServer gateway is running, log in and update the StatusMap schema in the $OMNIHOME/etc/A_TO_D_GATE.map file with the following content:
    ###############################################################################
    #
    # CEA Cloud Event Analytics
    #
    ###############################################################################
    'AsmStatusId' = '@AsmStatusId',
    'LastOccurrenceUSec' = '@LastOccurrenceUSec',
    'CEAAsmStatusDetails' = '@CEAAsmStatusDetails',
    'CEACorrelationKey' = '@CEACorrelationKey',
    'CEACorrelationDetails' = '@CEACorrelationDetails',
    'CEAIsSeasonal' = '@CEAIsSeasonal',
    'CEASeasonalDetails' = '@CEASeasonalDetails',
    'ParentIdentifier' = '@ParentIdentifier',

Update the JDBC gateway map

  • On the host where the display layer JDBC_GATE ObjectServer gateway is running, log in and update the reporter DB schema in the $OMNIHOME/etc/JDBC_GATE.map file. Add the following content to the StatusMap table in the $OMNIHOME/etc/JDBC_GATE.map file:
    ###############################################################################
    #
    # CEA Cloud Event Analytics
    #
    ###############################################################################
    'AsmStatusId' = '@AsmStatusId',
    'LastOccurrenceUSec' = '@LastOccurrenceUSec',
    'CEAAsmStatusDetails' = '@CEAAsmStatusDetails',
    'CEACorrelationKey' = '@CEACorrelationKey',
    'CEACorrelationDetails' = '@CEACorrelationDetails',
    'CEAIsSeasonal' = '@CEAIsSeasonal',
    'CEASeasonalDetails' = '@CEASeasonalDetails',
    'ParentIdentifier' = '@ParentIdentifier',