• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Db2 Web Query Lives On (Just Not V2.1)

    November 13, 2019 Alex Woodie

    There have been some rumors that IBM is going to sunset Db2 Web Query for i, or replace it with Cognos. Neither of those rumors is true, according to IBM, which recently made some changes to Db2 Web Query support.

    Db2 Web Query for i, of course, is the OEM version of Information Builders flagship BI and analytics tool, WebFOCUS, that IBM brought to market in the 2007 timeframe. The Java-based tool enables users to write queries for the Db2 for i database (and other databases) and view the results in a variety of pre-canned and custom dashboards and reports.

    Compared to the old Query/400 product, Db2 Web Query is light years ahead, and thousands of companies have adopted Db2 Web Query, which IBM has continued to update and improve with new releases every couple of years.

    Back in September 2018, IBM announced that support for Db2 Web Query version 2.1.x would end on September 30, 2019. At this point, a month and a half beyond that date, any IBM i shop with one of the unsupported versions should be actively executing a plan to move up to Db2 Web Query version 2.2.1, which was announced two years ago with the TRs for IBM i 7.2 and 7.3.

    IBM did not update Db2 Web Query with its recent October announcements, including IBM i 7.4 TR1 IBM i 7.3 TR7. That means that Db2 Web Query version 2.2.1 remains the latest release of the product, and it’s also the only release of the product that runs on IBM i 7.4. In charts about the announcement that IBM shared with IT Jungle, IBM confirmed that it’s working on a new release of Db2 Web Query.

    In the meantime, the IBM i community can familiarize with some of the existing functionality that’s still relatively new in Db2 Web Query version 2.2.1. We wrote about some of the big features when 2.2.1 was initially launched, including the visual data exploration that allows users to peruse lots of data in a graphical fashion, which will hopefully let them more easily spot trends buried in the data.

    But there are some other Db2 Web Query capabilities worth bringing up again too, including the new EZ-Install option that IBM introduced back in 2017. The EZ-Install provides a simplified process for installing Db2 Web Query, and IBM recommends that all customers use the EZ-Install option for both new installs and for updates. Users who haven’t purchased a license for Db2 Web Query can also use EZ-Install to load a trial copy of the product that’s good for 70 days.

    Another feature worth mentioning are the new sample reports and dashboards for systems administrators. These reports and dashboards are designed to give admins the ability to quickly see key performance indicators about their system, such as proximity to system and database limits, which objects are consuming the most temporary storage, and what jobs are consuming the most CPU.

    Admins will also benefit from reports that work across the entire system, including one that tells them exactly what PTF groups they have applied across multiple LPARs. With IBM i environments getting bigger and the growth of PTFs, this feature has the capability of being a real timesaver for admins.

    The EZ-Install option also automatically creates a new data dimension table utility that will come in handy for IBM i shops that struggle to handle multiple legacy date formats. There are many different ways that dates can be handled in the system, and IBM addressed this in its utility. IBM says the utility will automatically create a row in the table for every date in your date range. It will also create a column for “every legacy date format we could think of,” IBM said. It also generates a column for data attributes (such as holidays).

    IBM is not standing still with Db2 Web Query. And when IBM unveils a new release, you’ll hear about it first in IT Jungle.

    RELATED STORIES

    Visual Data Exploration Comes To Db2 Web Query

    DB2 Web Query For i Now Supports External Databases

    IBM Unveils ETL Solution for DB2 Web Query

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: Db2 Web Query, IBM i, LPAR, PTF

    Sponsored by
    ARCAD Software

    Embrace VS Code for IBM i Development

    The IBM i development landscape is evolving with modern tools that enhance efficiency and collaboration. Ready to make the move to VS Code for IBM i?

    Join us for this webinar where we’ll showcase how VS Code can serve as a powerful editor for native IBM i code and explore the essential extensions that make it possible.

    In this session, you’ll discover:

    • How ARCAD’s integration with VS Code provides deep metadata insights, allowing developers to assess the impact of their changes upfront.
    • The role of Git in enabling seamless collaboration between developers using tools like SEU, RDi, and VS Code.
    • Powerful extensions for code quality, security, impact analysis, smart build, and automated RPG conversion to Free Form.
    • How non-IBM i developers can now contribute to IBM i projects without prior knowledge of its specifics, while ensuring full control over their changes.

    The future of IBM i development is here. Let ARCAD be your guide!

    Watch Now

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Four Hundred Monitor, November 13 Remain Hooks Change Management System Into GitLab

    Leave a Reply Cancel reply

TFH Volume: 29 Issue: 68

This Issue Sponsored By

  • ProData Computer Services
  • Syniti, formerly BackOffice Associates
  • Blair Technology Solutions
  • ARCAD Software
  • WorksRight Software

Table of Contents

  • Microsoft Wants to Migrate Your IBM i Code to Azure
  • Remain Hooks Change Management System Into GitLab
  • Db2 Web Query Lives On (Just Not V2.1)
  • Four Hundred Monitor, November 13
  • IBM i PTF Guide, Volume 21, Number 45

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25
  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle