V_L3_PC
V_ALEPH_PC
V_OPAL_PC
V_DELPHI_PC
A view on the general power converters has be created. V_GENERAL_PC
The following call returns the current in all of the power converters of interest to L3.
Typical call:
select lx_name, to_char(timestamp,'DD-MON-YY HH24:MI:SS'), status,value,deviation,err_msg from v_l3_pc order by lx_name;
Example PRO*C Program to access the power converters of interest to L3
Test program which calls the above routine
Note: all the power converters in LEP are read and the measurement database updated every two minutes. The alert monitor watches the tables and updates m_timestamp_table as appropriate.
The values on the control database are updated slightly before any changes are made (0.5 s typically). We will trigger an update from the control database to a table on the measurement database if required. (An alert on this table would give almost instaneous notification of any changes.) POLLING OF THE CONTROL DATABASE IS DISCOURAGED!