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

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

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