RDB Use at TRIUMF/ISAC

1
RDB Use at TRIUMF/ISAC
R. Keitel Epics Collaboration Meeting, SLAC,
27-Apr-2005
2
State of the ISAC Radioactive Beam Facility

• half way
• ISAC-I routine operation (1.5 MeV/u)
• ISAC-II start installation (SC linac two phases
  gtgt 6.5 Mev/u)
• no change in controls man-power (6 EPICS)
• tools, tools, tools,

3
EPICS Environment at ISAC

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

4
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
5
RDB - Basic Ideas

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

Web Servers
Database Servers
Development Computers
Production File Servers
6
RDB Tools
Web Application
RDB devices
Perl Tools
EPICS configuration files
7
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.

8
WebApp integrates RDBTools

• generate top-level Capfast schematics (device
  instantiation)
• generate dm device control panels
• Interlock display
• hyperlinks to other device control panels
• verify interlock implementation against
  specification
• build configuration scripts (CAN-bus, setpoint
  restore, ..)
• generate html-documentation (VME channels)
• manage IOC configuration and roll-back

9
IOC configuration / rollback
SUN (development)
SUN (production)
Untested code
Test Area
Boot Area
Development Area
- previous3
- previous2
- previous1
Bootconfigure Tool
- current
Firewall
boot
IOC
10
Bootconfigure Tool (Perl integrated in WebApp)
SUN (production)
Boot Area
update boot area
roll back
- previous3
Test Area
3
1
- previous2
4
2
2
- previous1
3
1
Bootconfigure Tool
4
- current
11
WebApp integrates RDBTools

• generate Capfast schematics (evice instantiation)
• generate dm device control panels
• Interlock display
• hyperlinks to other device control panels
• verify interlock implementation against
  specification
• build configuration scripts (CAN-bus, setpoint
  restore, ..)
• generate html-documentation (VME channels)
• manage IOC configuration and roll-back
• Interaction with other databases (QA, operations)
• .db crawler (off-line no RDB)
• adl file crawler (no RDB)

12
Whats next (missing)

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