r1 - 24 Feb 2006 - 16:45:29 - HongMaYou are here: TWiki >  AtlasSoftware Web > DataBaseServerForAthena



Typical Athena jobs require access to data that resides in database server. Currently two databases are used: Geometry database for building ATLAS detector description (GeoModel), and conditions database for LAr conditions data. The ATLAS Distributed Database Services web page describes the database operation. The primary servers are at CERN, and BNL provide replica database. The load of the replica databases can be viewed by the monitoring site.

The default Athena jobOptions are set up for using the CERN databases. To switch to the BNL replica, the following steps should be followed.

Geometry Database

The primary database at CERN is an Oracle server. The replica at BNL (a few other sites) are MySQL database. To switch to use the BNL local replica (dbdevel1.usatlas.bnl.gov), add the following python statements at the end of your jobOptions:

RDBAccessSvc = Service( "RDBAccessSvc" )
RDBAccessSvc.Technology = "mysql"
RDBAccessSvc.HostName = "dbdevel1.usatlas.bnl.gov"
RDBAccessSvc.SchemaName = "ATLASDD"
RDBAccessSvc.UseDBConnSvc = False

Conditions Database

The current conditions database (for release 11) is MySQL based. The server at CERN is atlasdbdev.cern.ch and atlasdbpro.cern.ch, and the server at BNL is db1.usatlas.bnl.gov. To switch to use the BNL local replica, add the following python statement at the beginning of the jobOptions:

LArCondCnvDbServer = "db1.usatlas.bnl.gov"

-- HongMa - 24 Feb 2006

About This Site

Please note that this site is a content mirror of the BNL US ATLAS TWiki. To edit the content of this page, click the Edit this page button at the top of the page and log in with your US ATLAS computing account name and password.


Powered by TWiki
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback