Online Databases Status

• Oracle 8i Servers, release 8.1.7.3

• Platform: Compaq Tru64 UNIX V5.1 (Rev. 732)

• Production DB d0onprd, on d0olc, 64 users, 34Gb allocated, 15Gb used 79Gb disk space available, RAID-1

• Development DB d0on, server on d0olb, 105 users, 24Gb allocated, 4Gb used 36Gb disk space available, RAID-1

V.Sirotenko, 11/1/2002

User Applications

Platforms: Linux,OSF1 Unix,Windows

d0onprd:1) Detectors calibration and download APIs with online

to offline transfer tools ( smt,cft,muon,cal )2) EPICS hardware database (HDB) toolkit3) RUNS database APIs : runGrabber/runPusher4) Monitoring daemon: dbMonitor

d0on: • Solenoid Hall probes DB API (solGrabber)• FPD pot position/alarms DB API• historyDB (hisDB) toolkit : slow EPICS archiver

Major schemas and tablespace usage in d0onprd

TABLESPACE USED MB FREE MB TOTAL PERCENT USED------------------------------ ---------- ---------- ---------- -------------------------------------------------------------------------------CAL_CALIB 3006 994 4000 75CFT_CALIB 2942 1058 4000 74HDB_01 196 304 500 39MUON_CMSC_CALIB 6 194 200 3MUON_FMSC_CALIB 12 188 200 6MUON_MDT_CALIB 3 197 200 2MUON_PDT_CALIB 8 192 200 4RUNS 389 1611 2000 19SMT_CALIB 6387 2612 9000 71

Tablespace size dynamics

Tablespace size dynamics (2)

Backup strategy

• Oracle Backup: /db/backup 142 Gb available - d0onprd

- rman ( every day, keep 3 days, 1 set = 21 Gb )- export (every other day, keep 2 days, 6 Gb each )

- d0on- rman ( every day, keep 3 days, 1 set = 7 Gb )

• Backup to tape: DLT8000 tape drive mounted in a automated tape library with a 26 tape capacity in two 13 tape cartridges, almost 2 weeks of unattended backup Tape pool – 200 tapes, 12 week (3 month) rotation

- full backup : /db (every Friday, 2 tapes) (d0onprd)/usr (every Monday, 1 tape) (d0on)

- incremental: every day- every 3 months week long backup is kept forever

Performance: d0onprd

Use Statspack Viewer 8.1.7 to monitor performance, every two weeks plots are posted on the web ( Online Computing)

Performance: d0onprd (2)

Performance: d0onprd (3)

DB access software currently supported

1) From Python: Dcoracle and Dcoracle2 2) From C++ : d0om_oracle

It’s OK if user is using d0om, but if not?

For online people use mostly python, but sometime there isa need to access DB from C/C++ programsShould we consider to provide support to users from generic C++ based on OTL (Oracle Template Library) ?Or OCI library?

MisWeb: add graphics capability (?)