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;

Then

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>
SQL> SPOOL OFF

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
    service:peer:http
    service:endpoint:i2o.loopback
    
  3. find the servers providing the sevice
    [thea@vmepcS2F19-01 ~]$ slptool findsrvs service:peer:http | grep -r ecalod
    service:peer:http://ecalod-s2d07d.cms:29010/urn:xdaq-application:lid=21,62835
    service:peer:http://ecalod-s2d06d.cms:29010/urn:xdaq-application:lid=21,62835
    service:peer:http://ecalod-s2d02d.cms:29013/urn:xdaq-application:lid=21,62835
    service:peer:http://ecalod-s2d02l.cms:29013/urn:xdaq-application:lid=21,62835
    service:peer:http://ecalod-s2d07l.cms:29011/urn:xdaq-application:lid=21,62835
    service:peer:http://ecalod-s2d04d.cms:29012/urn:xdaq-application:lid=21,62835
    service:peer:http://ecalod-s2d04l.cms:29011/urn:xdaq-application:lid=21,62835
    service:peer:http://ecalod-s2d03h.cms:29011/urn:xdaq-application:lid=21,62835
    
  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
    (class=ws::service::Eventing),(className=ws::service::Eventing),(context=http://srv-s2f19-28.cms:9988),(group=ecal-monitor),(hasInstance=false),(icon=/ws/service/images/Eventing.png),(icon16x16=/ws/service/images/WSEventing_16x16.png),(id=400),(instance=0),(network=local),(publish=true),(service=ws-eventing),(uuid=6938810e-a10b-43a3-90ca-388985847d37),(zone=ecal),(domain=xdaq)
    
  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 >

example:

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