]> git.uio.no Git - u/mrichter/AliRoot.git/blobdiff - TPC/CalibMacros/CalibEnv.C
AliTPCcalibDB.cxx - Calculate the distance to the closest measurement
[u/mrichter/AliRoot.git] / TPC / CalibMacros / CalibEnv.C
index 6bc980c5cbe392a6eaf047403ad38e85bf9ba8dd..4daf732590563b606d0ab369cbd2688522c448fb 100644 (file)
@@ -1,19 +1,23 @@
 /*
+//Make a tree dump of TPC calibration:
+
 gSystem->AddIncludePath("-I$ALICE_ROOT/TPC");
 .L $ALICE_ROOT/TPC/CalibMacros/CalibEnv.C+
-Init();
-CalibEnv("listenv.txt");
-TFile f("dccTime.root")
 
+CalibEnv("run.list");
+TFile f("dcsTime.root")
 */
-
+#include "TMVA/TSpline1.h"
+#include "TMVA/TSpline2.h"
 #include <iostream>
 #include <fstream>
+#include <stdio.h>
 #include <AliCDBManager.h>
 #include <AliCDBEntry.h>
 #include <AliLog.h>
 #include <AliMagF.h>
 #include "AliTPCcalibDB.h"
+#include "AliTPCcalibDButil.h"
 #include "AliTPCAltroMapping.h"
 #include "AliTPCExB.h"
 #include "AliTPCCalROC.h"
@@ -27,178 +31,634 @@ TFile f("dccTime.root")
 #include "TObjString.h"
 #include "TString.h"
 #include "AliTPCCalPad.h"
+#include "AliTPCROC.h"
+#include "AliTPCParam.h"
 #include "AliTPCCalibPulser.h"
 #include "AliTPCCalibPedestal.h"
 #include "AliTPCCalibCE.h"
 #include "AliTPCExBFirst.h"
 #include "TTreeStream.h"
 #include "AliTPCTempMap.h"
+#include "TVectorD.h"
+#include "TMatrixD.h"
+#include "AliTPCCalibRaw.h"
+#include "AliSplineFit.h"
+#include "TGraphErrors.h"
 
