Tools for dumping CMS database payloads

Package contents

• a conddb_dumper executable that can be used to dump (mostly ECAL) conditions in txt files from a given object-specific tag, with several options
• a general plugin for dumping several conditions at the same time/run from a given Global Tag, via cmsRun + configuration file.
• a general plugin for dumping ECAL events for closer inspection
• some utilities developed for the monitoring of the ECAL laser monitoring corrections

Dumper list

• conddb_dumper.cpp: self-explicative via the -h/--help options. Currently supported objects:
  • BeamSpotObjects
  • ESEEIntercalibConstants
  • ESGain
  • ESIntercalibConstants
  • EcalADCToGeVConstant
  • EcalChannelStatus
  • EcalClusterLocalContCorrParameters
  • EcalGainRatios
  • EcalIntercalibConstants
  • EcalIntercalibConstantsMC
  • EcalLaserAlphas
  • EcalPFRecHitThresholds
  • EcalPedestals
  • EcalPulseCovariances
  • EcalPulseShapes
  • EcalSamplesCorrelation
  • EcalSimPulseShape
  • EcalTPGLinearizationConst
  • EcalTPGLutGroup
  • EcalTPGLutIdMap
  • EcalTPGPedestals
  • EcalTPGSlidingWindow
  • EcalTPGSpike
  • EcalTPGWeightGroup
  • EcalTPGWeightIdMap
  • EcalTimeCalibConstants
  • EcalTimeOffsetConstant
  • RunInfo
• lava_db.cpp: validate a tag of the ECAL monitoring corrections
• lava_text.cpp: validate a set of ECAL monitoring corrections starting from a txt file with dumped-corrections
• lava_db_compare.cpp: compare two tags of ECAL monitoring corrections, by matching the IOV of one tag to the closest IOV of the other tag
• lava_db_cond.cpp: (superseded) for ECAL monitoring corrections, compare the content of a tag to the content of another tag, by matching the IOV of one tag to the closest IOV of the other tag
• lava_db_dumpId.cpp: dump ECAL monitoring correction histories for a given set of DetId (or all of them)
• lava_db2txt.cpp: convert the content of ECAL monitoring corrections to a txt file
• lava_db2root.cpp: convert the content of ECAL monitoring corrections to a root file
• merge_dump.cpp: merges different txt files of ECAL monitoring corrections with overlapping IOV into one single coherent txt file (N.B. does not need the CMSSW environment to work)

Dumper setup

Setup a working area for example in CMSSW_12_3_5. Any release >=12_3_5 should work just fine, contact me in case not. For older releases please refer to the branches cmssw_12x, cmssw_12x_prior_12_3_5, cmssw_11x, cmssw_10x, cmssw_9x, cmssw_8x, and cmssw_7x, for CMSSW_11X, CMSSW_10X, CMSSW_9X, CMSSW_8X, and CMSSW_7X respectively. The branch cmssw_12x_prior_12_3_5 has the old BS methods to retrieve z(), zError(), sigmaZ(), sigmaZError(), i.e. GetZ(), GetZError(), GetSigmaZ(), GetSigmaZError(): please use it if you are in a 12x series that gives the corresponding compilation errors. Starting from not later than 12_3_5, the new methods are used. Please note that not all the objects supported in the latest release are backported.

cmsrel CMSSW_14_0_0_pre0
cd CMSSW_14_0_0_pre0/src
cmsenv
git cms-init
git clone git@github.com:ferriff/usercode.git
git cms-merge-topic -u ferriff:ecal_calib_tools # works with some apparently harmless errors
cd usercode/
scram b

Example: how to dump an object from the default Frontier DataBase

conddb_dumper -O EcalIntercalibConstants -t EcalIntercalibConstants_2012ABCD_offline

Additional documentation

• https://twiki.cern.ch/twiki/bin/view/CMS/DBDump