Case Study: a leading insurance firm achieves zero-downtime DB2-to-Oracle migration with Daffodil Software

a leading insurance firm migrates 60TB to Oracle 19c with Daffodil Software

The customer, India's Leading Insurance Firm, faced significant operational challenges due to its outdated EMC Documentum content management system struggling with a daily influx of documents. The system's inefficiencies, powered by a DB2 database, caused slow response times and bottlenecks. Daffodil Software was engaged to upgrade the content management system and migrate 60 TB of content data from DB2 to Oracle, all while ensuring zero downtime for the mission-critical application.

Daffodil Software executed a comprehensive upgrade of the Documentum Content Server and WebTop to version 20.2 and successfully migrated the massive database to Oracle 19c. The solution included building an in-house utility for data migration and integrating a Captiva scanning tool to automate document processing. The project was completed with 100% system uptime and 0% data loss. The new system eliminated previous bottlenecks, significantly enhanced day-to-day operations, and optimized performance, positioning the client as a more responsive and efficient insurance provider.