SQL Procedures

select * from active_tt_dat 
where tt_id in (70) 
and FED_ID between 601 
and 609 and status=1;

// set all the mem channels to 0
 update active_tt_dat set status=0 where tt_id in (69,70); 

// set EE- 601,602,605,606 mem channels to 1
 update active_tt_dat set status=1 where tt_id in (69,70) and fed_id in (601,602,605,606) 

// set EE+ 646,647,650,651 mem channels to 1
 update active_tt_dat set status=1 where tt_id in (69,70) and fed_id in (646,647,650,651);

// set EB meme channesl to 1
 update active_tt_dat set status=1 where tt_id in (69,70) and fed_id between 610 and 645;

Query the last active BAD_TT table

select config_id,btt_id,db_timestamp,tag from FE_DAQ_CONFIG order by db_timestamp;


select fed_id,tt_id from bad_tt_dat where rec_id=<last record from the previous query>;

Query result to file

SQL> SPOOL <filename>
SQL> <the query>

Slptool usage

Helpful to understand whether the autodiscovery is working, if the monitoring goes nuts

  1. check the directory agent to be available
    slptool findsrvs service:directory-agent
  2. discover the available services
    [thea@vmepcS2F19-01 ~]$ slptool findsrvtypes
  3. find the servers providing the sevice
    [thea@vmepcS2F19-01 ~]$ slptool findsrvs service:peer:http | grep -r ecalod
  4. find the attributes of the server
    [thea@vmepcS2F19-01 ~]$ slptool findattrs service:peer:http://srv-s2f19-28.cms:9988/urn:xdaq-application:lid=400
  5. try to restart the slp daemon
    [thea@srv-S2F19-28 init.d]$ sudo ./slp restart
    Shutting down slp:                                         [  OK  ]
    Starting slp:                                              [  OK  ]

Dynamic Trigger TT masking

  1. as ecaldev
  2. EBTCCmasks.sh < Geo > < TT >


EBTCCmasks.sh EB+2 66

SLB cmdline monitor

Command line monitor for the slbs
monitorSLBs.sh --help
  <fed id, partition or rack> [<crate> [slot] ]
 slot  - slot number 1-21
 rack  - rack number: 02,03,04,05,06,07,08
 crate - crate position: l (upper), h (medium), d (low)
 partition - EE, EB, EEp, EEm, etc.(not case sensitive, DON'T use + or -)

-- AlessandroThea - 11-Nov-2009

Edit | Attach | Watch | Print version | History: r6 < r5 < r4 < r3 < r2 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r6 - 2010-02-17 - AlessandroThea
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Main All webs login

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