Db2 13 makes z/OS debut, promises AI, hybrid cloud features

Long-awaited major release welcomed by users who wish IBM would promote it a little more

In the first major upgrade since 2016, IBM is releasing a basket of updates for the edition of its well-established Db2 relational database for the z/OS mainframe operating system. The latest tweaks are designed to use machine learning to make systems more efficient to manage and operate.

One consultant with long-standing experience with the system said customers would welcome the upgrades, but hoped IBM would publicise its Db2 development more broadly.

New features come in three groups addressing hybrid cloud; AI support for operations and transactions, and applications; and a database-integrated approach to developing large-scale AI insights.

The hybrid cloud update extends data source support for MongoDB, Athena, and Amazon RedShift, as well as hybrid cloud deployment of Db2's Query Management Faculty on IBM Cloud and Microsoft Azure. It also promises to collect real-time and historical information about Db2 utility executions to improve usage and optimization.

New support for operations, transactions, and applications comes in the form of Db2 13 for z/OS VUE, which promises AI-based operational efficiency and costs reduction as well as enhanced resiliency, and application stability for unparalleled availability. Db2 AI for z/OS 1.5 is a separately licensed product that uses machine learning and AI to help improve operational performance and maintain the health of Db2 systems.

IBM said that putting AI into Db2 to would help uncover insights based on hidden relationships and inferred meaning of Db2 data. It promises AI-related built-in functions in SQL Data Insights and AI to help improve operational efficiency, reduce costs, and increase DBA productivity.

Craig Mullins, president and principal of Mullins Consulting, a Db2 specialist, pointed out the update is the first major release in more than six years for Db2, which counts Bank of America and Natwest Group among its customers.

"But the install base was prepared for that because when version 12 came out IBM announced they were going to do continuous improvement through functionality more of like a DevOps approach," he said.

"Users were thinking: 'Maybe there won't be a new version.' But all along IBM has been saying 'Yes, when things get to a certain point, we will do a new version.' [The new release] has been greeted with some relief in the install base which now sees what IBM said is true," Mullins said.

Many of the new features would be welcomed by users, he said but singled out the ability to partition-by-range tablespaces with minimal impact to applications. This gives users the ability to quickly change between different tablespace types, Mullins explains.

He said: "There is the ability to partition it by range, or partition it by growth. [In Db2 12] there's been no easy way to convert from one to the other. In this release [Db2 13] is a simple mechanism to make the change and do the online reorganisation.

Customers may make the decision upfront to partition by range but at some point down the line they may decide that growth would be a better option. Now they can avoid a complex series of DDL or potential outages, Mullins claimed.

The Db2 13 upgrade is currently only available for the z/OS iteration. Those using the database on Windows, Linux and IBM i (formerly OS/400) will have to wait.

Db2, where are you? Big Blue is oddly reluctant to discuss recent enhancements to its flagship database


You kept that quiet

Db2 has earned a reputation as the database IBM doesn't want to talk about, while other so-called cloud-native database vendors attract a lot of investor and media attention, although there have been recent improvements in the way IBN's relationasl database works with Kubernetes.

"I understand why IBM has to pivot and everything is about the hybrid cloud and trying to remake the company in that image," Mullins said.

"IBM has got a different problem set than a lot of other companies. Newer database vendors: that's all they do. IBM has been around for 100 years. Its challenge is remaining relevant to the marketplace and keeping everybody who uses their technology happy. I'm a Db2 guy.

"Am I happy with how they are promoting Db2? Not at all. I think they should be out banging the drums and saying how great the DBMS — and all the things they put into it — is," he said.

IBM has declined the opportunity to offer a briefing for this piece and has yet to respond to questions about Db2 13's release on platforms other than z/OS. ®

Similar topics

Broader topics

