Using the Gateway Server Status data mart

Use the Gateway Server Status data mart to view the status data of the dataflow from Continuous Optimization agents. This data mart is available after you install it as an add-on package. After installation, the data mart is available in the Administration > Data Marts section. The data mart is automatically materialized. The data is extracted daily into the bcoee_data_visibility database table by using the Gateway Server Administration Helper system task. This table stores the last 30 days of status data.

Before this feature was introduced, the Gateway server status information was available by using the limited Self Monitoring - Gateway Data Feed Health Report BIRT report. With this data mart you can create a custom view or even combine this data with other data marts, like, SQL-based data mart or the Summary data mart.

Related topics

Managing-data-marts-for-custom-views

Adding-and-managing-views

The following data is available through the Gateway Server Status report data mart:

Column name

Description

Dayts

The time stamp of when data was collected.

Sysid

The system ID (if available).

Sysname

The system name in BMC Helix Continuous Optimization (if available).

Taskid

The task ID of the ETL (if available).

Systypeid

The system type ID.

Systypename

The system type name.

Bpasysname

The name of the system.

Bpamanagerrun

The manager run that is processing this system.

Bpanodelist

The domain or policy list that contains this system.

Failurecomponentid

The stage that was last processed.

In case of an error: 

  • 0 – Collect (data collected on the system)
  • 1 – Transfer (data coming back to the gateway server)
  • 2 – Processing (data being fed into the BMC - TrueSight Capacity Optimization Gateway VIS file parser ETL by the gateway server)
  • 3 – System imported through ETL
  • 4 – Success (if the processing was successful)

Failuremessage

Failure message.

Failureid

The ID of the failure.

Udrrepository

UDR repository where data is stored.

Os

The operating system type.

Os_version

The operating system version.

Agent_version

The version of the agent.

Gateway_server

The gateway server that is processing this system.

Agent_list_name

The agent list (manager run simplified name).


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*