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