Tool to access the PVSS database and write out some monitoring information. This tool is based on and inspired by a couple of other tools:

• PVSS2COOL Monitoring (CoolDCSAna)
• dumpDCS

What this tool should be able to do

• access PVSS Oracle DB
  • output database content - works
  • dump database content to root/text file
  • count entries, display highest rate entries - works

• access COOL root file dumped with AtlCoolCopy

• compare COOL and PVSS entries

  • read Coral Connectivity database for COOL<->PVSS comparison

• configurable via text file and command line

Contents of CoolDCSAna

Only listing the contents of COOLANA/PIXEL/DCS, they all have the same seven histograms:

• FSMSTATE
  • IOVSperChannel
  • IOVLogLength
  • IOVLogGapLength
  • IOVAlignLogDelT
  • AlignedChanPerIOV

  • ChannelOcc

  • IOVLenChan
• FSMSTATUS
• HV
• TEMPERATURE
• SEP08/HV
• DEC08/FSMSTATE, DEC08/FSMSTATUS, DEC08/HV, DEC08/TEMPERATURE

SQL Documentation and HowTos

• http://www.w3schools.com/sql/default.asp

• http://sqlzoo.net/

• http://www.techonthenet.com/oracle/index.php

• OCCI documentation: http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28390/toc.htm

• CERN DB Access advice: https://twiki.cern.ch/twiki/bin/view/PDBService/GeneralAdvices and https://twiki.cern.ch/twiki/bin/view/PDBService/ReferenceSlideshow

General CERN things on databases

• https://twiki.cern.ch/twiki/bin/view/Atlas/DataBases

• https://twiki.cern.ch/twiki/bin/view/Atlas/DBProjectUtilities (General utilities, especially Python tools, e.g. PyOracle)

