RDB Tools at TRIUMF/ISAC

1
RDB Tools at TRIUMF/ISAC
R. Keitel IRMIS Workshop, APS, 9-Mar-2005
2
Outline

• EPICS environment
• Current RDB use
• What next?
• Wish-list

3
State of ISAC

• half way
• ISAC-I routine operation
• ISAC-II start installation
• no change in man-power (6)
• tools are vital

4
EPICS Environment at ISAC

• EPICS 3.13.10
• EPICS 3.14.6 (softIOC, gateway)
• vxWorks 5.5 (MV162, 486, Pentium)
• Capfast
• Edd/dm gtgtgt Edm
• Trar archiver
• Striptool, alh,
• IOCs
• 20 gtgt25 ( ISAC)
• 10 (other systems)
• 80k EPICS records

5
EPICS Environment (2)
Development Solaris
Production file servers Solaris
User display servers Linux
Operator consoles Linux
User consoles Windows, Linux (X-servers)
RDB server Linux
Web server Linux
6
Relational Database
Web Application
RDB devices
Perl Tools
EPICS configuration files
7
Basic Ideas

• Collaborating tools
• Loose coupling
• Minimize mission-critical items

Web Servers
Database Servers
Development Computers
Production File Servers
8
Relational Database (PostgreSQL)

• Device classes
• Capfast
• I/O ports
• Macros
• Device instances
• Hardware addresses
• Macros
• interlocks
• Hardware info
• PLC drops
• VME crates
• IOC info
• Boot area etc.

9
Usage (RDBTools)

• generate Capfast schematics (device
  instantiation)
• generate dm device control panels
• Interlock display
• hyperlinks to other device control panels
• store interlock specs
• verify interlock implementation against spec
• build configuration scripts
• generate html-documentation
• manage IOC configuration and roll-back
• database crawler (off-line no db)
• adl file crawler (no db)
• Interaction with other databases (QA, operations)

10
Whats next (missing)

• Configuration scripts?
• Request files?
• Cables etc.
• Device locations
  IRMIS?
• Integrate with asset RDB

11
Wish List

• We will not abandon our system
• Need add-on to our system
• Or coexistence
• Tool-kit for picking and choosing
• Portability between SQL RDBs
• Web interface
• Smooth transition from design gtgt IRMIS