Life after proprietary wares: German support biz flees IBM Db2 databases for something more Postgres-shaped

Emotions post-migration among the IT team included 'shock, refusal, rational understanding, and acceptance'

A German IT services outfit specialising in the insurance market has migrated 500 IBM Db2 databases to the EnterpriseDB (EDB) iteration of Postgres in a sign of life after proprietary wares.

BG-Phoenics joins Indian credit reference agency TransUnion CIBIL, which shifted Oracle workloads to EDB, providing evidence for the viability of open-source database tech for demanding business workloads.

Harald Stefan, head of platform databases for BG Phoenics, was in 2017 responsible for around 1,500 operational databases supporting 8,500 IT users in the social insurance market. His team took the decision to replace all of its IBM technology, including Db2, Tivoli and Websphere, which by the end of 2019 made up the core infrastructure supporting the content management system.

Databases varied in size from smaller than 100GB to 2.5TB.

The reason for the departure from Big Blue's technology was the complexity of the architecture and subsequent effect on management and licensing. It also had an impact on deployment times.

"It was highly consolidated and complex to operate, and difficult to get patches in," Stefan said at online conference Postgres Build 2020. "When you created a machine, there is a team involved for storage, for network, for Active Directory and so on. It took time to get a change to the teams. There were weekend activities because of this architecture."

After a long evaluation process, his team decided to migrate from Db2 instances to EDB Postgres – the open-source Postgres with a few mission critical bells and whistles from EDB, the commercial company contributing to and supporting the open-source project.

For the migration project, the team was looking to automate the deployment of servers, run a simple licensing model, expand the use of containers and use S3 storage as backup. The capacity to support database optimiser hints was one of the main reasons for picking EDB, Stefan said. In addition, the criteria included high availability, partitioning, point-of-time recovery, support access, ACID compliance, and so on.

"The devil is really in the details. For example, [if] a few databases cannot handle hints and applications using this they are out," he said of the bidding process.

BG Phoenics chose EDB Postgres because it met these criteria and supported migration from both Db2 and Oracle, providing tooling at no additional cost.

Having said that, there was no direct way to automate migration from Db2 to EDB or migrate the character set. As such, the tech team had to use a migration tool for the data type and character conversion, selecting Full Convert.

The team split the schema and tables into patches and automated them to finish at the same time. "That is a lot of work, but it is possible and you can automate it," Stefan added.

With this approach, the team was able to complete the migration by the end of 2019.

Since going live, the user found the deployment of new instances in Postgres much faster than it had been in Db2, down from around 20 hours spread over two weeks to 40 to 60 minutes. "Now we can go really agile and react in hours," Stefan said.

One of the lessons learned from the migration was not to underestimate the emotional attachment IT teams have to certain technologies. Stefan said it was hard for people who have been working with Db2 and Oracle for 20 years or more to accept the change, pointing to a graph suggesting they would go through phases of shock, refusal, rational understanding, and emotional acceptance. "But now we're having fun with Postgres," he said.

BG Phoenics was not alone as a large corporate user successfully migrating away from a proprietary database to Postgres. Speaking to The Register in the summer, Ganadeva Bandyopadhay, associate vice president of IT at TransUnion CIBIL, described the migration from Oracle to Postgres EDB.

The company was looking to revamp older applications based on "rapidly outgoing concepts like heavy database servers with a lot of business logic within the database code," Bandyopadhay said.

The company also found its Oracle licences were being underused, but the rigidity in the rules made it difficult to move them onto different virtual instances and convert from the processor-based to the "Named User Plus" licensing.

Starting from 2015, Bandyopadhay and his team wanted to remove the business logic from the main database, improving performance and flexibility in the architecture, something he said would have been difficult to do with Oracle.

"It was nothing against Oracle, but our logic was to address Oracle features which are built within the database," he said. "There is a cost to that which we had accepted for a long time, but with the changing expectations [from the business], we had to really revamp and flatten out the databases and put the business logic into somewhere else in the middle tier."

Having completed the migration in 2017, TransUnion CIBIL found the Postgres EDB-based system was able to achieve higher throughput at lower licensing costs, but not before careful consideration in reskilling its internal IT team.

"One of the advantages of the EDB Postgres is that it is compatible with the [data centre] virtual machines, which allows us the flexibility to quickly scale up databases as per the business growth," Bandyopadhay said.

While some Oracle or Db2 users are looking for alternatives, other are happy to stick with the technology, aware of the trade-offs.

Speaking to The Register last week, Oracle UK User Group member advocate Neil Chandler said: "Postgres has its strengths. But, like all of the open-source offerings, it is not as scalable as a proprietary database like Oracle or SQL Server. It's just not there. It may be for a very good department-size database; just good enough."

For Oracle users, at least, the downside was obvious. "I would argue the best database in the world is Oracle. The most expensive database in the world is also Oracle," he said.

With huge global installed bases, Oracle and IBM's Db2 are not likely to be seriously threatened by Postgres any time soon. But a couple of trailblazers have shown there are colours other than red and blue. ®