Other stories you might like

  • Despite 'key' partnership with AWS, Meta taps up Microsoft Azure for AI work
    Someone got Zuck'd

    Meta’s AI business unit set up shop in Microsoft Azure this week and announced a strategic partnership it says will advance PyTorch development on the public cloud.

    The deal [PDF] will see Mark Zuckerberg’s umbrella company deploy machine-learning workloads on thousands of Nvidia GPUs running in Azure. While a win for Microsoft, the partnership calls in to question just how strong Meta’s commitment to Amazon Web Services (AWS) really is.

    Back in those long-gone days of December, Meta named AWS as its “key long-term strategic cloud provider." As part of that, Meta promised that if it bought any companies that used AWS, it would continue to support their use of Amazon's cloud, rather than force them off into its own private datacenters. The pact also included a vow to expand Meta’s consumption of Amazon’s cloud-based compute, storage, database, and security services.

    Continue reading
  • Atos pushes out HPC cloud services based on Nimbix tech
    Moore's Law got you down? Throw everything at the problem! Quantum, AI, cloud...

    IT services biz Atos has introduced a suite of cloud-based high-performance computing (HPC) services, based around technology gained from its purchase of cloud provider Nimbix last year.

    The Nimbix Supercomputing Suite is described by Atos as a set of flexible and secure HPC solutions available as a service. It includes access to HPC, AI, and quantum computing resources, according to the services company.

    In addition to the existing Nimbix HPC products, the updated portfolio includes a new federated supercomputing-as-a-service platform and a dedicated bare-metal service based on Atos BullSequana supercomputer hardware.

    Continue reading
  • In record year for vulnerabilities, Microsoft actually had fewer
    Occasional gaping hole and overprivileged users still blight the Beast of Redmond

    Despite a record number of publicly disclosed security flaws in 2021, Microsoft managed to improve its stats, according to research from BeyondTrust.

    Figures from the National Vulnerability Database (NVD) of the US National Institute of Standards and Technology (NIST) show last year broke all records for security vulnerabilities. By December, according to pentester Redscan, 18,439 were recorded. That's an average of more than 50 flaws a day.

    However just 1,212 vulnerabilities were reported in Microsoft products last year, said BeyondTrust, a 5 percent drop on the previous year. In addition, critical vulnerabilities in the software (those with a CVSS score of 9 or more) plunged 47 percent, with the drop in Windows Server specifically down 50 percent. There was bad news for Internet Explorer and Edge vulnerabilities, though: they were up 280 percent on the prior year, with 349 flaws spotted in 2021.

    Continue reading
  • ServiceNow takes aim at procurement pain points
    Purchasing teams are a bit like help desks – always being asked to answer dumb or inappropriate questions

    ServiceNow's efforts to expand into more industries will soon include a Procurement Service Management product.

    This is not a dedicated application – ServiceNow has occasionally flirted with templates for its platform that come very close to being apps. Instead it stays close to the company's core of providing workflows that put the right jobs in the right hands, and make sure they get done. In this case, it will do so by tickling ERP and dedicated procurement applications, using tech ServiceNow acquired along with a company called Gekkobrain in 2021.

    The company believes it can play to its strengths with procurements via a single, centralized buying team.

    Continue reading
  • HPE, Cerebras build AI supercomputer for scientific research
    Wafer madness hits the LRZ in HPE Superdome supercomputer wrapper

    HPE and Cerebras Systems have built a new AI supercomputer in Munich, Germany, pairing a HPE Superdome Flex with the AI accelerator technology from Cerebras for use by the scientific and engineering community.

    The new system, created for the Leibniz Supercomputing Center (LRZ) in Munich, is being deployed to meet the current and expected future compute needs of researchers, including larger deep learning neural network models and the emergence of multi-modal problems that involve multiple data types such as images and speech, according to Laura Schulz, LRZ's head of Strategic Developments and Partnerships.

    "We're seeing an increase in large data volumes coming at us that need more and more processing, and models that are taking months to train, we want to be able to speed that up," Schulz said.

    Continue reading
  • We have bigger targets than beating Oracle, say open source DB pioneers
    Advocates for MySQL and PostgreSQL see broader future for movement they helped create

    MySQL pioneer Peter Zaitsev, an early employee of MySQL AB under the original open source database author Michael "Monty" Widenius, once found it easy to identify the enemy.

    "In the early days of MySQL AB, we were there to get Oracle's ass. Our CEO Mårten Mickos was always telling us how we were going to get out there and replace all those Oracle database installations," Zaitsev told The Register.

    Speaking at Percona Live, the open source database event hosted by the services company Zaitsev founded in 2006 and runs as chief exec, he said that situation had changed since Oracle ended up owning MySQL in 2010. This was as a consequence of its acquisition that year of Sun Microsystems, which had bought MySQL AB just two years earlier.

    Continue reading
  • Beijing needs the ability to 'destroy' Starlink, say Chinese researchers
    Paper authors warn Elon Musk's 2,400 machines could be used offensively

    An egghead at the Beijing Institute of Tracking and Telecommunications, writing in a peer-reviewed domestic journal, has advocated for Chinese military capability to take out Starlink satellites on the grounds of national security.

    According to the South China Morning Post, lead author Ren Yuanzhen and colleagues advocated in Modern Defence Technology not only for China to develop anti-satellite capabilities, but also to have a surveillance system that could monitor and track all satellites in Starlink's constellation.

    "A combination of soft and hard kill methods should be adopted to make some Starlink satellites lose their functions and destroy the constellation's operating system," the Chinese boffins reportedly said, estimating that data transmission speeds of stealth fighter jets and US military drones could increase by a factor of 100 through a Musk machine connection.

    Continue reading
  • How to explain what an API is – and why they matter
    Some of us have used them for decades, some are seeing them for the first time on marketing slides

    Systems Approach Explaining what an API is can be surprisingly difficult.

    It's striking to remember that they have been around for about as long as we've had programming languages, and that while the "API economy" might be a relatively recent term, APIs have been enabling innovation for decades. But how to best describe them to someone for whom application programming interfaces mean little or nothing?

    I like this short video from Martin Casado, embedded below, which starts with the analogy of building cars. In the very early days, car manufacturers were vertically integrated businesses, essentially starting from iron ore and coal to make steel all the way through to producing the parts and then the assembled vehicle. As the business matured and grew in size, car manufacturers were able to buy components built by others, and entire companies could be created around supplying just a single component, such as a spring.

    Continue reading

Biting the hand that feeds IT © 1998–2022