Skip to content

Post-processing of DA simulations

The postprocessing of the DA simulation can be done with SixDeskDB, a python tool to post-process SixTrack DA simulations and store key results in a dedicated sqlite database. To use SixDeskDB, we first load some environmental variables:

source /cvmfs/sft.cern.ch/lcg/views/LCG_97python3/x86_64-centos7-gcc9-opt/setup.sh

Now we navigate to the location where our studies are saved:

cd /afs/cern.ch/work/p/pahermes/private/005_DA_simulations/wTest/sixjobs

Let's assume we have retreived back the output of a study with the name ats2018test and we want to load it into a SixDeskDB database. First, we run the following command:

/afs/cern.ch/work/s/sixtadm/public/SixDesk_utilities/v2.1.4TMP/utilities/bash/sixdb.sh studies/ats2018test/ load_dir

The executable sixdb.sh serves as a control script for the tasks performed by the SixDeskDB python scripts. If all goes well, the output looks similar to this:

Opened ats2018test.db successfully
Inserting or updating 104 variables
Looking for fort.2, fort.8, fort.16 in /afs/cern.ch/work/p/pahermes/private/005_DA_simulations/sixtrack_input/wTest/ats2018test
found mad run mad.mad6t.sh.lxplus711.cern.ch.05m8FP
 number of fort.2 updated/found: 60/60
 number of fort.8 updated/found: 60/60
 number of fort.16 updated/found: 60/60
Looking for betavalues, sixdesktunes, general_input in
 /afs/cern.ch/work/p/pahermes/private/005_DA_simulations/wTest/track/ats2018test
 number of sixdesktunes, betavalues inserted: 60
Looking for fort.3.gz, fort.10.gz, fma_sixtrack files in
 /afs/cern.ch/work/p/pahermes/private/005_DA_simulations/wTest/track/ats2018test
..........................
 number of fort.3 updated/found: 2640/2640
 number of fort.10 updated/found: 2640/2640
 number of fma_sixtrack updated/found: 0/0
 db now contains 79200 results from 2640 jobs
 db now contains 0 fma from 0 jobs

SixDeskDB has now created a file named ats2018test.db. We can now get the DA by running sixdb.sh again with the following arguments:

/afs/cern.ch/work/s/sixtadm/public/SixDesk_utilities/v2.1.4TMP/utilities/bash/sixdb.sh ats2018test.db da

We can open the .db file by using sqlitebrowser in a linux environment.

Versioning

Last updated 18.03.2021 by P. Hermes