<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://mainframemigration.org/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Metalogic Systems</title><link>http://mainframemigration.org/blogs/metalogic_systems/default.aspx</link><description /><dc:language>en</dc:language><generator>CommunityServer 2.1 (Build: 60803.893)</generator><item><title>Application migration from Hitachi mainframe to IBM AIX platform for an automobile major in Japan </title><link>http://mainframemigration.org/blogs/metalogic_systems/archive/2008/08/07/Application-migration-from-Hitachi-mainframe-to-IBM-AIX-platform-for-an-automobile-major-in-Japan-.aspx</link><pubDate>Wed, 06 Aug 2008 12:27:00 GMT</pubDate><guid isPermaLink="false">f4c3e5da-e6c5-42b1-ad1c-f6005d509669:1469</guid><dc:creator>soomit.banerjee</dc:creator><slash:comments>0</slash:comments><comments>http://mainframemigration.org/blogs/metalogic_systems/comments/1469.aspx</comments><wfw:commentRss>http://mainframemigration.org/blogs/metalogic_systems/commentrss.aspx?PostID=1469</wfw:commentRss><description>&lt;p&gt;&lt;strong&gt;&lt;u&gt;Introduction&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;span style="font-size:9pt;"&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoBodyText"&gt;&lt;span&gt;&lt;font size="2"&gt;The customer has multiple applications running on Hitachi mainframe (IBM plug compatible) which included three large applications Parts Consolidation, and Order Processing from supply chain and part of the Production Management system. Due to various technological and cost constraints posed by these legacy hardware and software, client had decided to move these applications from Mainframe to UNIX based platforms while keeping the business logic unchanged. Migration of the three applications was executed in three phases and the projects were primed by Satyam.&lt;/font&gt;&lt;/span&gt;&lt;/p&gt;&lt;/span&gt;&lt;/span&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;strong&gt;&lt;u&gt;Source Platform&lt;/u&gt;&lt;/strong&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;em&gt;Platform:&lt;/em&gt; &lt;span style="font-size:10pt;font-family:Verdana;"&gt;Hitachi / VOS3 &lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Data Store:&lt;/em&gt; ADABAS / &lt;/span&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;SAM&amp;nbsp;&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Language:&lt;/em&gt; COBOL / NATURAL / &lt;/span&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;ASSEMBLER / JCL&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;strong&gt;&lt;u&gt;Target&amp;nbsp;Platform&lt;/u&gt;&lt;/strong&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;em&gt;Platform:&lt;/em&gt; &lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;IBM / AIX&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Data Store:&lt;/em&gt; &lt;span style="font-size:10pt;font-family:Verdana;"&gt;ORACLE 10g / Files&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Language:&lt;/em&gt; &lt;span style="font-size:10pt;font-family:Verdana;"&gt;MF COBOL / Shell Scripts &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;u&gt;&lt;strong&gt;Challenges&lt;/strong&gt;&lt;/u&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;The major challenge lied in migrating each of these applications within a very short time frame. All the migrated applications required to be easily maintainable. The converted applications in the new target platform had to behave exactly the same way they behaved in the legacy platform.&lt;/span&gt;&lt;span style="font-size:8pt;font-family:Verdana;"&gt;&lt;span&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;A few database fields were also expanded as a part of the migration project. Other modifications included moving the hard coded error messages in the programs to the database.&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;strong&gt;&lt;u&gt;Solution Approach&lt;/u&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoBodyText"&gt;&lt;span&gt;Metalogic had transformed these applications to modern platforms. The salient features of this solution were:&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoBodyText"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;tab-stops:list .25in;" class="MsoListBullet2"&gt;&lt;span style="font-family:Symbol;"&gt;&lt;span&gt;&lt;font size="3"&gt;&amp;middot;&lt;/font&gt;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;The ADABAS database were converted to Oracle 10g&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;tab-stops:list .25in;" class="MsoListBullet2"&gt;&lt;span style="font-family:Symbol;"&gt;&lt;span&gt;&lt;font size="3"&gt;&amp;middot;&lt;/font&gt;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;NATURAL, COBOL and ASSEMBLER languages got transformed to Micro Focus COBOL&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;tab-stops:list .25in;" class="MsoListBullet2"&gt;&lt;span style="font-family:Symbol;"&gt;&lt;span&gt;&lt;font size="3"&gt;&amp;middot;&lt;/font&gt;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;JCL was converted to Shell Scripts on AIX&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;tab-stops:list .25in;" class="MsoListBullet2"&gt;&lt;span style="font-family:Symbol;"&gt;&lt;span&gt;&lt;font size="3"&gt;&amp;middot;&lt;/font&gt;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Major portion of the work was executed offshore at Metalogic&amp;rsquo;s offshore. The combination of automated, tool based approach and offshore delivery resulted in major savings.&lt;/span&gt;&lt;/p&gt;&lt;h4 style="margin:0in 0in 0pt;"&gt;&lt;span style="font-weight:normal;font-size:10pt;color:windowtext;font-family:Verdana;"&gt;The solution achieved more than 95% automation in conversion and modification while near 50% in automation was achieved in testing.&lt;/span&gt;&lt;/h4&gt;&lt;h4 style="margin:0in 0in 0pt;"&gt;&lt;span style="font-weight:normal;font-size:10pt;color:windowtext;font-family:Verdana;"&gt;&lt;strong&gt;&lt;u&gt;Status&lt;/u&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/h4&gt;&lt;h4 style="margin:0in 0in 0pt;"&gt;&lt;span style="font-weight:normal;font-size:10pt;color:windowtext;font-family:Verdana;"&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;tab-stops:.5in;" class="MsoHeader"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Migration of the first application was started in April 2006 and delivered in December 2006; the second one spanned October 2006 to August 2007 while the third application was started in December 2007 and complete on March 2008. &lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;tab-stops:.5in;" class="MsoHeader"&gt;&amp;nbsp;&lt;/p&gt;&lt;/span&gt;&lt;/h4&gt;&lt;/span&gt;&lt;img src="http://mainframemigration.org/aggbug.aspx?PostID=1469" width="1" height="1"&gt;</description><category domain="http://mainframemigration.org/blogs/metalogic_systems/archive/tags/Case+Studies/default.aspx">Case Studies</category></item><item><title>Migration from IBM mainframe to Sun/Solaris for a leading Insurance company in UK</title><link>http://mainframemigration.org/blogs/metalogic_systems/archive/2008/08/06/Migration-from-IBM-mainframe-to-Sun_2F00_Solaris-for-a-leading-Insurance-company-in-UK.aspx</link><pubDate>Tue, 05 Aug 2008 08:51:00 GMT</pubDate><guid isPermaLink="false">f4c3e5da-e6c5-42b1-ad1c-f6005d509669:1467</guid><dc:creator>soomit.banerjee</dc:creator><slash:comments>0</slash:comments><comments>http://mainframemigration.org/blogs/metalogic_systems/comments/1467.aspx</comments><wfw:commentRss>http://mainframemigration.org/blogs/metalogic_systems/commentrss.aspx?PostID=1467</wfw:commentRss><description>&lt;p&gt;&lt;strong&gt;&lt;u&gt;Introduction&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;span style="font-size:9pt;"&gt;&lt;p style="margin:0in 0in 0pt;text-autospace:ideograph-numeric;" class="MsoBodyText2"&gt;The customer is a leading insurance company in UK. The project was executed for one of its offices in Australia.&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in -6pt 0pt 0in;" class="MsoBodyText3"&gt;As a part of their IT strategy, they wanted to migrate their applications from IBM/MVS to an open systems environment on SUN Solaris.&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;The mainframe application was using IMS, VSAM, Assembler, CICS, COBOL and JCL. The target environment was Solaris, Oracle9i, Oracle Pro*COBOL Precompiler, MicroFocus COBOL and Shell scripts.&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Besides the application migration, the scope also included migration of data from IMS database and VSAM files to Oracle 9i database.&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoBodyText2"&gt;Metalogic Systems executed this project from its development center in Kolkata, India in partnership with the prime contractor for the project, an IT services company based in Mumbai, India.&lt;/p&gt;&lt;/span&gt;&lt;/span&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;strong&gt;&lt;u&gt;Challenges&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;&lt;p style="margin:0in 0in 0pt;text-autospace:ideograph-numeric;" class="MsoBodyText2"&gt;The major challenge in this project lay in the transformation of the complex hierarchical IMS database to Oracle. Achieving performance levels and accuracy of the existing mission-critical application, was an added challenge.&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;text-autospace:ideograph-numeric;" class="MsoBodyText2"&gt;&amp;nbsp;&lt;/p&gt;&lt;/span&gt;&lt;/span&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;strong&gt;&lt;u&gt;Solution Approach&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoBodyText"&gt;&lt;span style="font-size:9pt;"&gt;Metalogic has provided a tool based automated solution approach, which carried out the following steps:&lt;/span&gt;&lt;/p&gt;&lt;ul&gt;&lt;li&gt;&lt;div class="MsoBodyText" style="margin:0in 0in 0pt;"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Reverse engineering the application source &lt;/span&gt;&lt;/div&gt;&lt;/li&gt;&lt;li&gt;&lt;div class="MsoBodyText" style="margin:0in 0in 0pt;"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Recovering the legacy data model in IMS and VSAM&lt;/span&gt;&lt;/div&gt;&lt;/li&gt;&lt;li&gt;&lt;div class="MsoBodyText" style="margin:0in 0in 0pt;"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Finalise and generate the Oracle data model&lt;/span&gt;&lt;/div&gt;&lt;/li&gt;&lt;li&gt;&lt;div class="MsoBodyText" style="margin:0in 0in 0pt;"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Generate the database access layers&lt;/span&gt;&lt;/div&gt;&lt;/li&gt;&lt;li&gt;&lt;div class="MsoBodyText" style="margin:0in 0in 0pt;"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Generate the data migration utilities&lt;/span&gt;&lt;/div&gt;&lt;/li&gt;&lt;li&gt;&lt;div class="MsoBodyText" style="margin:0in 0in 0pt;"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Forward engineering the programs to MF Cobol&lt;/span&gt;&lt;/div&gt;&lt;/li&gt;&lt;/ul&gt;&lt;h4 style="margin:0in 0in 0pt;"&gt;&lt;span style="font-weight:normal;font-size:9pt;color:windowtext;font-family:Verdana;"&gt;The solution has achieved near 90% automation.&lt;/span&gt;&lt;/h4&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;strong&gt;&lt;u&gt;Status&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;h4 style="margin:0in 0in 0pt;"&gt;&lt;span style="font-weight:normal;font-size:9pt;color:windowtext;font-family:Verdana;"&gt;The solution achieved near 80% automation in conversion. The project was started in April 2004 and the migrated application was delivered to the client on August 2004. The migrated system went live in December 2004.&amp;nbsp;&lt;span&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/h4&gt;&lt;/span&gt;&lt;/span&gt;&lt;img src="http://mainframemigration.org/aggbug.aspx?PostID=1467" width="1" height="1"&gt;</description><category domain="http://mainframemigration.org/blogs/metalogic_systems/archive/tags/Case+Studies/default.aspx">Case Studies</category></item><item><title>Migration from ICL mainframe to Sun/Solaris for a government department in South Africa</title><link>http://mainframemigration.org/blogs/metalogic_systems/archive/2008/08/06/Migration-from-ICL-mainframe-to-Sun_2F00_Solaris-for-a-government-department-in-South-Africa.aspx</link><pubDate>Tue, 05 Aug 2008 08:18:00 GMT</pubDate><guid isPermaLink="false">f4c3e5da-e6c5-42b1-ad1c-f6005d509669:1466</guid><dc:creator>soomit.banerjee</dc:creator><slash:comments>0</slash:comments><comments>http://mainframemigration.org/blogs/metalogic_systems/comments/1466.aspx</comments><wfw:commentRss>http://mainframemigration.org/blogs/metalogic_systems/commentrss.aspx?PostID=1466</wfw:commentRss><description>&lt;p&gt;&lt;strong&gt;&lt;u&gt;Introduction&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoBodyText"&gt;&lt;span style="font-size:9pt;"&gt;The customer had an ICL Trimetra LY mainframe for running their mission critical Claims &amp;amp; Benefits applications at Compensation Commission based on COBOL using IDMS-X network database and Flat files. Due to cost and technological constraints posed by these legacy hardware and software, client had decided to decommission the mainframe and modernize the existing software applications. The project was primed by and jointly executed with our business partner.&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoBodyText"&gt;&amp;nbsp;&lt;/p&gt;&lt;/span&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;u&gt;&lt;strong&gt;Source Platform&lt;/strong&gt;&lt;/u&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Platform:&lt;/em&gt; &lt;span style="font-size:10pt;font-family:Verdana;"&gt;ICL Trimetra / VME &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Data Store:&lt;/em&gt; &lt;span style="font-size:10pt;font-family:Verdana;"&gt;IDMS-X / &lt;/span&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Flat Files&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Language:&lt;/em&gt; &lt;span style="font-size:10pt;font-family:Verdana;"&gt;COBOL / SCL&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;strong&gt;&lt;u&gt;Target Platform&lt;/u&gt;&lt;/strong&gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Platform:&lt;/em&gt;&amp;nbsp;Sun / Solaris&amp;nbsp;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Data Store:&lt;/em&gt; &lt;span style="font-size:10pt;font-family:Verdana;"&gt;Oracle 9i&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Language:&lt;/em&gt;&amp;nbsp;&lt;/span&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Oracle Pro*COBOL / &lt;/span&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;MF COBOL&amp;nbsp;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Application Server: JBoss&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Screen: JSP&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;strong&gt;&lt;u&gt;Challenges&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;The major challenge lied in migrating this application, which had very little documentation and low technical inputs from the end users. All information had to be extracted through a tool-based process from the legacy source code.&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;The deployment platform of the migrated application was another point of complexity.&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;/span&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;strong&gt;&lt;u&gt;Solution Approach&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoBodyText"&gt;&lt;span style="font-size:9pt;"&gt;Considering the rich functionality of the software applications, Metalogic had used a transformation solution to move them on to modern platform while retaining the core functionality. Metalogic&amp;rsquo;s proprietary tools were used for converting COBOL, IDMS-X, and SCL. The salient features of this solution were:&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoBodyText"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;tab-stops:list .25in;" class="MsoListBullet2"&gt;&lt;span style="font-family:Symbol;"&gt;&lt;span&gt;&lt;font size="3"&gt;&amp;middot;&lt;/font&gt;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span&gt;&lt;font size="3"&gt;&lt;font face="Times New Roman"&gt;The network database and flat files were converted to Oracle.&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;tab-stops:list .25in;" class="MsoListBullet2"&gt;&lt;span style="font-family:Symbol;"&gt;&lt;span&gt;&lt;font size="3"&gt;&amp;middot;&lt;/font&gt;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;The COBOL applications were converted to Open Systems MicroFocus COBOL and some components were moved to Java.&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;tab-stops:list .25in;" class="MsoListBullet2"&gt;&lt;span style="font-family:Symbol;"&gt;&lt;span&gt;&lt;font size="3"&gt;&amp;middot;&lt;/font&gt;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;The application screens were converted to JSP&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;tab-stops:list .25in;" class="MsoListBullet2"&gt;&lt;span style="font-family:Symbol;"&gt;&lt;span&gt;&lt;font size="3"&gt;&amp;middot;&lt;/font&gt;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span&gt;&lt;font size="3"&gt;&lt;font face="Times New Roman"&gt;SCL jobs were converted to Unix SHELL&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;tab-stops:list .25in;" class="MsoListBullet2"&gt;&lt;span style="font-family:Symbol;"&gt;&lt;span&gt;&lt;font size="3"&gt;&amp;middot;&lt;/font&gt;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Application data was migrated to Oracle 9i.&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;tab-stops:list .25in;" class="MsoListBullet2"&gt;&lt;span style="font-family:Symbol;"&gt;&lt;span&gt;&lt;font size="3"&gt;&amp;middot;&lt;/font&gt;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;A major portion of the work was executed offshore at Metalogic&amp;rsquo;s offshore facility at Kolkata resulting in major savings.&lt;/span&gt;&lt;/p&gt;&lt;/span&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;strong&gt;&lt;u&gt;Status&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;h4 style="margin:0in 0in 0pt;"&gt;&lt;span style="font-weight:normal;font-size:9pt;color:windowtext;font-family:Verdana;"&gt;The solution achieved near 80% automation in conversion. The project was started in April 2004 and the migrated application was delivered to the client on August 2004. The migrated system went live in December 2004.&amp;nbsp;&lt;span&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/h4&gt;&lt;/span&gt;&lt;/span&gt;&lt;img src="http://mainframemigration.org/aggbug.aspx?PostID=1466" width="1" height="1"&gt;</description><category domain="http://mainframemigration.org/blogs/metalogic_systems/archive/tags/Case+Studies/default.aspx">Case Studies</category></item><item><title>Application migration for a large system integrator of France</title><link>http://mainframemigration.org/blogs/metalogic_systems/archive/2008/08/05/Application-migration-for-a-large-system-integrator-at-France.aspx</link><pubDate>Tue, 05 Aug 2008 07:20:00 GMT</pubDate><guid isPermaLink="false">f4c3e5da-e6c5-42b1-ad1c-f6005d509669:1465</guid><dc:creator>soomit.banerjee</dc:creator><slash:comments>0</slash:comments><comments>http://mainframemigration.org/blogs/metalogic_systems/comments/1465.aspx</comments><wfw:commentRss>http://mainframemigration.org/blogs/metalogic_systems/commentrss.aspx?PostID=1465</wfw:commentRss><description>&lt;p&gt;&lt;strong&gt;&lt;u&gt;Introduction&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;The application conversion project was executed for a customer of a leading systems integrator&amp;nbsp;of France.&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;The existing application was developed in COBOL, PL/I, IDMS and VSAM and the objective was to have a uniform technology with a relational database. Maintaining PL/I and IDMS was costly and the conversion aimed at a cheaper and simpler platform. &lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;The project was primed by and jointly executed with our business partner in France. Metalogic was responsible for conversion of PL/I programs to COBOL, IDMS to DB2 and modifications of programs impacted by the database change. Metalogic&amp;rsquo;s scope was to convert the source code and schema and it was executed offshore. Our business partner carried out all the testing and the converted application was delivered to the systems integrator for implementation. &lt;/span&gt;&lt;/p&gt;&lt;/span&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;u&gt;&lt;strong&gt;Source Platform&lt;/strong&gt;&lt;/u&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Platform:&lt;/em&gt; &lt;span style="font-size:10pt;font-family:Verdana;"&gt;IBM Mainframe / MVS&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Data Store: &lt;/em&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;VSAM / IDMS Network database&lt;/span&gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Language:&lt;/em&gt;&amp;nbsp;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;PL/I / COBOL / JCL&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;strong&gt;&lt;u&gt;Target Platform&lt;/u&gt;&lt;/strong&gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Platform:&lt;/em&gt; &lt;span style="font-size:10pt;font-family:Verdana;"&gt;IBM Mainframe / MVS&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Data Store:&lt;/em&gt; &lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;DB2 / VSAM &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Language:&lt;/em&gt;&amp;nbsp;COBOL / JCL&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;strong&gt;&lt;u&gt;Challenges&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;The major challenge was the conversion of PL/I programs to COBOL without any loss in functionality. Another challenge lied in conversion of IDMS schema to DB2. Neither was any application documentation available in English.&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;/span&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;strong&gt;&lt;u&gt;Solution Approach&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Metalogic used its transformation tools for conversion of PL/I code to COBOL and conversion of IDMS schema to DB2 schema. Both the converted COBOL and original COBOL programs were modified to access DB2 in place of IDMS. Necessary changes were also incorporated in JCL scripts. Data conversion programs were generated from the tools. All converted components were supplied to the implementer for testing and implementation.&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Solution highlights&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;text-indent:-0.25in;tab-stops:list .25in;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Wingdings;"&gt;&lt;span&gt;&amp;sect;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Network database schema was converted to relational schema&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;text-indent:-0.25in;tab-stops:list .25in;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Wingdings;"&gt;&lt;span&gt;&amp;sect;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;PL/I programs were converted to COBOL&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;text-indent:-0.25in;tab-stops:list .25in;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Wingdings;"&gt;&lt;span&gt;&amp;sect;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;The conversion achieved near 95% automation using Metalogic&amp;rsquo;s transformation tools&lt;/span&gt;&lt;/p&gt;&lt;/span&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;strong&gt;&lt;u&gt;Status&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;h4 style="margin:0in 0in 0pt;"&gt;&lt;span style="font-weight:normal;font-size:9pt;color:windowtext;font-family:Verdana;"&gt;The project was started in July 2004 and source and schema conversion was completed in 4 months. Tool adaptation for PL/I and code and schema conversion was completely managed by Metalogic resources.&lt;/span&gt;&lt;/h4&gt;&lt;/span&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;/span&gt;&lt;img src="http://mainframemigration.org/aggbug.aspx?PostID=1465" width="1" height="1"&gt;</description><category domain="http://mainframemigration.org/blogs/metalogic_systems/archive/tags/Case+Studies/default.aspx">Case Studies</category></item><item><title>Application migration of the Water Billing System for a city office in USA</title><link>http://mainframemigration.org/blogs/metalogic_systems/archive/2008/08/04/Application-migration-of-the-Water-Billing-System-for-a-city-office-in-USA.aspx</link><pubDate>Mon, 04 Aug 2008 05:51:00 GMT</pubDate><guid isPermaLink="false">f4c3e5da-e6c5-42b1-ad1c-f6005d509669:1464</guid><dc:creator>soomit.banerjee</dc:creator><slash:comments>0</slash:comments><comments>http://mainframemigration.org/blogs/metalogic_systems/comments/1464.aspx</comments><wfw:commentRss>http://mainframemigration.org/blogs/metalogic_systems/commentrss.aspx?PostID=1464</wfw:commentRss><description>&lt;p&gt;&lt;strong&gt;&lt;u&gt;Introduction&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;The scope&amp;nbsp;involved migration of a critical water billing system application running on Bull/GCOS to IBM/AIX environment, with COBOL online and batch programs, along with IDS-II network database, JCL, and Screens.&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;u&gt;&lt;strong&gt;Source Platform&lt;/strong&gt;&lt;/u&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Platform:&lt;/em&gt; BULL Mainframe / &lt;/span&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;GCOS 8&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;File System:&lt;/em&gt; UFAS Files (Sequential, Relative &amp;amp; ISAM)&amp;nbsp;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Database:&lt;/em&gt; IDS II Network database &lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Trasaction Monitor:&lt;/em&gt; TP-8&amp;nbsp;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Language:&lt;/em&gt; COBOL / JCL&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;strong&gt;&lt;u&gt;Target Platform&lt;/u&gt;&lt;/strong&gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Platform:&lt;/em&gt; RS6000 / AIX &lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Database:&lt;/em&gt; &lt;span style="font-size:10pt;font-family:Verdana;"&gt;ORACLE 8&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Transaction Monitor:&lt;/em&gt; Tuxedo TP monitor&amp;nbsp;&lt;/span&gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;em&gt;Language:&lt;/em&gt;&amp;nbsp;&lt;/span&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Oracle Pro*COBOL / &lt;/span&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;MF COBOL / SHELL Scripts / VB UI deployed on Windows&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;strong&gt;&lt;u&gt;Challenges&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;The major challenges were in re-modeling the IDS II network data model to fit a relational database and meet the same performance level of the existing system. This required to be completed in a tight time frame, as the system was due for retirement. The requirement also included Y2K compliance.&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;strong&gt;&lt;u&gt;Solution Approach&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Automated, tool assisted migration of COBOL programs to MF COBOL and conversion of IDS II schema to Oracle RDBMS. The solution involved conversion of screens to Visual Basic, with Tuxedo TP monitor. JCL was converted to SHELL scripts. Data migration utilities were generated through the tool for downloading data from the mainframe IDS II database and uploading them on to the Oracle database. &lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Solution highlights&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;text-indent:-0.25in;tab-stops:list .25in;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Wingdings;"&gt;&lt;span&gt;&amp;sect;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Network database schema was converted to relational schema&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;text-indent:-0.25in;tab-stops:list .25in;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Wingdings;"&gt;&lt;span&gt;&amp;sect;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Mainframe character screens were converted to modern GUI screens&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;text-indent:-0.25in;tab-stops:list .25in;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Wingdings;"&gt;&lt;span&gt;&amp;sect;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;Data was migrated using tool generated migration programs&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt 0.25in;text-indent:-0.25in;tab-stops:list .25in;" class="MsoNormal"&gt;&lt;span style="font-size:9pt;font-family:Wingdings;"&gt;&lt;span&gt;&amp;sect;&lt;span style="font:7pt 'Times New Roman';"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:9pt;font-family:Verdana;"&gt;The solution achieved near 80% automation using Metalogic&amp;rsquo;s tools&lt;/span&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&lt;strong&gt;&lt;u&gt;Status&lt;/u&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p style="margin:0in 0in 0pt;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;The project along with archived data migration was completed in 6 months time and went live in December 1999 and still running in the converted state.&lt;/span&gt;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="text-justify:inter-ideograph;margin:0in 0in 0pt;text-align:justify;" class="MsoNormal"&gt;&amp;nbsp;&lt;/p&gt;&lt;/span&gt;&lt;img src="http://mainframemigration.org/aggbug.aspx?PostID=1464" width="1" height="1"&gt;</description><category domain="http://mainframemigration.org/blogs/metalogic_systems/archive/tags/Case+Studies/default.aspx">Case Studies</category></item></channel></rss>