1 / 21

Modernizing Child Welfare Database: Driving Transformation with Technology

Explore the journey of migrating the Child Welfare Database to modern technology, from Powerbuilder thick client with Oracle backend to Linux on z/VM, facing challenges and reaping benefits along the way.

taylorh
Download Presentation

Modernizing Child Welfare Database: Driving Transformation with Technology

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oklahoma Department of Human Services Child Welfare Database Migration

  2. Or

  3. How to Drive Oneself CrazyandStill Have Fun

  4. The KIDS Systemas of Autumn 2000 • Powerbuilder thick client with Oracle backend • HP9000 T-500 6 90 Mhz PA-RISC 7100 CPUs • Hard drives at the end of support life • SCSI attached RAID • HP-UX 10.20 • Oracle 7.3.4 • Supports 600+ users • Token Ring

  5. The Original Plan • Upgrade hardware to modern HP hardware • Dual processor PA-RISC 8500 • Failover system (MC/Serviceguard) • Fibre attached SAN (va7100) • Bonded 100mb ethernet

  6. HP Positives • Uptime measured at 99.999% • Increased disk throughput • Increased processing capacity • 64 bit operating system

  7. HP Negatives • Expensive support • Idle CPU cycles • Multiple hardware platforms • Multiple DASD platforms

  8. An Unrelated Project? It’s time to upgrade that ole mainframe thing-a-majig

  9. IBM Makes a Proposal Shhhh! Chris likes it!

  10. Linux?

  11. IBM’s Proposal • Apply money allocated to KIDS upgrade to z/900 purchase • Purchase two IFL’s for z/VM and Linux • Offer a lot of help

  12. IBM Positives • Consolidation of hardware • Single source for support • Hardware reliability • Utilize existing storage infrastructure • z/VM allows for better resource management • Leverage tight pocketbook

  13. IBM Negatives • Oracle RDBMS not yet available for production • Linux relatively unproven in mission critical environments • No failover capability • Scalability concerns • Management uneducated about Linux

  14. The Decision . . .

  15. The Decision . . . Is Linux

  16. Issues encountered • Database corruption • 2000/4000 character field • 31 bit 2 gigabyte limit • Online backup solution • Sysadmin education • User education • Management education

  17. Positives encountered • Oracle is Oracle • Applicability of existing Unix knowledge • Linux is configured more securely • Management becomes more open to Linux solutions • Fundamental changes in recovery and security concepts

  18. Two years later . . .

  19. Final migration scheduled for April 10, 2004

  20. After the Migration • z/VM 4.4 • Oracle 10g • Availability • RAC • Response

More Related