File indexing completed on 2024-04-06 12:23:19
0001
0002
0003 pedestalsTag=test_SiStripPedestals_TKCC_20X
0004 noiseTag=test_SiStripNoise_TKCC_20X
0005 cabTag=test_SiStripFedCabling_TKCC_20X
0006 authPath=/nfshome0/xiezhen/conddb/
0007 connectString="oracle://cms_orcon_prod/CMS_COND_20X_STRIP"
0008
0009 log=log_at_P5
0010 rm -rf $log
0011 mkdir $log
0012
0013 eval `scramv1 runtime -sh`
0014
0015 export TNS_ADMIN=/nfshome0/xiezhen/conddb/
0016
0017
0018
0019 sqlplus -S -M "HTML ON " cms_trk_tkcc/tkcc2008@cms_omds_lb < OMDSQuery.sql | awk 'BEGIN{newline=0; stringa=""} $0~/<*th.*>/{newline=0} $0~/<tr>/{newline=1;if(stringa!="") print stringa; stringa=""} $0~/<\/tr>/{newline=0;} $0!~/<?td.*>/{if(newline && $0!="<tr>"){stringa=sprintf("%s %s",stringa,$0)}}' | sort -n| while read line;
0020 do
0021 vec=($line)
0022 echo ${vec[@]}
0023 runNb=${vec[0]}
0024
0025 partition=${vec[2]}
0026 fecV=${vec[3]}
0027 fedV=${vec[4]}
0028 cabV=${vec[5]}
0029
0030 echo $runNb $partition $fecV $fedV $cabV
0031
0032 fedVMaj=`echo $fedV | cut -d "." -f1`
0033 fedVmin=`echo $fedV | cut -d "." -f2`
0034
0035 fecVMaj=`echo $fecV | cut -d "." -f1`
0036 fecVmin=`echo $fecV | cut -d "." -f2`
0037
0038 cabVMaj=`echo $cabV | cut -d "." -f1`
0039 cabVmin=`echo $cabV | cut -d "." -f2`
0040
0041 echo $fedVMaj $fedVmin
0042 cat template_sistripo2o.cfg | sed -e "s@insert_Run@$runNb@g" -e "s@insert_ConfigDbPartition@$partition@g" -e "s@insert_cabmajor@$cabVMaj@g" -e "s@insert_cabminor@$cabVmin@g" -e "s@insert_fedmajor@$fedVMaj@g" -e "s@insert_fedminor@$fedVmin@g" -e "s@insert_fecmajor@$fecVMaj@g" -e "s@insert_fecminor@$fecVmin@g" -e "s@insert_authPath@$authPath@" -e "s@insert_pedestals_tag@$pedestalsTag@" -e "s@insert_noise_tag@$noiseTag@" -e "s@insert_cabling_tag@$cabTag@" -e "s@insert_connect_string@$connectString@" > $log/siStripO2O_$runNb.cfg
0043
0044 cmsRun $log/siStripO2O_$runNb.cfg > $log/siStripO2O_$runNb.log
0045 done