-void ProcessGoofie( AliDCSSensorArray* goofieArray, TVectorD & vecEntries, TVectorD & vecMedian, TVectorD &vecMean, TVectorD &vecRMS);
-
-void Init(){
+//
+AliTPCcalibDB     *calibDB=0;
+AliTPCcalibDButil *dbutil =0;
+TTree * dcsTree=0;
+TString refFile="dummy.root"; 
+TTreeSRedirector *pcstream =0;
+//
+//
+void ProcessRun(Int_t irun, Int_t startTime, Int_t endTime);
+void GetProductionInfo(Int_t run, Int_t &nalien, Int_t &nRawAlien, Int_t &nlocal, Int_t &nRawLocal);
+void ProcessDrift(Int_t run, Int_t timeStamp);
+void ProcessDriftCE(Int_t run, Int_t timeStamp);
+void ProcessDriftAll(Int_t run, Int_t timeStamp);
+void ProcessKryptonTime(Int_t run, Int_t timeStamp);
+void CalibEnv(const char * runList, Int_t first=1, Int_t last=-1){
   //
+  // runList - listOfRuns to process
+  // first   - first run to process
+  // last    - last  to process
+  // 
+  refFile=gSystem->Getenv("REF_DATA_FILE");
+  calibDB = AliTPCcalibDB::Instance();
+  dbutil= new AliTPCcalibDButil;
   //
+  // make list of runs
   //
-  AliCDBManager::Instance()->SetDefaultStorage("local://$ALICE_ROOT");
-  AliCDBManager::Instance()->SetSpecificStorage("TPC/Calib/Parameters","local://$ALICE_ROOT");
-  AliCDBManager::Instance()->SetSpecificStorage("GRP/GRP/Data","local:///lustre_alpha/alice/alien/alice/data/2008/LHC08d/OCDB/");
-  AliCDBManager::Instance()->SetSpecificStorage("TPC/Calib/Temperature","local:///lustre_alpha/alice/alien/alice/data/2008/LHC08d/OCDB/");
-  AliCDBManager::Instance()->SetSpecificStorage("TPC/Calib/Goofie","local:///lustre_alpha/alice/alien/alice/data/2008/LHC08d/OCDB/");
-  
-  AliCDBManager::Instance()->SetRun(1);
-
+  ifstream in;
+  in.open(runList);
+  Int_t irun=0;
+  TArrayI runArray(100000);
+  Int_t indexes[100000];
+  Int_t nruns=0;
+  while(in.good()) {
+    in >> irun;
+    if (in.eof()) break;
+    if (irun<first) continue;  // process only subset of list
+    if (last>0 && irun>=last) continue;  // process only subset of list
+    runArray[nruns]=irun;
+    nruns++;
+  }
+  TMath::Sort(nruns, runArray.fArray, indexes,kFALSE);
+  pcstream = new TTreeSRedirector("dcsTime.root");
+  dbutil->SetRefFile(refFile.Data());
+  Int_t startTime = 0;
+  Int_t endTime   = 0;
+  for (Int_t run=0; run<nruns; run++){
+    Int_t irun=runArray[indexes[run]];
+    printf("Processing run %d ...\n",irun);
+    AliTPCcalibDB::Instance()->SetRun(irun);
+    dbutil->UpdateFromCalibDB();
+    //
+    AliDCSSensorArray *arrHV=calibDB->GetVoltageSensors(irun);
+    if (!arrHV) continue;
+    for  (Int_t isenHV=0; isenHV<arrHV->NumSensors(); ++isenHV){
+      AliDCSSensor *senHV=arrHV->GetSensorNum(isenHV);
+      if (!senHV) {
+       printf("Not interesting OCDB info\n");
+       continue;
+      }
+      startTime=senHV->GetStartTime();
+      endTime  =senHV->GetEndTime();
+      if (startTime>0&&endTime>0) break;
+    }
+    dbutil->FilterCE(120., 3., 4.,pcstream);
+    dbutil->FilterTracks(irun, 10.,pcstream);
+    AliDCSSensorArray* goofieArray = AliTPCcalibDB::Instance()->GetGoofieSensors(irun);                 
+    //if (goofieArray) dbutil->FilterGoofie(goofieArray,2,4,pcstream);
+    // don't filter goofie for the moment
+    ProcessRun(irun, startTime,endTime);
+  }
+  delete pcstream;  
 }
 
 
-void CalibEnv(const char * runList){
+void ProcessRun(Int_t irun, Int_t startTime, Int_t endTime){
   //
   //
+  // 
+  AliSplineFit *fitVdrift=0x0;
+  Int_t startTimeGRP=0, stopTimeGRP=0;
+  if (calibDB->GetGRP(irun)){
+    startTimeGRP = AliTPCcalibDB::GetGRP(irun)->GetTimeStart();
+    stopTimeGRP  = AliTPCcalibDB::GetGRP(irun)->GetTimeEnd();
+  }
+  
+  AliTPCSensorTempArray * tempArray = AliTPCcalibDB::Instance()->GetTemperatureSensor(irun);
+  AliTPCTempMap * tempMap = new AliTPCTempMap(tempArray);
+  AliDCSSensorArray* goofieArray = AliTPCcalibDB::Instance()->GetGoofieSensors(irun);
+  //
+  Int_t dtime = TMath::Max((endTime-startTime)/20,10*60);
+  //
+  //Goofie statistical data
+  //
+  TVectorD vecEntries, vecMean, vecMedian,vecRMS;
+  dbutil->ProcessGoofie(vecEntries ,vecMedian, vecMean, vecRMS);
+  //
+  //CE data processing - see ProcessCEdata function for description of the results
+  //
+  TVectorD fitResultsA, fitResultsC;
+  Int_t nmaskedCE;
+  Double_t chi2ACE=0,chi2CCE=0;
+  //     dbutil->ProcessCEdata("(sector<36)++gx++gy++lx++lx**2",fitResultsA,fitResultsC,nmaskedCE);
+  dbutil->ProcessCEdata("(sector<36)++gx++gy++(lx-134)++(sector<36)*(lx-134)++(ly/lx)^2",fitResultsA,fitResultsC,nmaskedCE,chi2ACE,chi2CCE);
+
+  TVectorD fitCEResultsA(7), fitCEResultsC(7);
+  Int_t    noutCE;
+  Double_t chi2CEA=0,chi2CEC=0;
+  AliTPCCalPad *time0 = dbutil->CreatePadTime0CE(fitCEResultsA, fitCEResultsC, noutCE, chi2CEA, chi2CEC);
+  delete time0;
   //  
-  ifstream in;
-  in.open(runList);
-  Int_t irun=0;
-  TTreeSRedirector *pcstream = new TTreeSRedirector("dccTime.root");
-  //  for (Int_t irun=startRun; irun<stopRun; irun++){
-  while(in.good()) {
-    in >> irun;
-    if (irun==0) continue;
-    printf("Processing run %d\n",irun);
-    AliDCSSensor * sensorPressure = AliTPCcalibDB::Instance()->GetPressureSensor(irun);
-    if (!sensorPressure) continue;
-    AliTPCSensorTempArray * tempArray = AliTPCcalibDB::Instance()->GetTemperatureSensor(irun);
-    AliTPCTempMap * tempMap = new AliTPCTempMap(tempArray);
-    AliDCSSensorArray* goofieArray = AliTPCcalibDB::Instance()->GetGoofieSensors(irun);
+  //
+  TVectorD vecTEntries, vecTMean, vecTRMS, vecTMedian, vecQEntries, vecQMean, vecQRMS, vecQMedian;
+  Float_t driftTimeA, driftTimeC;
+  dbutil->ProcessCEgraphs(vecTEntries, vecTMean, vecTRMS, vecTMedian,
+                         vecQEntries, vecQMean, vecQRMS, vecQMedian,
+                         driftTimeA, driftTimeC );
+  //
+  //
+  //
+  //drift velocity using tracks
+  //
+  //     fitVdrift=calibDB->GetVdriftSplineFit("ALISPLINEFIT_MEAN_VDRIFT_COSMICS_ALL",irun);
+  fitVdrift=calibDB->CreateVdriftSplineFit("TGRAPHERRORS_MEAN_VDRIFT_COSMICS_ALL",irun);
+  //noise data Processing - see ProcessNoiseData function for description of the results
+  TVectorD vNoiseMean, vNoiseMeanSenRegions, vNoiseRMS, vNoiseRMSSenRegions;
+  Int_t nonMaskedZero=0;
+  dbutil->ProcessNoiseData(vNoiseMean, vNoiseMeanSenRegions, vNoiseRMS, vNoiseRMSSenRegions, nonMaskedZero);
+  //
+  // comparisons
+  //
+  TVectorF pedestalDeviations;
+  TVectorF noiseDeviations;
+  TVectorF pulserQdeviations;
+  Float_t varQMean;
+  Int_t npadsOutOneTB;
+  Int_t npadsOffAdd;
+  dbutil->ProcessPedestalVariations(pedestalDeviations);
+  dbutil->ProcessNoiseVariations(noiseDeviations);
+  dbutil->ProcessPulserVariations(pulserQdeviations,varQMean,npadsOutOneTB,npadsOffAdd);
+  //
+  //L3 data 
+  //
+  Float_t bz=AliTPCcalibDB::GetBz(irun);
+  Char_t  l3pol=AliTPCcalibDB::GetL3Polarity(irun);
+  //
+  //calibration Pulser data processing
+  //
+  Int_t nOffChannels=0;
+  TVectorD vTimePulser;
+  nOffChannels=dbutil->GetNPulserOutliers();
+  dbutil->ProcessPulser(vTimePulser);
+  //
+  //ALTRO data
+  //
+  Int_t nMasked=0;
+  dbutil->ProcessALTROConfig(nMasked);
+  //
+  //Calib RAW data
+  //
+  Int_t nFailL1=-1;
+  if (calibDB->GetCalibRaw()) nFailL1=calibDB->GetCalibRaw()->GetNFailL1Phase();
+  //
+  //production information
+  //
+  Int_t nalien=0,nRawAlien=0,nlocal=0,nRawLocal=0;
+  //     GetProductionInfo(irun, nalien, nRawAlien, nlocal,nRawLocal);
+  //run type
+  TObjString runType(AliTPCcalibDB::GetRunType(irun).Data());
+  //
+  //
+  //
+  
+  for (Int_t itime=startTime; itime<endTime; itime+=dtime){
     //
-    Int_t startTime = sensorPressure->GetStartTime();
-    Int_t endTime = sensorPressure->GetEndTime();
-    Int_t dtime = TMath::Max((endTime-startTime)/20,10*60);
-    for (Int_t itime=startTime; itime<endTime; itime+=dtime){
-      //
-      TTimeStamp tstamp(itime);
-      Float_t valuePressure = sensorPressure->GetValue(tstamp);
-
-      TLinearFitter * fitter = 0;
-      TVectorD vecTemp[10];
-      if (itime<tempArray->GetStartTime().GetSec() || itime>tempArray->GetEndTime().GetSec()){ 
-      }else{
-       for (Int_t itype=0; itype<5; itype++)
-         for (Int_t iside=0; iside<2; iside++){
-           fitter= tempMap->GetLinearFitter(itype,iside,tstamp);
-           if (!fitter) continue;
-           fitter->Eval(); fitter->GetParameters(vecTemp[itype+iside*5]);
-           delete fitter;
-         }
+    TTimeStamp tstamp(itime);
+    Float_t valuePressure  = calibDB->GetPressure(tstamp,irun,0);
+    Float_t valuePressure2 = calibDB->GetPressure(tstamp,irun,1);
+    Double_t ptrelative0 = AliTPCcalibDB::GetPTRelative((UInt_t)itime,irun,0);
+    Double_t ptrelative1 = AliTPCcalibDB::GetPTRelative((UInt_t)itime,irun,1);
+    //temperature fits
+    TLinearFitter * fitter = 0;
+    TVectorD vecTemp[10];
+    for (Int_t itype=0; itype<5; itype++)
+      for (Int_t iside=0; iside<2; iside++){
+       fitter= tempMap->GetLinearFitter(itype,iside,tstamp);     
+       if (!fitter) continue;
+       fitter->Eval();
+       fitter->GetParameters(vecTemp[itype+iside*5]);
+       delete fitter;
       }
-      
-      TVectorD vecGoofie, vecEntries, vecMean, vecMedian,vecRMS;
-      if (goofieArray){        
-       vecGoofie.ResizeTo(goofieArray->NumSensors());
-       ProcessGoofie(goofieArray, vecEntries ,vecMedian, vecMean, vecRMS);
-  //
-       for (Int_t isensor=0; isensor<goofieArray->NumSensors();isensor++){
-         AliDCSSensor *gsensor = goofieArray->GetSensor(isensor);
-         if (gsensor){
-           vecGoofie[isensor] = gsensor->GetValue(tstamp);
-         }
+    //
+    //measured skirt temperatures
+    //
+    TVectorD vecSkirtTempA(18);
+    TVectorD vecSkirtTempC(18);
+    Int_t nsenTemp=tempArray->NumSensors();
+    for (Int_t isenTemp=0;isenTemp<nsenTemp;++isenTemp){
+      AliTPCSensorTemp *senTemp=(AliTPCSensorTemp*)tempArray->GetSensorNum(isenTemp);
+      if (senTemp->GetType()!=3) continue;
+      if (TMath::Sqrt(senTemp->GetX()*senTemp->GetX()+senTemp->GetY()*senTemp->GetY())<100) continue; //only skirt, outer FC vessel
+      Double_t val=senTemp->GetValue(tstamp);
+      if (senTemp->GetSide()==0)
+       vecSkirtTempA[senTemp->GetSector()]=val;
+      else
+       vecSkirtTempC[senTemp->GetSector()]=val;
+    }
+    //
+    //goofie data
+    //
+    TVectorD vecGoofie;
+    if (goofieArray){
+      vecGoofie.ResizeTo(goofieArray->NumSensors());
+      for (Int_t isensor=0; isensor<goofieArray->NumSensors();isensor++){
+       AliDCSSensor *gsensor = goofieArray->GetSensor(isensor);
+       if (gsensor){
+         vecGoofie[isensor] = gsensor->GetValue(tstamp);
        }
       }
+    } else {
+      vecGoofie.ResizeTo(19);
+    }
+    //
+    TVectorD voltagesIROC(36);
+    TVectorD voltagesOROC(36);
+    for(Int_t j=1; j<36; j++) voltagesIROC[j-1] = AliTPCcalibDB::Instance()->GetChamberHighVoltage(irun, j,itime);
+    for(Int_t j=36; j<72; j++) voltagesOROC[j-36] = AliTPCcalibDB::Instance()->GetChamberHighVoltage(irun, j,itime);
+    Double_t voltIROC = TMath::Median(36, voltagesIROC.GetMatrixArray());
+    Double_t voltOROC = TMath::Median(36, voltagesOROC.GetMatrixArray());
+    //
+    Float_t  coverIA=AliTPCcalibDB::GetCoverVoltage(irun,0,itime);
+    Float_t  coverIC=AliTPCcalibDB::GetCoverVoltage(irun,18,itime);
+    Float_t  coverOA=AliTPCcalibDB::GetCoverVoltage(irun,36,itime);
+    Float_t  coverOC=AliTPCcalibDB::GetCoverVoltage(irun,54,itime);
+    Float_t  skirtA=AliTPCcalibDB::GetSkirtVoltage(irun,0,itime);
+    Float_t  skirtC=AliTPCcalibDB::GetSkirtVoltage(irun,18,itime);
+    Float_t  ggOffA=AliTPCcalibDB::GetGGoffsetVoltage(irun,0,itime);
+    Float_t  ggOffC=AliTPCcalibDB::GetGGoffsetVoltage(irun,18,itime);
+    //drift velocity
+    Float_t dvCorr=-5;
+    if (fitVdrift) dvCorr=fitVdrift->Eval(itime);
+    //
+    // Gain - Alexander Kalveit
+    //
+    Float_t  gainCosmic = 0;
+    Float_t  gainMIP = 0;
+    TObjArray * gainSplines = AliTPCcalibDB::Instance()->GetTimeGainSplinesRun(irun);
+    if (gainSplines) {
+      TGraphErrors * graphMIP = (TGraphErrors *) gainSplines->FindObject("TGRAPHERRORS_MEAN_GAIN_BEAM_ALL");
+      TGraphErrors * graphCosmic = (TGraphErrors *) gainSplines->FindObject("TGRAPHERRORS_MEAN_GAIN_COSMIC_ALL");
+      if (graphMIP) gainMIP = graphMIP->Eval(itime);
+      if (graphCosmic) gainCosmic = graphCosmic->Eval(itime);
+    }
+    
+    
+    //tempMap->GetLinearFitter(0,0,itime);
+    (*pcstream)<<"dcs"<<
+      "run="<<irun<<
+      "time="<<itime<<
+      "startTimeGRP="<<startTimeGRP<<
+      "stopTimeGRP="<<stopTimeGRP<<
+      //run type
+      "runType.="<<&runType<<
+      // voltage setting
+      "VIROC.="<<&voltagesIROC<<
+      "VOROC.="<<&voltagesOROC<<
+      "medianVIROC="<<voltIROC<<
+      "medianVOROC="<<voltOROC<<
+      "coverIA=" << coverIA <<
+      "coverIC=" << coverIC <<
+      "coverOA=" << coverOA <<
+      "coverOC=" << coverOC <<
+      "skirtA=" << skirtA <<
+      "skirtC=" << skirtC <<
+      "ggOffA=" << ggOffA <<
+      "ggOffC=" << ggOffC <<
+      //
+      "ptrel0="<<ptrelative0<<  // deltaTP/TP  - A side
+      "ptrel1="<<ptrelative1<<  // deltaTP/TPC - C side
+      "goofie.="<<&vecGoofie<<
+      "goofieE.="<<&vecEntries<<
+      "goofieMean.="<<&vecMean<<
+      "goofieMedian.="<<&vecMedian<<
+      "goofieRMS.="<<&vecRMS<<
+      //
+      "press="<<valuePressure<<
+      "press2="<<valuePressure2<<
+      "temp00.="<<&vecTemp[0]<<
+      "temp10.="<<&vecTemp[1]<<
+      "temp20.="<<&vecTemp[2]<<
+      "temp30.="<<&vecTemp[3]<<
+      "temp40.="<<&vecTemp[4]<<
+      "temp01.="<<&vecTemp[5]<<
+      "temp11.="<<&vecTemp[6]<<
+      "temp21.="<<&vecTemp[7]<<
+      "temp31.="<<&vecTemp[8]<<
+      "temp41.="<<&vecTemp[9]<<
+      "tempSkirtA.="<<&vecSkirtTempA<<
+      "tempSkirtC.="<<&vecSkirtTempC;
+    ProcessDrift(irun, itime);
+    ProcessDriftCE(irun,itime);
+    ProcessDriftAll(irun,itime);
+    ProcessKryptonTime(irun,itime);
+    (*pcstream)<<"dcs"<<       
+      //noise data
+      "meanNoise.="<<&vNoiseMean<<
+      "meanNoiseSen.="<<&vNoiseMeanSenRegions<<
+      "rmsNoise.="<<&vNoiseRMS<<
+      "rmsNoiseSen.="<<&vNoiseRMSSenRegions<<
+      "zeroNoise="<<nonMaskedZero<<
+      //pulser data
+      "timePulser.=" << &vTimePulser <<
+      "nOffPulser="<<nOffChannels<<
+      //altro data
+      "nMasked="<<nMasked<<
+      //ce data -Jens version
+      "CEfitA.="<<&fitResultsA<<
+      "CEfitC.="<<&fitResultsC<<
+      "nmaskedCE="<<nmaskedCE<<
+      "chi2ACE="<<chi2ACE<<
+      "chi2CCE="<<chi2CCE<<
+      //ce data new - MI version
+      "CEfitAMI.="<<&fitCEResultsA<<
+      "CEfitCMI.="<<&fitCEResultsC<<
+      "chi2CEA="<<chi2CEA<<
+      "chi2CEC="<<chi2CEC<<
+      //
+      //ce graph data
+      "CEgrTEntries.="<<&vecTEntries<<
+      "CEgrTMean.="<<&vecTMean<<
+      "CEgrTRMS.="<<&vecTRMS<<
+      "CEgrTMedian.="<<&vecTMedian<<
+      "CEgrQEntries.="<<&vecQEntries<<
+      "CEgrQMean.="<<&vecQMean<<
+      "CEgrQRMS.="<<&vecQRMS<<
+      "CEgrQMedian.="<<&vecQMedian<<
+      "CEgrDriftA="<<driftTimeA<<
+      "CEgrDriftC="<<driftTimeC<<
+      //calib raw data
+      "nFailL1="<<nFailL1<<
+      // b field
+      "Bz="<< bz <<
+      "L3polarity="<<l3pol<<
+      // production information
+      "nalien="<<nalien<<
+      "nRawAlien="<<nRawAlien<<
+      "nlocal="<<nlocal<<
+      "nRawLocal="<<nRawLocal<<
+      //comparisons with ref data
+      "pedestalDeviations.="<<&pedestalDeviations<<
+      "noiseDeviations.="<<&noiseDeviations<<
+      "pulserQdeviations.="<<&pulserQdeviations<<
+      //         "pulserVarQMean="<<varQMean<<
+      "pulserNpadsOutOneTB="<<npadsOutOneTB<<
+      "pulserNpadsOffAdd="<<npadsOffAdd<<
+      "driftCorrCosmAll="<<dvCorr<<
+      // time dependence of gain
+      "gainMIP="<<gainMIP<<
+      "gainCosmic="<<gainCosmic<<      
+      "\n";
+  }//end run loop
+  //     delete fitVdrift;
+  //     fitVdrift=0; 
+}
+
+
+
+
+void GetProductionInfo(Int_t run, Int_t &nalien, Int_t &nRawAlien, Int_t &nlocal, Int_t &nRawLocal){
+  //
+  // find number of ESDs in central and local production for run
+  //
+
+  nalien=0;
+  nRawAlien=0;
+  nlocal=0;
+  nRawLocal=0;
+  TString sNlines;
+  //find number of ESDs in alien
+  TString command="alien_find /alice/data/2009 ";
+  command += Form("%09d",run);
+  command += " | grep AliESDs.root | wc -l";
+  sNlines = gSystem->GetFromPipe(command.Data());
+  nalien=sNlines.Atoi();
+  //find number of raw files on alien
+  command="alien_find /alice/data/2009 ";
+  command += Form("%09d",run);
+  command += " | grep raw | grep -v tag | wc -l";
+  sNlines = gSystem->GetFromPipe(command.Data());
+  nRawAlien=sNlines.Atoi();
+  //find number of ESDs local
+  command="find /lustre/alice/alien/alice/data/2009 -name AliESDs.root | grep ";
+  command += Form("%09d",run);
+  command += " | wc -l";
+  sNlines = gSystem->GetFromPipe(command.Data());
+  nlocal=sNlines.Atoi();
+  //find number of local raw data files
+  command="find /lustre/alice/alien/alice/data/2009 -name \"*.root\" | grep ";
+  command += Form("%09d",run);
+  command += " | grep raw | grep -v tag | wc -l";
+  sNlines = gSystem->GetFromPipe(command.Data());
+  nRawLocal=sNlines.Atoi();
+}
+
+
+
+void ProcessDrift(Int_t run, Int_t timeStamp){
+  //
+  // dump drift calibration data to the tree
+  //
+  TObjArray *array =AliTPCcalibDB::Instance()->GetTimeVdriftSplineRun(run);
+  TGraphErrors *laserA[3]={0,0,0};
+  TGraphErrors *laserC[3]={0,0,0};
+  TGraphErrors *cosmicAll=0;
+  TGraphErrors *laserAE[3]={0,0,0};
+  TGraphErrors *laserCE[3]={0,0,0};
+  TGraphErrors *cosmicAllE=0;
+  static Double_t     vlaserA[3]={0,0,0};
+  static Double_t     vlaserC[3]={0,0,0};
+  static Double_t     vcosmicAll=0;
+  static Double_t     vdrift1=0;
+  vdrift1=AliTPCcalibDB::Instance()->GetVDriftCorrectionTime(timeStamp,run,0,1);
+
+  if (array){
+    laserA[0]=(TGraphErrors*)array->FindObject("GRAPH_MEAN_DELAY_LASER_ALL_A");
+    laserA[1]=(TGraphErrors*)array->FindObject("GRAPH_MEAN_DRIFT_LASER_ALL_A");
+    laserA[2]=(TGraphErrors*)array->FindObject("GRAPH_MEAN_GLOBALYGRADIENT_LASER_ALL_A");
+    laserC[0]=(TGraphErrors*)array->FindObject("GRAPH_MEAN_DELAY_LASER_ALL_C");
+    laserC[1]=(TGraphErrors*)array->FindObject("GRAPH_MEAN_DRIFT_LASER_ALL_C");
+    laserC[2]=(TGraphErrors*)array->FindObject("GRAPH_MEAN_GLOBALYGRADIENT_LASER_ALL_C");
+    cosmicAll =(TGraphErrors*)array->FindObject("TGRAPHERRORS_MEAN_VDRIFT_COSMICS_ALL");
+  }
+  if (laserA[0]) vlaserA[0]= AliTPCcalibDButil::EvalGraphConst(laserA[0],timeStamp);
+  if (laserA[1]) vlaserA[1]= AliTPCcalibDButil::EvalGraphConst(laserA[1],timeStamp);
+  if (laserA[2]) vlaserA[2]= AliTPCcalibDButil::EvalGraphConst(laserA[2],timeStamp);
+  if (laserC[0]) vlaserC[0]= AliTPCcalibDButil::EvalGraphConst(laserC[0],timeStamp);
+  if (laserC[1]) vlaserC[1]= AliTPCcalibDButil::EvalGraphConst(laserC[1],timeStamp);
+  if (laserC[2]) vlaserC[2]= AliTPCcalibDButil::EvalGraphConst(laserC[2],timeStamp);
+  if (cosmicAll) vcosmicAll= AliTPCcalibDButil::EvalGraphConst(cosmicAll,timeStamp); 
+  (*pcstream)<<"dcs"<<
+    "vlaserA0="<<vlaserA[0]<<
+    "vlaserA1="<<vlaserA[1]<<
+    "vlaserA2="<<vlaserA[2]<<
+    "vlaserC0="<<vlaserC[0]<<
+    "vlaserC1="<<vlaserC[1]<<
+    "vlaserC2="<<vlaserC[2]<<
+    "vcosmicAll="<<vcosmicAll<<
+    "vdrift1="<<vdrift1;
 
+  //
+  // define distance to measurement
+  //
+  static Double_t dlaserA=0; 
+  static Double_t dlaserC=0; 
+  static Double_t dcosmic=0; 
+  static Double_t slaserA=0; 
+  static Double_t slaserC=0; 
+  static Double_t scosmic=0; 
+  static Double_t  vclaserA[3]={0,0,0};
+  static Double_t  vclaserC[3]={0,0,0};
+  static Double_t  vccosmicAll=0;
+  for (Int_t i=0;i<3;i++){
+    if (laserA[i]) AliTPCcalibDButil::GetNearest(laserA[i],timeStamp,dlaserA,vclaserA[i]);
+    if (laserC[i]) AliTPCcalibDButil::GetNearest(laserC[i],timeStamp,dlaserC,vclaserC[i]);
+  }  
+  if (cosmicAll) AliTPCcalibDButil::GetNearest(cosmicAll,timeStamp,dcosmic,vccosmicAll);
+  (*pcstream)<<"dcs"<<
+    "vclaserA0="<<vclaserA[0]<<
+    "vclaserA1="<<vclaserA[1]<<
+    "vclaserA2="<<vclaserA[2]<<
+    "vclaserC0="<<vclaserC[0]<<
+    "vclaserC1="<<vclaserC[1]<<
+    "vclaserC2="<<vclaserC[2]<<
+    "vccosmicAll="<<vccosmicAll<<
+    "dlaserA="<<dlaserA<<
+    "dlaserC="<<dlaserC<<
+    "dcosmic="<<dcosmic<<
+    "slaserA="<<slaserA<<
+    "slaserC="<<slaserC<<
+    "scosmic="<<scosmic;
+}
 
-      tempMap->GetLinearFitter(0,0,itime);
-      (*pcstream)<<"dcs"<<
-       "run="<<irun<<
-       "time="<<itime<<
-       "goofie.="<<&vecGoofie<<
-       "goofieE.="<<&vecEntries<<
-       "goofieMean.="<<&vecMean<<
-       "goofieMedian.="<<&vecMedian<<
-       "goofieRMS.="<<&vecRMS<<
-       "press="<<valuePressure<<
-       "temp00.="<<&vecTemp[0]<<
-       "temp10.="<<&vecTemp[1]<<
-       "temp20.="<<&vecTemp[2]<<
-       "temp30.="<<&vecTemp[3]<<
-       "temp40.="<<&vecTemp[4]<<
-       "temp01.="<<&vecTemp[5]<<
-       "temp11.="<<&vecTemp[6]<<
-       "temp21.="<<&vecTemp[7]<<
-       "temp31.="<<&vecTemp[8]<<
-       "temp41.="<<&vecTemp[9]<<
-       "\n";
+void ProcessDriftCE(Int_t run,Int_t timeStamp){
+  //
+  // dump drift calibration data CE
+  //
+  TObjArray *arrT=AliTPCcalibDB::Instance()->GetCErocTtime();
+  AliTPCParam *param=AliTPCcalibDB::Instance()->GetParameters();
+  static TVectorD tdriftCE(74);
+  static TVectorD tndriftCE(74);
+  static TVectorD vdriftCE(74);
+  static TVectorD tcdriftCE(74);
+  static TVectorD tddriftCE(74);
+  static Double_t ltime0A;
+  static Double_t ltime0C;
+  //
+  //
+  //
+  ltime0A  = dbutil->GetLaserTime0(run,timeStamp,36000,0);
+  ltime0C  = dbutil->GetLaserTime0(run,timeStamp,36000,1);
+  //
+  for (Int_t i=0; i<arrT->GetEntries();i++){
+    tdriftCE[i]=0;
+    vdriftCE[i]=0;
+    TGraph *graph = (TGraph*)arrT->At(i);
+    if (!graph) continue;
+    tdriftCE[i]=AliTPCcalibDButil::EvalGraphConst(graph,timeStamp);
+    Double_t deltaT,gry;
+    AliTPCcalibDButil::GetNearest(graph,timeStamp,deltaT,gry);
+    tndriftCE[i]=graph->GetN();
+    tcdriftCE[i]=gry;         
+    tddriftCE[i]=deltaT;              
+    if (i%36<18){
+      vdriftCE[i] =(param->GetZLength(i)/(tdriftCE[i]*param->GetTSample()*(1.-ltime0A)-param->GetL1Delay()))/param->GetDriftV();
+    }else{
+      vdriftCE[i] =(param->GetZLength(i)/(tdriftCE[i]*param->GetTSample()*(1.-ltime0A)-param->GetL1Delay()))/param->GetDriftV();
     }
   }
-  delete pcstream;
+
+  (*pcstream)<<"dcs"<<  
+    "tdriftCE.="<<&tdriftCE<<
+    "vdriftCE.="<<&vdriftCE<<
+    "tndriftCE.="<<&tndriftCE<<
+    "tcdriftCE.="<<&tcdriftCE<<
+    "tddriftCE.="<<&tddriftCE<<
+    "ltime0A="<<ltime0A<<
+    "ltime0C="<<ltime0C;
+   }
+
+
+void ProcessDriftAll(Int_t run,Int_t timeStamp){
+  //
+  // dump drift calibration data  all calibrations form DB util
+  // test of utils
+  static Double_t vdriftCEA=0, vdriftCEC=0, vdriftCEM=0;
+  static Double_t vdriftLTA=0, vdriftLTC=0, vdriftLTM=0;
+  static Double_t dce=0, dla=0,dlc=0,dlm=0;
+  static Double_t ltime0A;
+  static Double_t ltime0C;
+  static Double_t     vdrift1=0;
+  vdrift1=AliTPCcalibDB::Instance()->GetVDriftCorrectionTime(timeStamp,run,0,1);
+  
+  //
+  vdriftCEA= dbutil->GetVDriftTPCCE(dla,run,timeStamp,36000,0);
+  vdriftCEC= dbutil->GetVDriftTPCCE(dlc,run,timeStamp,36000,1);
+  vdriftCEM= dbutil->GetVDriftTPCCE(dlm,run,timeStamp,36000,2);
+  //
+  vdriftLTA= dbutil->GetVDriftTPCLaserTracks(dla,run,timeStamp,36000,0);
+  vdriftLTC= dbutil->GetVDriftTPCLaserTracks(dlc,run,timeStamp,36000,1);
+  vdriftLTM= dbutil->GetVDriftTPCLaserTracks(dlm,run,timeStamp,36000,2);
+  //
+  ltime0A  = dbutil->GetLaserTime0(run,timeStamp,36000,0);
+  ltime0C  = dbutil->GetLaserTime0(run,timeStamp,36000,1);
+
+  (*pcstream)<<"dcs"<<  
+    //
+    "vdriftCEA="<<vdriftCEA<<
+    "vdriftCEC="<<vdriftCEC<<
+    "vdriftCEM="<<vdriftCEM<<
+    "dce="<<dce<<
+    "vdriftLTA="<<vdriftLTA<<
+    "vdriftLTC="<<vdriftLTC<<
+    "vdriftLTM="<<vdriftLTM<<
+    "dla="<<dla<<
+    "dlc="<<dlc<<
+    "dlm="<<dlm<<
+    "vdrift1="<<vdrift1;
+
 }
 
 
-void ProcessGoofie( AliDCSSensorArray* goofieArray, TVectorD & vecEntries, TVectorD & vecMedian, TVectorD &vecMean, TVectorD &vecRMS){
-  /*
-    
-  1       TPC_ANODE_I_A00_STAT
-  2       TPC_DVM_CO2
-  3       TPC_DVM_DriftVelocity
-  4       TPC_DVM_FCageHV
-  5       TPC_DVM_GainFar
-  6       TPC_DVM_GainNear
-  7       TPC_DVM_N2
-  8       TPC_DVM_NumberOfSparks
-  9       TPC_DVM_PeakAreaFar
-  10      TPC_DVM_PeakAreaNear
-  11      TPC_DVM_PeakPosFar
-  12      TPC_DVM_PeakPosNear
-  13      TPC_DVM_PickupHV
-  14      TPC_DVM_Pressure
-  15      TPC_DVM_T1_Over_P
-  16      TPC_DVM_T2_Over_P
-  17      TPC_DVM_T_Over_P
-  18      TPC_DVM_TemperatureS1
-   */
-  //
-  //
-  //  TVectorD  vecMedian; TVectorD  vecEntries; TVectorD  vecMean; TVectorD  vecRMS;
-  Double_t kEpsilon=0.0000000001;
-  Double_t kBig=100000000000.;
-  Int_t nsensors = goofieArray->NumSensors();
-  vecEntries.ResizeTo(nsensors);
-  vecMedian.ResizeTo(nsensors);
-  vecMean.ResizeTo(nsensors);
-  vecRMS.ResizeTo(nsensors);
-  TVectorF values;
-  for (Int_t isensor=0; isensor<goofieArray->NumSensors();isensor++){
-    AliDCSSensor *gsensor = goofieArray->GetSensor(isensor);
-    if (gsensor &&  gsensor->GetGraph()){
-      Int_t npoints = gsensor->GetGraph()->GetN();
-      // filter zeroes
-      values.ResizeTo(npoints);
-      Int_t nused =0;
-      for (Int_t ipoint=0; ipoint<npoints; ipoint++){
-       if (TMath::Abs(gsensor->GetGraph()->GetY()[ipoint])>kEpsilon && 
-          TMath::Abs(gsensor->GetGraph()->GetY()[ipoint])<kBig ){
-         values[nused]=gsensor->GetGraph()->GetY()[ipoint];
-         nused++;
-       }
-      }
-      //
-      vecEntries[isensor]= nused;      
-      if (nused>1){
-       vecMedian[isensor] = TMath::Median(nused,values.GetMatrixArray());
-       vecMean[isensor]   = TMath::Mean(nused,values.GetMatrixArray());
-       vecRMS[isensor]    = TMath::RMS(nused,values.GetMatrixArray());
+
+void ProcessKryptonTime(Int_t run, Int_t timeStamp){
+  //
+  // Dumping  krypton calibration results
+  //
+  static TObjArray * krArray=0;
+  if (!krArray) {
+    AliCDBEntry* entry = AliCDBManager::Instance()->Get("TPC/Calib/TimeGainKrypton", run);
+    if (entry){
+      krArray = (TObjArray*)entry->GetObject();
+    }
+  }
+  static TVectorD krMean(74);
+  static TVectorD krErr(74);
+  static TVectorD krDist(74);
+  TGraphErrors *gr=0;
+  Double_t deltaT=0,gry=0;
+  if (krArray){
+    for (Int_t isec=0; isec<72; isec++){
+      krMean[isec]=0;
+      krDist[isec]=0;
+      krErr[isec]=0;
+      gr=(TGraphErrors*)krArray->At(isec);
+      if (gr) {
+       krMean[isec]=gr->Eval(timeStamp);
+       AliTPCcalibDButil::GetNearest(gr, timeStamp,deltaT,gry);
+       krDist[isec]=deltaT;
+      }     
+      if (72+isec<krArray->GetEntries()) {
+       gr=(TGraphErrors*)krArray->At(72+isec);
+       if (gr) krErr[isec]=gr->Eval(timeStamp);
       }
     }
+    krMean[72]= TMath::Median(36,krMean.GetMatrixArray());
+    krMean[73]= TMath::Median(36,&(krMean.GetMatrixArray()[36]));
+    krErr[72]= TMath::Median(36,krErr.GetMatrixArray());
+    krErr[73]= TMath::Median(36,&(krErr.GetMatrixArray()[36]));
   }
+  (*pcstream)<<"dcs"<<
+    "krMean.="<<&krMean<<
+    "krErr.="<<&krErr<<
+    "krDist.="<<&krDist;
 }
 
-/*
 
-AliDCSSensor * sensorPressure = AliTPCcalibDB::Instance()->GetPressureSensor(62084);
-entry = AliCDBManager::Instance()->Get("TPC/Calib/Temperature",run);
-AliTPCSensorTempArray * tempArray = (AliTPCSensorTempArray *)entry->GetObject();
-AliTPCSensorTempArray * tempArray = (AliTPCSensorTempArray *)AliTPCcalibDB::Instance()->GetTemperatureSensor(62084)
-AliTPCTempMap * tempMap = new AliTPCTempMap(tempArray);
-TLinearFitter * fitter = tempMap->GetLinearFitter(0,0,tempArray->GetStartTime()->GetSec());
 
-AliDCSSensorArray* goofieArray = AliTPCcalibDB::Instance()->GetGoofieSensors(62084);
 
-*/