UNICOS LHC Logging DB Component Help



Introduction

The UNICOS LHCLoggingDB component is a tool to configure and monitor data transfer between Oracle RDB-Archive and the LHC-Logging database (LDB).
Data transfer is being performed by several transfer jobs which are controlled by a data transfer manager (running directly on the database).

The component can only be used in combination with RDB-Archiving. That means RDB-Archiving must be configured and running on this system.

To provide backward compatibiliy to the old LHCLogging component, already existing configuration files can be used to configure LHCLoggingDB


How to start

Before starting to configure LHCLoggingDB make sure that RDB Archiving is properly setup and running.

Configuration

  1. Open the Settings Panel and enter your database credentials. (Don't forget to activate the choosen settings.)
  2. Enable System Integrity checking for RDB Archiving and LHCLoggingDB to receive alarms, if problems occur.
  3. Authenticate as a LHCLoggingDB Expert via the Authentication Panel.
  4. Verify that your config files do not contain any errors by using the dedicated button in the Import Panel.
  5. Choose an appropriate data category for your import data. If there is no data category for your project, contact the LHCLoggingDB administrator to create one.
  6. Register your config file for logging using the append button in the Import Panel. This process can take a couple of minutes and may block your UI.

Advanced configuration scenarios:

  • To modify an existing logging configuration just edit the config files and re-import them.
  • For device renaming to spare (changing of an alias) re-import the config files to update the logging configuration.
  • To add new datapoints to an existing logging configuration, import the new configuration data as a seperate config file.
    If the new data is being added to an existing config file, the existing configuration will also be updated during re-import.
  • To remove parts of an existing logging configuration, first delete the logging configuration using the Delete Panel, afterwards the modified config files can be re-imported.

Diagnostics

In this section we show how to debug the component.


Panels

Panel Name

unLHCLoggingDBMain.pnl

Purpose

The main diagnostics panel of the LHCLoggingDB component shows all registered logging variables in a table and provides additional information for each variable.

Instructions Main Diagnostics Panel

In section "Database" the user can choose the database and the schema for which he wants to show the registered elements.
By clicking on "Select my system" the database schema of the current PVSS project will be selected.

In the section "Filter" the user can enter search strings to only show specific elements of the output list.

In the status table all registered elements are shown.
A double click on a specific line opens the transfer history panel for the chosen variable.
A right click allows to open other diagnostic panels and to show even more detailed information.

Restrictions

-

Dollar Parameters

-



Panel Name

refUnLHCLoggingDBTransferHistory.pnl

Purpose

The transfer history panel provides historical detail information about the data transfer to the logging database (LDB) for a specific logging variable.

Instructions Transfer History Panel

Section "Details" provides detail information about the desired logging variable.

The transfer history table shows all transferred chunks from MDB do LDB within a certain time-range specified by the Filter.
It also provides detail information about the amount of data being transferred.

Restrictions

-

Dollar Parameters
$VARIABLE_IDThe id of the desired logging variable.Required


Panel Name

refUnLHCLoggingDBJobMonitor.pnl

Purpose

The job monitor panel provides detail information about all RDB transfer jobs of a database.

Instructions Transfer Job Monitor Panel

The transfer job table contains a list of all active transfer jobs and provides additional information about the current load situation.

When selecting a transfer job session information will be shown below and the load trend diagram will be updated

Restrictions

-

Dollar Parameters
$RDB_SOURCEShow only transfer jobs which are dedicated to this $RDB_SOURCE.Optional
$TRANSFER_GROUPPreselect transfer job with this $TRANSFER_GROUP.Optional


Panel Name

refUnLHCLoggingDBElementHistory.pnl

Purpose

The element history panel provides information about data transfer to RDB Archive for a specified logging variable.

Instructions Element History Panel

The local history table shows all values that have been transferred to RDB Archive within the time period specified in the filter.

Restrictions

-

Dollar Parameters
$VARIABLE_IDThe id of the desired logging variable.Required


Panel Name

refUnLHCLoggingDBAuthentication.pnl

Purpose

Popup panel which is used to authenticate as a LHC Logging DB expert or admin in order to be allowed change the LHC Logging DB registration.

Instructions Authentication Panel
Restrictions

-

Dollar Parameters
$USERForce login with this USERNAME.Optional


Panel Name

unLHCLoggingDBSettings.pnl

Purpose

Reference panel which is used to show temporal load changes of a specific transfer job within a chart.

Instructions Element History Panel

The local history table shows all values that have been transferred to RDB Archive within the time period specified in the filter.

Restrictions

This panel is used as a child panel of the configuration panel

Dollar Parameters

-



Panel Name

unLHCLoggingDBImport.pnl

Purpose

Reference panel which is used to show temporal load changes of a specific transfer job within a chart.

Instructions Element History Panel

The local history table shows all values that have been transferred to RDB Archive within the time period specified in the filter.

Restrictions

This panel is used as a child panel of the configuration panel

Dollar Parameters

-



Panel Name

unLHCLoggingDBDelete.pnl

Purpose

Reference panel which is used to show temporal load changes of a specific transfer job within a chart.

Instructions Element History Panel

The local history table shows all values that have been transferred to RDB Archive within the time period specified in the filter.

Restrictions

This panel is used as a child panel of the configuration panel

Dollar Parameters

-



Panel Name

unLHCLoggingDBDataCateg.pnl

Purpose

Reference panel which is used to show temporal load changes of a specific transfer job within a chart.

Instructions Element History Panel

The local history table shows all values that have been transferred to RDB Archive within the time period specified in the filter.

Restrictions

This panel is used as a child panel of the configuration panel

Dollar Parameters

-



Panel Name

systemIntegrity_LHCLoggingDB_configuration.pnl

Purpose

Reference panel which is used to show temporal load changes of a specific transfer job within a chart.

Instructions Element History Panel

The local history table shows all values that have been transferred to RDB Archive within the time period specified in the filter.

Restrictions

This panel is used as a child panel of the configuration panel

Dollar Parameters

-



Panel Name

systemIntegrity_LHCLoggingDB_operation.pnl

Purpose

Reference panel which is used to show temporal load changes of a specific transfer job within a chart.

Instructions Element History Panel

The local history table shows all values that have been transferred to RDB Archive within the time period specified in the filter.

Restrictions

This panel is used as a child panel of the configuration panel

Dollar Parameters

-



Panel Name

systemIntegrity_LHCLoggingDB_DataConsistency.pnl

Purpose

Reference panel which is used to show temporal load changes of a specific transfer job within a chart.

Instructions Element History Panel

The local history table shows all values that have been transferred to RDB Archive within the time period specified in the filter.

Restrictions

This panel is used as a child panel of the configuration panel

Dollar Parameters

-

© CERN 2014 | Web:UNICOS | Mail:icecontrols.support@cern.ch