[Halld-offline] Farm jobs should use SQLite form of the CCDB

[Mark Ito]

Folks,

I have updated a section of the wiki page on the SQLite form of the CCDB 
at 
https://halldweb.jlab.org/wiki/index.php/SQLite-form_of_the_CCDB_database 
. Find the updated section is reproduced below.

  - Mark

__________________


    Nightly generated SQLite files

An new SQLite database is created at midnight. The latest version is 
available for download from the web at

https://halldweb.jlab.org/dist/ccdb.sqlite  .

This file is on the disk at JLab at

/group/halld/www/halldweb/html/dist/ccdb.sqlite .

To use the file with your JANA-based program at JLab

setenv JANA_CALIB_URL sqlite:////group/halld/www/halldweb/html/dist/ccdb.sqlite

for C-shell and

export JANA_CALIB_URL=sqlite:////group/halld/www/halldweb/html/dist/ccdb.sqlite

for Bourne shell. *Using the SQLite form of the CCDB is important when 
you run multiple farm or grid jobs.* Otherwise the MySQL database server 
gets overwhelmed (too many connections).

Older versions of the CCDB can be found at JLab in 
/group/halld/Software/calib/ccdb_sqlite . See the section below 
<https://halldweb.jlab.org/wiki/index.php?title=SQLite-form_of_the_CCDB_database&printable=yes#Archive_of_SQLite_Files> 
on archiving old versions for more details on what is stored there.


-- 
Mark Ito, marki at jlab.org, (757)269-5295

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/halld-offline/attachments/20170926/bc373aba/attachment.html>