Displaying items by tag: db2

Educational Testing Service (ETS) is the world's largest private educational testing and measurement organization. Each year, they develop, administer,  and score more than 50 million tests, including the TOEFL®, TOEIC®, GRE®, and Praxis® tests, in more than 180 countries. This requires an enormous data management capability. ETS turned to TSRI to transform their ECT and Praxis applications and databases from IBM job control language (JCL) and COBOL Batch to modern Java SE 17 in a cloud-native optimized AWS environment. To do this, they used a spring boot-type application to implement web services invoked by Python. TSRI also converted the IBM DB2 database and VSAM sequential database files to a relational PostgreSQL database on AWS Aurora.

Customer: Educational Testing Service (ETS)

Source & Target Language: IBM COBOL to Java SE 17 on AWS

Lines of Code: 1,199,633 lines of COBOL and JCL

Duration:  11 Months

Services: Automated Code Transformation, Automated Refactoring, Integration and Testing Support, SonarQube Quality Refactoring, Code-Specific Adaptation, Database Migration, Transformation "To-Be" Blueprint®, Application "As-Is" Blueprint®, Code Warranty

 

 

Published in Case-Studies

CRA and AWS engaged with TSRI to complete the modernization of their COBOL-based system to Java on AWS. To Achieve CRA's goals, TSRI tuned JANUS Studio® to parse, transform, document, and refactor the IBM z/OS COBOL application. In just 1.5 months, TSRI modernized the application from an IBM Mainframe COBOL and CICS monolith to a modern multi-tier architecture in Java on the AWS cloud. Just as important, TSRI also converted the DB2 database and VSAM sequential files to a relational PostgreSQL database on AWS Aurora.

Customer: Canada Revenue Agency (CRA) and AWS

Source & Target Language: IBM COBOL to Java on AWS

Lines of Code: 168,000

Duration:  1.5 Months

Services: Automated Code Transformation, Automated Refactoring, Integration and Testing Support, SonarQube Quality Refactoring, Code-Specific Adaptation, Database Migration, Transformation "To-Be" Blueprint®, Application "As-Is" Blueprint®

 

 

Published in Case-Studies
Wednesday, 30 March 2022 13:43

PL/1 & JCL to C# - KMD e-Boks

Originally developed by Denmark-based KMD in 2001 as a mainframe software application, the e-Boks system became more difficult and costly to maintain over time. The original platform also lacked the agility to expand to additional countries at scale and was not agile enough to expeditiously react to business changes. TSRI and KMD were able to modernize the e-Boks application from its original IBM PL/1 legacy code in a monolithic architecture to a modern, multi-tier application in a modern computing environment, running .NET, with no impact on the business and end-user experience. As a result, e-Boks has the potential to save more than 50-60 percent per year in operations and maintenance costs.

Customer: KMD and The Government of Denmark

Source & Target Language: PL/1 & JCL to C#

Lines of Code: 974,201 (781,893 - PL/1 and 192,308 - JCL)

Duration:  6 Months

Services: Transformation Blueprint®, Automated Code Transformation, Automated Refactoring, Integration and Testing Support

 

 

Published in Case-Studies
Wednesday, 30 March 2022 13:43

COBOL & JCL to Java & Python - Deutsche Bank KM

Deutsche Bank's relatively reliable mainframe infrastructure utilized COBOL and JCL languages running DB2 and VSAM flat-file databases for a variety of their key financial applications. The company’s leadership knew they would need to be cloud-enabled with a modern architecture to stay relevant for its customers and ongoing market needs. Following a successful proof of concept against other well-known industry soluitons, TSRI emerged as the best solution (highest quality output and most advanced architecture) for the full modernization effort of Deutsche Bank’s internal KreditManager application. An application which gives the company’s employees all of the tools they need to handle all of the company’s loan, credit and mortgage applications.

Customer: Deutsche Bank

Source & Target Language: COBOL & JCL to Java & Python

Lines of Code: 397,222 (383,358 - COBOL, 13,864 - JCL)

Duration:  12 Months

Services: Automated Code Transformation, Automated Refactoring, Integration and Testing Support, SonarQube Quality Refactoring, Code-Specific Adaptation, Database Migration, Transformation Blueprint®, Application "As-Is" Blueprint®

 

 

Published in Case-Studies

One of the largest Japanese Car Manufactures now uses TSRI’s modernization methods to increase efficiency in their manufacturing systems. With the help of systems integrator Comture Corporation, TSRI was able to successfully transform 120k lines of COBOL to Java, in a three-week time-period, with over 99% automation levels. 

  • Customer & Integrator: Comture Car Manufacturer
  • Source & Target Language: COBOL to Java
  • Lines of Code: 120,000
  • Duration:  1 month
  • Services: Code Transformation from Multiple Legacy Languages, Automated Refactoring, Installation and Testing Support, Transformation Blueprint®​

 

 

Published in Case-Studies

With maintenance costs increasing for the national crime information tracking system, a significant portion of the agency's crime fighting budget was required for hiring staff with experience maintaining mainframes, non-adherence to the Common Operating Environment (COE) adding to costs, and aging technology (IBM Mainframe, DB2, CICS, CA-GEN, COBOL, Assembler, C, MQ Series, JCL) making enhancements difficult to perform, the nation crime fighting agency initiated a Legacy Migration study to assess migration from the current legacy application architecture to an open Java/JEE application architecture.

Customer:  Criminal Justice Information Services Division

Source & Target Language: Coolgen/COBOL to Java/JEE

Lines of Code: 4.3 Million

Services: Tuned JANUS Studio® to customer code, Coolgen/COBOL and C to Java/JEE Code Transformation, Coolgen/COBOL and C to Java/JEE Transformation Blueprint®

 

Published in Case-Studies