Skip to content

Replacing Legacy Database Reduces Licensing Costs & Improves Batch Performance for State Agency

What we achieved together


batch performance increase


months project completed

The Client

The client is the Social Services Agency for a US state government. 

The Obstacles Faced

The Social Services Agency needed to web-enable its Title IV-D Child Support program. To help accomplish this project, the client needed to eliminate the IMS database and associated licensing costs while maintaining the batch performance for this high visibility system. A more flexible, high availability database was desired, with all COBOL and Telon programs using IMS to be converted to Db2.

The Journey

We completed an assessment, designed a new Db2 database schema and developed a migration plan to replace IMS navigation with SmartSQL™.  The 1,500 programs were updated and fully tested. This approach minimized risks and increased batch performance by 34%. The conversion project was completed on time and on budget and afterwards the project sponsor described the process as:

Outcomes Achieved

  • IMS database and licensing eliminated
  • Batch performance increased by 34%
  • Project completed on budget in 20 months

Technical Specifications

  • Redesign of IMS data schema to a Db2 relational model
  • Converted 800 COBOL IMS database programs, and 700 COBOL/IMS/Telon programs to use new Db2 relational database
  • IMS database and IMS navigation replaced with SmartSQL™ and Db2

Don’t miss the latest from Ensono


Get more client success stories like this

Start your digital transformation today.