r4 - 11 Jun 2007 - 12:00:24 - Main.dauria You are here: TWiki > Atlas Web > AtlasComputing > DataBases > ConditionsDB > IdDcsMonitoring

IdDcsMonitoring

Introduction

This page lists and describes some tools that are being developed for monitoring the Atlas Inner Detector from the data written to the database (SCT and ID projects). It also includes a list of requests, that will be implemented.

This monitoring is taking place "downstream" of the primary on-line monitoring provided by the PVSS projects. It relies on the data written by the PVSS projects to the on-line database, which will most likely be replicated also to the off-line data base.

What these tools are:

primarily a diagnostic tool, i.e. a method to access the DCS data within a user defined time range (of the order of hours or days) and either display and save to an ascii file the corresponding data, if the precise list of 'datapoints' is known, or interrogate the database for a list of data points that meet the specified requirements (e.g. temperature larger than X,current lower than Y etc..)

What these tools are not:

  • A strictly on-line tool to display teh detector present status
  • A strictly off-line tool to correlate with DAQ quantities like noise in modules.

Disclaimer:

As the on-line Data Base (Oracle) is being tested and configured at the same time as the tools to access it, the direct data base access is presently limited to authenticated users, operating from the cern lxplus cluster. This restriction will be lifted in the future.

The structure of data, aliases and Oracle schema is being tested and is evolving at the same time, and various versions of data structure are to be accessed.

Available tools

They can be divided in 3 categories: (a) command-line scripts, (b) window browser, (3) chron-jobs. The command-line scripts exist presently in different flavours, specific for each task. We are integrating them into a window-based navigation tool.

SCT specific scripts

  • textdump ./textdump_v5.1.pl --help can be downloaded from this link textdump.pl This script has a twofold function: a) plot the time history of a given data point within a given time interval. b) look for the data points which have a value that is larger or smaller than a given threshold within a given time interval. It accesses the SCT module data point in hardware or logical view.
    Instructions: Usage type 1: for plotting DCS data and printing values and time stamps to ascii files For <query type> = 'plot' (a) or 'aliasplot' (b)
    Syntax:
    a) textdump_v5.1.pl <query type> <crate> <channel> <element> <start date> <start time> <stop date> <stop time>
    b) textdump_v5.1.pl <query type> <barrel> <row> <module> <element> <start date> <start time> <stop date> <stop time>

Examples: ./textdump_v5.1.pl plot 84 21 Tm0 14-02-2007 15:00 14-02-2007 17:20
./textdump_v5.1.pl aliasplot 03 24 03 Tm0 13-05-2007 08:00 13-05-2007 09:00
./textdump_v5.1.pl aliasplot 03 24 -3 Tm0 13-05-2007 08:00 13-05-2007 09:00

Available Power Supply Data point elements:
HVchStat LVchStat LV or HV State
LVchVCSI LVchVCSV LVchPINV LVchPINI Optolink
MOch MOch_Tm0 MOch_Tm1 Tm0 Tm1 Module Temperatures
LVretVdd LVretVcc LVch_Idd LVch_Icc LVps_Vdd LVps_Vcc Low Voltages
HVchVolt HVchCurr High Voltage
Status CC status
A gnuplot window will pop up on your screen.
The results are stored in the ASCII file 'query_result.txt', for human reading
Some additional ascii files are written, in the format <value> <time from start time>
one file per selected element (e.g. one for TM0 and one for TM1)
These files are called 'plot_db_X.dat' with X from 1 to n_elements.
Other files 'second_plot_db_X.dat' are generated for plotting purposes only.

Usage type 2: for 'relational queries' like: 'All elements within time interval with bias V larger than 10 Volts' set <query type> = 'rel'
Syntax:
./textdump_v5.1.pl <query type> <operator> <value> <element> <start date> <start time> <stop date> <stop time>
Example: ./textdump.pl rel GT 10 HVchVolt 14-02-2007 15:00 14-02-2007 17:20

The allowed Logical operators are: LT for < ; LE for <= ; GT for > ; GE for >=
The results are stored in the ASCII file query_result.txt for human reading

SCT and ID combined

  • cooloop.pl cooloop.pl This script returns a plot with the temperatures as a function of time for all the sensorsin the specified cooling loop. It takes data from 3 projects.
  • ID DCS browser (Luca)
    Navigation panel
    lucaspanel.gif

Adiministrative tools

  • an in-line command produces a report on the amount of data written daily to Oracle database for a given subsystem (SCT or ID):

Data Flow to Oracle Data Base during P1 barrel test May 2007:
DataFlow_barreltest_01to14May07.gif

* an in-line command produces a report on the amount of data written daily by the indivdual data point elements

Chron-jobs

  • a chron job is run daily to check for high temperature spikes and HV trips on SCT data. It presently sends e-mail to SCT commissioning

Link to presentations


Major updates:
-- Main.dauria - 08 Jun 2007

Responsible: Main.dauria
Last reviewed by: Never reviewed

Show attachments (2) Hide attachments (2)
IAttachmentActionSizeDateWhoCommentgifgif DataFlow_barreltest_01to14May07.gifmanage 71.8 K 11 Jun 2007 - 11:45 Main.dauria Data Flow to Oracle Data Base during P1 barrel test May 2007 gifgif lucaspanel.gifmanage 304.8 K 11 Jun 2007 - 11:50 Main.dauria Navigation panel for the ID SCT combined tool
Topic attachments
| Powered by TWiki |

|
This site is powered by the TWiki collaboration platformCopyright & by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback
Topic attachments
I Attachment History Action Size Date Who Comment
GIFgif DataFlow_barreltest_01to14May07.gif r2 r1 manage 71.8 K 2007-06-11 - 11:45 UnknownUser Data Flow to Oracle Data Base during P1 barrel test May 2007
GIFgif lucaspanel.gif r1 manage 304.8 K 2007-06-11 - 11:50 UnknownUser Navigation panel for the ID SCT combined tool
Edit | Attach | Watch | Print version | History: r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r1 - 2007-07-20 - StephenHaywood
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Atlas All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback