Database calls, routines, test programs

Views for each of the experiments have been created.

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!