Accessing the CoralDB and finding out what's in there.

Compile Commands

source setup.sh
make clean

g++ -g -Wall -D_GNU_SOURCE -DGNU_SOURCE -fPIC -pthread -pipe -ansi -c Alias.cxx
g++ -g -Wall -D_GNU_SOURCE -DGNU_SOURCE -fPIC -pthread -pipe -ansi -c CompoundTag.cxx
g++ -g -Wall -D_GNU_SOURCE -DGNU_SOURCE -fPIC -pthread -pipe -ansi -c Connection.cxx
g++ -g -Wall -D_GNU_SOURCE -DGNU_SOURCE -fPIC -pthread -pipe -ansi -c Encodable.cxx -fPIC
g++ -I$BOOSTINC -I$CORAL/include -L$CORAL/$ARCH/lib -L$BOOSTLIB -I$ORACLE/$ARCH/include -L$ORACLE/$ARCH/lib -Wall -D_GNU_SOURCE -DGNU_SOURCE -fPIC -pthread -pipe -ansi -c CoralDB.cxx 
make libCoralDB.a

g++ -shared CoralDB.o Connection.o CompoundTag.o Alias.o Encodable.o -D_GNU_SOURCE -DGNU_SOURCE -fPIC -pthread -pipe -ansi  -I$CORAL/include -I$BOOSTINC -L$BOOSTLIB -L$CORAL/$ARCH/lib -DCORAL_TWO -llcg_RelationalAccess -llcg_CoralBase -L$UUID/$ARCH/lib -luuid -L$PCRE/$ARCH/lib -lpcre -lboost_thread -I$ORACLE/$ARCH/include -L$ORACLE/$ARCH/lib -locci -lclntsh -L$XERCESC/$ARCH/lib -lxerces-c -lnsl -lcrypt -ldl -Wl,-E -o libCoralDB.so

g++ ccdb.cxx libCoralDB.a -I$BOOSTINC -I$CORAL/include -L$BOOSTLIB -L$CORAL/$ARCH/lib -lnsl -lcrypt -ldl -Wl,-E -llcg_RelationalAccess -llcg_CoralBase -L$UUID/$ARCH/lib -luuid -L$PCRE/$ARCH/lib -lboost_thread -lpcre -I$ORACLE/$ARCH/include -L$ORACLE/$ARCH/lib -locci -lclntsh -L$XERCESC/$ARCH/lib -lxerces-c -o ccdb

Contents of Database

Using CoralDB Access from Athena but independent of Athena. Looking at module 1181 and trying to find out what's combined with that.

Connections

BOC_1 / ROD_L1_S5  --->   ROD_L1_S5 / LINK_MAP

ROD_L1_S5 / AA  --->   L2_B11_S2_A7_OB / UP
ROD_L1_S5 / BB  --->   L2_B11_S1_A6_OB / UP
ROD_L1_S5 / CC  --->   L2_B12_S2_A7_OB / UP
ROD_L1_S5 / DD  --->   L2_B12_S1_A6_OB / UP
ROD_L1_S5 / ROL  --->   ROL-PIX-B-00-112405 / ROD

Y2705A2_BocCr04.Plug16 / TBOC5  --->   ROD_L1_S5 / BOC-MONITORING

A4_OSP_BOT / OPTO-BOARD-0  --->   L2_B11_S1_A6_OB / SQP-A34-OP-A4-P1R-B
D_TYPE / L2_B11_S1_A6_OB  --->   L2_B11_S1_A6_OB / LINK_MAP
L2_B11_S1_A6 / M1  --->   L2_B11_S1_A6_M6A / UP
L2_B11_S1_A6 / M2  --->   L2_B11_S1_A6_M5A / UP
L2_B11_S1_A6 / M4  --->   L2_B11_S1_A6_M3A / UP
L2_B11_S1_A6 / M5  --->   L2_B11_S1_A6_M2A / UP
L2_B11_S1_A6 / M6  --->   L2_B11_S1_A6_M1A / UP
L2_B11_S1_A6_OB / PP0  --->   L2_B11_S1_A6 / OB
PP0S / L2_B11_S1_A6  --->   L2_B11_S1_A6 / UP

PP1B-OSP-A4-R1-P4.24 / OSP-A4-R1-P4.24  --->   L2_B11_S1_A6 / ONTC
PP1B-OSP-A4-R2-P4.2 / OSP-A4-R2-P4.2  --->   L2_B11_S1_A6 / HV
PP1B-OSP-A4-R5-P4 / OSP-A4-R5-P4  --->   L2_B11_S1_A6 / LV

