IBM DB2 Archives - IBA Group - USA https://us.ibagroupit.com/tag/ibm-db2/ Mon, 14 Oct 2024 11:04:34 +0000 en-EN hourly 1 https://wordpress.org/?v=6.5.5 Development of a Unified Information Web System for an International Corporation https://us.ibagroupit.com/cases/unified-information-web-system/ Fri, 04 Nov 2022 10:43:14 +0000 https://us.ibagroupit.com/?post_type=cases&p=9161 The post Development of a Unified Information Web System for an International Corporation appeared first on IBA Group - USA.

]]>

Background

Different business units of the company have many systems that address the same tasks in different ways. It is required to develop a unified solution for the entire enterprise.

Business Challenge

Develop a scalable solution that allows combining various enterprise systems into one.

Project objectives:

  • Migration from legacy systems to a modern platform.
  • Development of a unified application.
  • Reducing the cost of maintaining multiple systems that address the same tasks.

Solution

IPPF (Integrated project planning and forecasting) is a web-based information system that collects contract and project information from various enterprise sources. By consolidating this data, workflows, and reports, the solution allows contract and account management to be integrated into customer management systems.

The IPPF solution provides project managers and partners with a key resource to help manage and monitor financial and non-financial project information through project financial supervision (planning, reconciliation and forecasting), non-financial project evaluations, and integration with back-end systems.

Technically, the IPPF solution runs on a web server cluster of three servers connected to three DB2 servers. Fallback recovery is ensured: in the event of an application failure, it can switch to another app deployed in a different cloud region.

Result

A state-of-the-art and scalable JEE application has been developed, which includes 30 different data sources. The number of IPPF users is constantly growing and amounts to more than 30,000 people worldwide.

The customer benefited from a multiple reduction in costs for maintaining the system due to the closure of similar applications.

Custom Development

The post Development of a Unified Information Web System for an International Corporation appeared first on IBA Group - USA.

]]>
IBA Group Presents at SHARE Virtual Experience https://us.ibagroupit.com/events/iba-group-presents-at-share-virtual-experience/ https://us.ibagroupit.com/events/iba-group-presents-at-share-virtual-experience/#respond Fri, 27 Aug 2021 09:36:16 +0000 https://us.ibagroupit.com/events/iba-group-presents-at-share-virtual-experience/ The post IBA Group Presents at SHARE Virtual Experience appeared first on IBA Group - USA.

]]>

IBA Group Presents at SHARE Virtual Experience

From August 2 to August 13, IBA Group participated in the SHARE Virtual Experience conference. It was a hybrid event, where the delegates could attend either in person or online from wherever they are.

The conference consisted of two parts. From August 2 to August 6, registered users could access more than 120 on-demand technical sessions that they could watch anytime. The live part of the conference lasted from August 9 to August 13 and featured over 100 live presentations.

The event showed a strong focus on open source and Zowe. Practically every presenter spoke about mainframe modernization, and other topics included hybrid cloud and z/OS 2.5. IBA Group presented a Global Repository for Mainframe Developers, For mainframe plugin, and Db2 database development in Git solutions at the event.

DevOps guide for beginners

Two years ago, IBA speakers talked about DevOps unicorns that would make mainframes fly. This time, they took a more practical approach, explaining to mainframe beginners how to start “DevOpsing” on the mainframe from the very scratch.

Mainframe gurus know what it is like to talk about mainframe development in simple words. The reality is that mainframe is never simple unless you couple it with modern approaches like DevOps. Having summed up the experience of a number of successful projects of DevOps implementation on mainframe platforms, the IBA team concluded that the siloed nature of mainframe needs an integrative approach to tackle the problems at the very core.

GRMD: mainframe Klondike

A year ago, the IBA mainframe team launched GRMD, an open source Global Repository for Mainframe Developers, aimed at making the life of mainframe newcomers easier.  The repository contains tested, searchable, and standardized solutions to ad hoc mainframe problems. The DevOps for mainframe solution for beginners that IBA Group presented at the conference is also a part of the repository.

The session hit the record of 80 attendees and attracted 20 new visitors to the repository, and the repository received 11 clones, 425 views, five stars, and five forks on the day of the session.

For Mainframe plugin: fighting black and green screens

Another session by young IBAers answered the question of whether the concept of UX/UI design could be applicable to the mainframe. The speakers presented a newly developed open source For Mainframe plugin that showed how modern UX/UI improves mainframe development. It is a new visual, drag-and-drop plugin that modernizes the mainframe’s black and green screen (available for download at JetBrains).

Earlier, the young IBA mainframers took part in the SHARE Summit of March 2021 and had a session focused on making the mainframe platform more user friendly for the newcomers. In addition, they proved the importance of creating more open source applications for the z/OS platform to make the mainframe look more attractive.

Kirill Branavitski, mainframe software developer at IBA Group:

“At this August SHARE, we went into the details of UX/UI, how it can increase your product’s value and why it is more important to have a good UI  rather than a large number of features. We brought up some problems of existing solutions, such as Eclipse-based enterprise IDEs for the mainframe and traditional terminal emulators. The attendees showed a strong interest in the solution. ‘Looks very promising!’ and ‘Where can we get one?’ were the words that confirmed the interest. There were many questions about the solution’s architecture. Changes are often met with resistance by people used to traditional solutions. This time we could convince them that our For Mainframe plugin can change the way people interact with the mainframe. I think we did a great job this time and hope to share more success stories in the future!”

Db2 database development in Git