Similar topics

Broader topics

Other stories you might like

  • Lonestar plans to put datacenters in the Moon's lava tubes
    How? Founder tells The Register 'Robots… lots of robots'

    Imagine a future where racks of computer servers hum quietly in darkness below the surface of the Moon.

    Here is where some of the most important data is stored, to be left untouched for as long as can be. The idea sounds like something from science-fiction, but one startup that recently emerged from stealth is trying to turn it into a reality. Lonestar Data Holdings has a unique mission unlike any other cloud provider: to build datacenters on the Moon backing up the world's data.

    "It's inconceivable to me that we are keeping our most precious assets, our knowledge and our data, on Earth, where we're setting off bombs and burning things," Christopher Stott, founder and CEO of Lonestar, told The Register. "We need to put our assets in place off our planet, where we can keep it safe."

    Continue reading
  • Conti: Russian-backed rulers of Costa Rican hacktocracy?
    Also, Chinese IT admin jailed for deleting database, and the NSA promises no more backdoors

    In brief The notorious Russian-aligned Conti ransomware gang has upped the ante in its attack against Costa Rica, threatening to overthrow the government if it doesn't pay a $20 million ransom. 

    Costa Rican president Rodrigo Chaves said that the country is effectively at war with the gang, who in April infiltrated the government's computer systems, gaining a foothold in 27 agencies at various government levels. The US State Department has offered a $15 million reward leading to the capture of Conti's leaders, who it said have made more than $150 million from 1,000+ victims.

    Conti claimed this week that it has insiders in the Costa Rican government, the AP reported, warning that "We are determined to overthrow the government by means of a cyber attack, we have already shown you all the strength and power, you have introduced an emergency." 

    Continue reading
  • China-linked Twisted Panda caught spying on Russian defense R&D
    Because Beijing isn't above covert ops to accomplish its five-year goals

    Chinese cyberspies targeted two Russian defense institutes and possibly another research facility in Belarus, according to Check Point Research.

    The new campaign, dubbed Twisted Panda, is part of a larger, state-sponsored espionage operation that has been ongoing for several months, if not nearly a year, according to the security shop.

    In a technical analysis, the researchers detail the various malicious stages and payloads of the campaign that used sanctions-related phishing emails to attack Russian entities, which are part of the state-owned defense conglomerate Rostec Corporation.

    Continue reading
  • FTC signals crackdown on ed-tech harvesting kid's data
    Trade watchdog, and President, reminds that COPPA can ban ya

    The US Federal Trade Commission on Thursday said it intends to take action against educational technology companies that unlawfully collect data from children using online educational services.

    In a policy statement, the agency said, "Children should not have to needlessly hand over their data and forfeit their privacy in order to do their schoolwork or participate in remote learning, especially given the wide and increasing adoption of ed tech tools."

    The agency says it will scrutinize educational service providers to ensure that they are meeting their legal obligations under COPPA, the Children's Online Privacy Protection Act.

    Continue reading
  • Mysterious firm seeks to buy majority stake in Arm China
    Chinese joint venture's ousted CEO tries to hang on - who will get control?

    The saga surrounding Arm's joint venture in China just took another intriguing turn: a mysterious firm named Lotcap Group claims it has signed a letter of intent to buy a 51 percent stake in Arm China from existing investors in the country.

    In a Chinese-language press release posted Wednesday, Lotcap said it has formed a subsidiary, Lotcap Fund, to buy a majority stake in the joint venture. However, reporting by one newspaper suggested that the investment firm still needs the approval of one significant investor to gain 51 percent control of Arm China.

    The development comes a couple of weeks after Arm China said that its former CEO, Allen Wu, was refusing once again to step down from his position, despite the company's board voting in late April to replace Wu with two co-chief executives. SoftBank Group, which owns 49 percent of the Chinese venture, has been trying to unentangle Arm China from Wu as the Japanese tech investment giant plans for an initial public offering of the British parent company.

    Continue reading
  • SmartNICs power the cloud, are enterprise datacenters next?
    High pricing, lack of software make smartNICs a tough sell, despite offload potential

    SmartNICs have the potential to accelerate enterprise workloads, but don't expect to see them bring hyperscale-class efficiency to most datacenters anytime soon, ZK Research's Zeus Kerravala told The Register.

    SmartNICs are widely deployed in cloud and hyperscale datacenters as a means to offload input/output (I/O) intensive network, security, and storage operations from the CPU, freeing it up to run revenue generating tenant workloads. Some more advanced chips even offload the hypervisor to further separate the infrastructure management layer from the rest of the server.

    Despite relative success in the cloud and a flurry of innovation from the still-limited vendor SmartNIC ecosystem, including Mellanox (Nvidia), Intel, Marvell, and Xilinx (AMD), Kerravala argues that the use cases for enterprise datacenters are unlikely to resemble those of the major hyperscalers, at least in the near term.

    Continue reading

Biting the hand that feeds IT © 1998–2022