# Presentation: 545734

## Support DatabasesStatus, July 2000

- Support Databases Joint Project since the last status report – Julie
- D0 databases and applications - Lee
- CDF databases and applications – Rick
- CDF online dba report - Umesh
- D0 online dba report – Stu
- Plans and Issues - Ruth

## First:

- Appreciation to all who are working on the project.
- Much hard work and progress by everyone.
- Collaborations collaborate.

## Plans:

- Need to continue Projects 1⁄2 time until end of 2000.
- Must stick to schedule of review of designs  in the fall
- And isolation tests at the end of the year
- And Recovery testing and scenarios monthly

- Stress on immediate support needs
- Takes commitment and time
- Will take man months to accomplish
- Will require some planned database down time

- Issues:

## 		2001Plans:		Issues:

- Review and update operational procedures
- Tuning and monitoring of all databases
- Planning for capacity during datataking
- Execute problem scenarios
- Another status report in January

- Not enough DBA manpower. When Nelly/Diana is on vacation and Diana/Nelly are sick.
- No capacity for “just in time” requirements from experiments.
- No manpower for support of offsite distribution and databases

## July
CDF Machines installation
Very Large database testing 
Extend monitoring scripts
August 
CDF machine deployment for commissioning run
CDF emphasis on online for commissioning run.
Very Large database testing 
Consultant to review very large database plans 
Dba tools includeing 24x7 guidelines and needsl toolman, dbclone
Development OEM testing
September 
CDF Consultant – replication online/offline
upgrade to 8.1.6 D0 offline if legato, sqlloader and dcoracle problems solved.
Switch D0 offline machines  
review of backup strategy 

- CDF Machines installation
- Very Large database testing
- Extend monitoring scripts
- August
- CDF machine deployment for commissioning run
- CDF emphasis on online for commissioning run.
- Very Large database testing
- Consultant to review very large database plans
- Dba tools includeing 24x7 guidelines and needsl toolman, dbclone
- Development OEM testing
- September
- CDF Consultant – replication online/offline
- upgrade to 8.1.6 D0 offline if legato, sqlloader and dcoracle problems solved.
- Switch D0 offline machines
- review of backup strategy

## October
Operations, Validation of Support and Standards – schema evolution and application production cuts – expedite needed updates and upgrades.
D0 advanced queuing in production instances  - need Online work.
Prepare for Oracle review
Postmortems of database down times.
November 
Operations
Prepare for isolation tests
Prepare for Failover testing 
Review by Oracle of databases, 2-3 day workshop. 
December 
D0 partitioning and test databases
Test of isolation of FCC from Online machines.
Failover testing. 
Tuning 
Recovery testing 

- Operations, Validation of Support and Standards – schema evolution and application production cuts – expedite needed updates and upgrades.
- D0 advanced queuing in production instances  - need Online work.
- Prepare for Oracle review
- Postmortems of database down times.
- November
- Operations
- Prepare for isolation tests
- Prepare for Failover testing
- Review by Oracle of databases, 2-3 day workshop.
- December
- D0 partitioning and test databases
- Test of isolation of FCC from Online machines.
- Failover testing.
- Tuning
- Recovery testing