• Do I need CoraCool? (http://atlas-sw.cern.ch/cgi-bin/viewcvs-atlas.cgi/offline/Database/CoraCool/doc/mainpage.h?revision=1.3&view=markup)

• IOVDbSvc? (http://atlas-computing.web.cern.ch/atlas-computing/links/nightlyDevDirectory/AtlasOffline/latest_doxygen/InstallArea/doc//IOVDbSvc/html/index.html)

• SQL Scripts: https://twiki.cern.ch/twiki/bin/view/Atlas/ScriptsDepotContent

• ATLAS DCS DB: https://twiki.cern.ch/twiki/bin/view/Atlas/DcsDb

• CERN Physics Databases Services: http://phydb.web.cern.ch/phydb/

Structure of PVSS database

• https://twiki.cern.ch/twiki/bin/view/Atlas/PixelDCSCondDB (Schemata and types of data)

• https://twiki.cern.ch/twiki/bin/view/Atlas/PixelDCSArchiving (Archiving rates)

• How to access Oracle DB: https://twiki.cern.ch/twiki/bin/view/Atlas/PixelDBOracleHowTo

Looking at the Database using GUI

Use this tool: http://pdv-download.web.cern.ch/pdv-download/

For more documentation see ClemensLange/PixelDCS/Documentation

Setting up Oracle environment

Documentation from: https://twiki.cern.ch/twiki/bin/view/PDBService/BasicConceptsReference

source /afs/cern.ch/project/oracle/script/setoraenv.sh

Libraries to include: http://oracle-documentation.web.cern.ch/oracle-documentation/10gr2doc/install.102/b15662/post_inst_task.htm#sthref388

Somehow like this:

$ORACLE_HOME/lib/libocci10.a
$ORACLE_HOME/lib/libocci10.so.10.1

Compilation commands

Example command (running commands given here: http://www.lorentzcenter.nl/awcourse/oracle/appdev.920/a96583/cciaadem.htm):

/usr/bin/g++ -c -I/afs/cern.ch/project/oracle/@sys/10203/rdbms/demo -I/afs/cern.ch/project/oracle/@sys/10203/rdbms/public -I/afs/cern.ch/project/oracle/@sys/10203/plsql/public -I/afs/cern.ch/project/oracle/@sys/10203/network/public occiblob.cpp -DLINUX -DORAX86_64 -D_GNU_SOURCE -D_LARGEFILE64_SOURCE=1 -D_LARGEFILE_SOURCE=1 -DSLTS_ENABLE -DSLMXMX_ENABLE -D_REENTRANT -DNS_THREADS -DLONG_IS_64 -fno-strict-aliasing -DSS_64BIT_SERVER

/usr/bin/g++ -L/afs/cern.ch/project/oracle/@sys/10203/lib/ -L/afs/cern.ch/project/oracle/@sys/10203/rdbms/lib/ -o occiblob occiblob.o -locci -lclntsh   `cat /afs/cern.ch/project/oracle/@sys/10203/lib/sysliblist` -ldl -lm  -lpthread

My command:

g++ -c -pthread -m64 -I/afs/cern.ch/sw/lcg/external/root/5.20.00/slc4_amd64_gcc34/root/include -DLINUX -DORAX86_64 -D_GNU_SOURCE -D_LARGEFILE64_SOURCE=1 -D_LARGEFILE_SOURCE=1 -DSLTS_ENABLE -DSLMXMX_ENABLE-D_REENTRANT -DNS_THREADS -DLONG_IS_64 -fno-strict-aliasing -DSS_64BIT_SERVER  -I. -I/afs/cern.ch/project/oracle/@sys/10203/rdbms/demo -I/afs/cern.ch/project/oracle/@sys/10203/rdbms/public/ -I/afs/cern.ch/project/oracle/@sys/10203/plsql/public -I/afs/cern.ch/project/oracle/@sys/10203/network/public  -c testOracle.cxx -o testOracle.o

g++ -L /afs/cern.ch/sw/lcg/external/root/5.20.00/slc4_amd64_gcc34/root/lib -lCore -lCint -lHist -lMatrix -lGpad -ldl -lGraf -lTree -lSQL -L/afs/cern.ch/project/oracle/@sys/10203/lib -L/afs/cern.ch/project/oracle/@sys/10203/rdbms/lib  -Locci testOracle.o -o testOracle -locci -lclntsh   `cat /afs/cern.ch/project/oracle/@sys/10203/lib/sysliblist` -ldl -lm -lpthread

Makefile

ROOTCFLAGS = $(shell root-config --cflags)
ROOTLIBS = -L $(ROOTSYS)/lib -lCore -lCint -lHist -lMatrix -lGpad -ldl -lGraf -lTree -lSQL
ROOTCINT = $(ROOTSYS)/bin/rootcint

CXX = g++
CPPFLAGS = $(ROOTCFLAGS)
LD = g++
LDFLAGS = $(ROOTLIBS)

# ORACLE = -L$(ORACLE_HOME)
# ORACLE = -L$(ORACLE_HOME) -lclntsh
INCLUDE_DIR=-I. -I$(ORACLE_HOME)/rdbms/demo -I$(ORACLE_HOME)/rdbms/public/ -I$(ORACLE_HOME)/plsql/public -I$(ORACLE_HOME)/network/public 
LIB_PATH=-L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/rdbms/lib 
FROMDEMO=-DLINUX -DORAX86_64 -D_GNU_SOURCE -D_LARGEFILE64_SOURCE=1 -D_LARGEFILE_SOURCE=1 -DSLTS_ENABLE -DSLMXMX_ENABLE-D_REENTRANT -DNS_THREADS -DLONG_IS_64 -fno-strict-aliasing -DSS_64BIT_SERVER 

testOracle: testOracle.o 
        @echo "generating testOracle"
        $(CXX) $(LDFLAGS) $(LIB_PATH) -Locci testOracle.o -o testOracle -locci -lclntsh   `cat $(ORACLE_HOME)/lib/sysliblist` -ldl -lm -lpthread 

testOracle.o: testOracle.cxx 
        @echo "generating testOracle.o"
        $(CXX) -c $(CPPFLAGS) $(FROMDEMO) $(INCLUDE_DIR) -c testOracle.cxx -o testOracle.o 

clean:
        rm -rf *.o testOracle

---

CategoryDCSProject