PP2_AP2_423_Board2 / Ch1  --->   L2_B11_S1_A6_M6A / VddD
PP2_AP2_423_Board2 / Ch2  --->   L2_B11_S1_A6_M5A / VddD
PP2_AP2_423_Board2 / Ch4  --->   L2_B11_S1_A6_M6A / VddA
PP2_AP2_423_Board2 / Ch5  --->   L2_B11_S1_A6_M5A / VddA
PP2_AP2_423_Board2 / Ch7  --->   L2_B11_S1_A6_M3A / VddD
PP2_AP2_423_Board2 / Ch8  --->   L2_B11_S1_A6_M2A / VddD
PP2_AP2_423_Board2 / Ch9  --->   L2_B11_S1_A6_M3A / VddA
PP2_AP2_423_Board2 / Cha  --->   L2_B11_S1_A6_M2A / VddA
PP2_AP2_423_Board2 / Chb  --->   L2_B11_S1_A6_M1A / VddA
PP2_AP2_423_Board2 / Chd  --->   L2_B11_S1_A6_M1A / VddD

ROD_L1_S5 / BB  --->   L2_B11_S1_A6_OB / UP
cooling_loop33 / L2_B11_S1_A6-loop33  --->   L2_B11_S1_A6 / COOLING-PP0

A4_OSP_BOT / OPTO-BOARD-0  --->   L2_B11_S1_A6_OB / SQP-A34-OP-A4-P1R-B
D_TYPE / L2_B11_S1_A6_OB  --->   L2_B11_S1_A6_OB / LINK_MAP

Y1414A2_IDB_SC05 / AI/ai_59.value  --->   Y1414A2_SC19C.SCOLink3 / UP
Y1414A2_SC19C / SCOLink3  --->   Y1414A2_SC19C.SCOLink3 / CAN
Y1414A2_SC19C.SCOLink3 / AP2_423_Board2.Chf  --->   PP2_AP2_423_Board2 / SCO-LINK
Y1414A2_SC19C.SCOLink3 / OPTO12_B5  --->   Y3423X8_OPTO12_B5 / SCO

Y0614A2_LV37 / LV37-4  --->   Y0614A2_LV37/Output/Channel/4 / UP
Y0614A2_LV37/Output/Channel/4 / VDD2  --->   Y0614A2_LV_PP4_37B.WienerCh1 / UP
Y1414A2_IDB_LV09 / AI/ai_4.value  --->   Y0614A2_LV37/Output/Channel/4 / VDD

Y0614A2_LV37 / LV37-5  --->   Y0614A2_LV37/Output/Channel/5 / UP
Y0614A2_LV37/Output/Channel/5 / VDDA2  --->   Y0614A2_LV_PP4_37B.WienerCh2 / UP
Y1414A2_IDB_LV09 / AI/ai_5.value  --->   Y0614A2_LV37/Output/Channel/5 / VDDA

Y0914A2_HV08_1A / Ch01  --->   Y0914A2_HV08_1A.Ch01 / UP
Y0914A2_HV08_1A.Ch01 / Module::HV08_1A.Ch01  --->   Y0914A2_HV-PP4-15_A.O4.5.2 / UP
Y1414A2_IDB_HV05 / AI/ai_41.value  --->   Y0914A2_HV08_1A.Ch01 / HV

Y1414A2_LU19_Tmod3 / AI/ai_55.value  --->   Y3423X8_BBIM11D.Ibox3.Temp7-c / UP
Y3423X8_BBIM11D / Ibox3.Temp7  --->   Y3423X8_BBIM11D.Ibox3.Temp7-c / BBIM-CHN-208
Y3423X8_BBIM11D.Ibox3.Temp7-c / TModule  --->   A.P2-3.31-6-2 / UP

Y1414A2_LU19_FPGA/AI/ai_29.value / TOpto  --->   Y3423X8_BBIM11D.Ibox2.Tempc / UP
Y3423X8_BBIM11D / Ibox2.Tempc  --->   Y3423X8_BBIM11D.Ibox2.Tempc / BBIM-CHN-392
Y3423X8_BBIM11D.Ibox2.Tempc / TOpto  --->   Y3423X8_OPTO12_BT5 / UP

Y1414A2_LU19_FPGA/AI/ai_63.value / Tpp2-PP2_AP2_423  --->   Y3525X4_BBIM14A.Ibox3.Temp7 / UP
Y3525X4_BBIM14A / Ibox3.Temp7  --->   Y3525X4_BBIM14A.Ibox3.Temp7 / BBIM-CHN-553
Y3525X4_BBIM14A.Ibox3.Temp7 / Tpp2  --->   PP2_AP2_423 / UP

Possible Queries

./ccdb --db oracle://ATLAS_COOLPROD/ATLAS_COOLONL_PIXEL --idTag PIXEL --tags PIT-ALL-V39 findConnToSlot ROD_L1_S5 ROD
ROD_L1_S5 / ROL  --->   ROL-PIX-B-00-112405 / ROD


CategoryDCSProject

ATLAS: ClemensLange/PixelDCS/CoralDB (last edited 2010-02-18 10:36:59 by ClemensLange)