HEPDB


Last update - 12th May 1999. Y2K - Problems

This page describes some general details concerning the HEPDB service at CERN.

For information regarding the use of the HEPDB package itself, please see the HEPDB documentation.

See also the old (no longer maintained) web pages here

Introduction

The HEPDB service is run on an IBM machine, with nodename hepdb.cern.ch.

The various HEPDB catalogs are kept on the /hepdb filesystem, which is NFS-exported and should be NFS-mounted on any system requiring access to the HEPDB catalog.

For each experiment (e.g. CHORUS, NOMAD, WA97 etc.) there is a subdirectory which contains the catalog for that experiment and associated configuration files, e.g.

sp019:/hepdb/cdwa97 # ls -F       
bad/            cdsrv@          l6.dbs          p6.dbs          tocatania/      tohadron/       toriscom/       tovm/
cdserv*         hepdb.err       log/            p7.dbs          tocrnhp3/       tohp18/         tors320h/
cdserv.log      hepdb.names     or.dbs          queue/          todo/           tohpfpd/        tosalerno/
cdserv.oldlog   l5.dbs          p5.dbs          save@           toephp1/        toral/          tosophia/
The purpose of each of these files is described below.

List of contacts (where knownn)

Trouble-shooting

Currently, HEPDB runs on a RS6000 machine, shared with FATMEN. The node name is shd15 with aliases fatcat and hepdb.

Any user may request a restart of a server by creating a signal.start file in the todo directory for their experiment.

e.g. to restart the server for NOMAD, type:

touch /hepdb/cdnomad/todo/signal.start


The following information is for service managers only.

  • Occasionally, servers do not restart after the nightly online backup. Restart them manually by removing the corresponding signal.stop file and running cdstart. A user may also request a restart by creating a signal.start file, in which a cron job will perform the restart.

  • Disk full

    Free or buy some disk space.

  • RZ quota exceeded.

    Change the RZ record size. Best left to an expert.

    An example (for FATMEN) can be found here.
    (To create the final RZ file in exchange mode in the "NEW" format (see ZEBRA manual under RZMAKE), use CHOPT='XN').

  • RZ corruption.

    Restore the more recent online backup from /cdback/cd{experiment}/*.good

    Then 'mv' the necessary update files from /hepdb/cd{experiment}/save to /hepdb/cd{experiment}/todo and restart the server.

    If surgery is required on the RZ file, best wait for an expert.

  • Changes in the distribution policy

    Best wait for an expert.

    Explanation of HEPDB files

    HEPDB programs and scripts

    These are kept in the directory /afs/cern.ch/project/hepdb/@sys/bin and /afs/cern.ch/project/hepdb/scripts.

    Programs

    ls /afs/cern.ch/project/hepdb/@sys/bin
    cdbackup  cdmove    cdsrv
    

    Scripts

    The scripts contain a brief comment explaining their function and are described in the user documentation.

    Many are run from cron as user root.

    #
    # Backup database files
    #
    0 23 * * * /afs/cern.ch/project/hepdb/scripts/cdbackup.sh > /dev/null 2>&1
    #
    # Look for servers that are stopped
    #
    0 8 * * * /afs/cern.ch/project/hepdb/scripts/cdchk > /dev/null 2>&1
    #
    # More powerful check
    #
    20 * * * * /afs/cern.ch/project/hepdb/scripts/cdcheck > /dev/null 2>&1
    #
    # Check for backlogs
    #
    # TGB - fixed syntax error
    #
    0 0 * * * /afs/cern.ch/project/hepdb/scripts/cdqueue > /dev/null 2>&1
    #
    #
    # Special check for cdmove
    #
    30 * * * * /afs/cern.ch/project/hepdb/scripts/cdmovechk >> /tmp/cdmovechk.log 2>&1
    

    Y2K Information

    Like many CERNLIB programs, HEPDB relies on the DATIME routine to handle dates and times. As is described here, this routine returns the date in YYMMDD format through the argument list.

    Calibration data entered into HEPDB are given a validity range that consists of one or more pairs of integers. HEPDB makes no assumptions as to these integers - they may be start and end run, run and event, time or any other range.

    HEPDB stores the insertion time of each entry in a packed format. The insertion time may be overridden by the user, but by default is obtained using the DATIME routine described above.

    Modifications to support Y2K have been received from Rob Komar and tested. Thanks Rob!


    Last update by CERN Program Library