SNS EPICS Config. Database

1
SNS EPICS Config. Database

• Control System Configuration DB Workshop,Sep.
  6-8 _at_ Jlab
• participants from BESSY, BNL, JLab, PSIIOC DB
  meeting,Oct. 2-3 _at_ LANLSmita Sathe, BNL, Jeff
  Patton, ORNLRozelle Wright, Deb Kerstiens, Bob
  Dalesio, Kay Kasemir, LANL

2
Issues

• SNS-wide approach for Names, Power Supplies,
  Magnets, Optics, .
• Can eventually create EPICS DB, but when?
• Similar approach BESSY
• Can create .DB from RDB device info
  templates/knowledgeable scripts, but full EPICS
  record information is not in RDB, not even record
  names which are useful for configuring archiver,
  save/restore, reports, ...

3
Put EPICS .DB in RDB

• Doesnt contradict later SNS-wide RDB
• Experience on LEDA (Bob Dalesio, Lisa Day)
• Tabular view allows rapid data entry
• RDB helpful for setting e.g. limits of related
  records at once
• RDB provides reports signal lists, used/unused
  HW
• Problem How to include external sources, e.g.
  Capfast schematics, and keep track of changes to
  both external source and RDB?

4
EPICS RDB Idea
Device RDB
Capfast template
emacs, vi, ...
lt?gt
SQL,perl-DBIJDBC
script
.DB
.DB
.DB
EPICS RDB reports, define missing fields, ...
.DB,maybe startup, dbd
IOC
IOC
IOC
5
EPICS RDB Tables

• IOC id/name, location, IP, (Smitas
  definition)
• EPICS_LOGIC id/name, ioc_id, description
• defines a collection of records (device, app., )
• EPICS_RECORD_TYPE, EPICS_FIELD_DEF, .._MENU
• Describe record types fields, from DBD, for GUI
  tools
• EPICS_RECORD, EPICS_FIELD
• Instance definitions. Important details
• record belongs to logic
• record has external_source
• each field has external_value from import into
  RDB and internal_value that can be changed to
  overwrite ext. val.

6
Perl Scripts

• List/add/remove IOCs, Logics
• Create DB file for IOC or Logic
• In progress
• Read DBD files from EPICS/base to have full
  record definitions in RDB
• Read/write selected records as table to allow
  spreadsheet import/export

7
Java GUIs

• Single Record,all fields editor
• see source,int. ext. value
• Multiple. Recs,selected fields
• rapid entry
• color coded