Script created for DCOPS data transfer to offline. It seems to work OK.
There was some hassle with root/oracle interference: it seems that the root version wasn't compatible with the oracle version. Which is bad, because that's the one I use for the DAQ. The following works:
export ROOTSYS=/nfshome0/cmssw/slc4_ia32_gcc345/lcg/root/5.14.00g-CMS18l export ORACLE_HOME=/nfshome0/cmssw/slc4_ia32_gcc345/external/oracle/10.2.0.3
The script is ~jnb/Transfer/newDay.sh
It uses an auxilliary file lastTimestamp
and two programs: readRow and countRow
which are created by
all of which are packaged in readRow.tar
The script sets up and invokes a program which uses the existing lastTimestamp as the first argument, so that it creates a file of the DCOPS rows generated between (but not including) that time and now. The data files include timestamp information (first and last used), so simply decoding the just-created file lets the script update the lastTimestamp file, and then it submits the file for insertion into the transfer system, using as number of events the number of DCOPS_NEW_DCOPS "events" it processed and as run number the most recent timestamp.
Worked on trying to get the root readback working correctly. Since it uses database calibrations, this is tricky, since CMSSW_2_0_9 doesn't seem to support the root-oracle interface. I may have to rewrite this, which will take a day to do and test. Until that falls into place testing will be a bit tricky.
Modified 8-August-2008 at 16:01
|Previous notes||Next notes||Main slide directory|