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
- Open the Settings Panel and enter your database credentials. (Don't forget to activate the choosen settings.)
- Enable System Integrity checking for RDB Archiving and LHCLoggingDB to receive alarms, if problems occur.
- Authenticate as a LHCLoggingDB Expert via the Authentication Panel.
- Verify that your config files do not contain any errors by using the dedicated button in the Import Panel.
- 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.
- 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 |
In section "Database" the user can choose the database and the schema for which he wants to show the registered elements.
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.
|
| 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 |
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.
|
|||
| Restrictions | - |
|||
| Dollar Parameters |
|
| Panel Name | refUnLHCLoggingDBJobMonitor.pnl |
||||||
|---|---|---|---|---|---|---|---|
| Purpose |
The job monitor panel provides detail information about all RDB transfer jobs of a database. |
||||||
| Instructions |
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 |
|
| Panel Name | refUnLHCLoggingDBElementHistory.pnl |
|||
|---|---|---|---|---|
| Purpose |
The element history panel provides information about data transfer to RDB Archive for a specified logging variable. |
|||
| Instructions |
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 |
|
| 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 |
|
|||
| Restrictions | - |
|||
| Dollar Parameters |
|
| Panel Name | unLHCLoggingDBSettings.pnl |
|---|---|
| Purpose |
Reference panel which is used to show temporal load changes of a specific transfer job within a chart. |
| Instructions |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
- |