IBA Group delivered its third session Managing Db2 Database Development in Git during the on-demand days of the conference, presenting their approach to the design of a DevOps pipeline for Db2 development and showcasing their Git-based solution.

Mainframe leaders and problem makers

The three sessions at the SHARE conference are not just siloed solutions that sprang up accidentally but rather a part of the company’s strategy of mainframe modernization. With 30 years of mainframe development behind, IBA Group went through the years of mainframe decay and was one of those companies who did not let the mainframe die when the shortage of mainframe developers was critical for the industry.

At present, IBA Group offers free courses on mainframe to university students, many of whom choose mainframe development for their first job. However, the vintage look of the legacy systems make many newcomers give up the job after the first few weeks.

A solution to a problem often comes from problem makers themselves. For example, young IBA developers came to IBA after the university course and instead of dropping “green and black” screens they started looking for a solution to modernize the mainframe interface and eventually came up with For Mainframe plugin.

Similarly, members of the IBA Group’s DevOps team came to IBA as students and managed to establish a kind of synergy between young developers, modern open source technologies, and legacy mainframe applications, which resulted in the creation of the Global Repository for Mainframe Developers.

IBA Group believes that the company is on the right track, offering employees from different backgrounds, age groups, and nationalities to work jointly on projects. They might have divergent views and different approaches, but they have a common goal of paving the way for a SMART future. If you feel like joining us on this road, please get in touch.

The post IBA Group Presents at SHARE Virtual Experience appeared first on IBA Group - USA.

]]>
https://us.ibagroupit.com/events/iba-group-presents-at-share-virtual-experience/feed/ 0
Assessment Tool for DB2 Support and Development https://us.ibagroupit.com/cases/assessment-tool-for-db2-support-and-development/ Thu, 17 Jan 2019 07:18:34 +0000 https://us.ibagroupit.com/?post_type=cases&p=4482 The post Assessment Tool for DB2 Support and Development appeared first on IBA Group - USA.

]]>

Project Overview

The goal of the project is to support a comprehensive assessment tool for DB2 product customers as well as enhance and develop the product itself. The product is designed to optimize efficiency of a DB2 database on z/OS.

Solution

The IBA activities include L2 Customer Support, L3 Change Team, and Test Team. Getting involved in the project more than six years ago, IBA Group developed strong partnership with client teams that are engaged in major product design and development. Presently, IBA is maintaining several major product releases.

Project Results

IBA is constantly improving product quality, reducing the number of customer complaints and field–opened APARs (Authorized Program Analysis Reports). The project has achieved quality targets set by the customer’s management. Users working with the assessment tool for DB2 product family describe their experience as pleasant.

The post Assessment Tool for DB2 Support and Development appeared first on IBA Group - USA.

]]>
Material Procurement System https://us.ibagroupit.com/cases/material-procurement-system/ Wed, 16 Jan 2019 06:37:51 +0000 https://us.ibagroupit.com/?post_type=cases&p=4411 The post Material Procurement System appeared first on IBA Group - USA.

]]>

Project Overview

The project was designed to migrate the Material Procurement System (MPS) of our client to an up-to-date software platform. MPS is an IT system that supports all processes in the purchasing environment of our client.

Its features include:

  1. Process all customer requirements
  2. Provide purchasing agents with information about automotive markets, parts, suppliers, prices, and business terms
  3. Relieve purchasing agents from routine jobs
  4. Perform analysis and generate reports
  5. Calculate revenues and savings
  6. Generate cost structures
  7. Compare negotiation targets with actual business results
  8. Control negotiation progress between purchasing agents and suppliers.

 

The legacy system was implemented using the programming language Smalltalk from CINCOM. One of the challenges was the absence of documentation (functional specifications and documented test cases) for the legacy system. The task was to migrate MPS to Java 3-tier architecture and create up-to-date documentation (use-case model and documented test cases).

The new application needed to meet the following requirements:

  1. Use Java EE technology
  2. Provide the same functionality as the legacy application with additional functional features
  3. Function with the legacy database and be able to use the same database concurrently with the legacy MPS
  4. Provide multi–language support including hieroglyphic (Japanese).

Project Execution

The project started in December 2003. IBA Group responsibilities included detailed system analysis, application design, application development, functional and system testing, quality assurance, and warranty support.

Built on advanced technologies, MPS was developed using RUP methodology with full lifecycle supported by IBA. Given application’s complexity, IBA suggested using pure Java EE platform for migration. Special tools were integrated in the development and build processes to ensure that code satisfies all customer requirements.

 

An iteration approach with five releases was adopted for the project. Each release included analysis (reverse engineering from Smalltalk code); design and implementation; system, functional and acceptance testing; and deployment to production.

Environment

  • Programming languages: Java, Java script, XML, HTML, SQL
  • Application servers: IBM WebSphere v 5.1, IBM DB2 on zOS, IBM WebSphere MQSeries
  • Development environment: IBM WebSphere Application Developer v 5.1

Project Results

IBA Group efforts for the project amounted to 90,000 person-days. IBA delivered the project on schedule and in budget. In 2005, a complete migration release of the MPS application was deployed to production. Further MPS releases incorporated additional functional features in line with new Change Requests.

 

The figures below show statistic results of the project:

  1. About 800 DB tables
  2. More than 1,800 use cases
  3. About 8,000,000 lines of Java code
  4. About 30K Java classes
  5. More than 90 Change Requests during the migration phase, most of these introducing new functionality
  6. More than 3,000 concurrent users around the world (Germany, US, Brazil, and Japan).

The post Material Procurement System appeared first on IBA Group - USA.

]]>