Query for i Archives - IT Jungle

IBM i Shops Have Alternatives to Db2 Web Query

November 15, 2023 Alex Woodie

The sudden demise of Db2 Web Query has sent customers looking for alternatives. The good news is that IBM i software vendors offer a number of pre-built solutions that can fit the bill.

Here are some potential business intelligence tools from vendors that could serve as replacements to Db2 Web Query. We’ll take a look at open source alternatives in a future article.

Cozzi Research SQL World

Cozzi Research develops two query tools for IBM i, including SQL iQuery and SQL Tools, and bundles them both in a single product called SQL World.

Cozzi positions SQL iQuery as a native …
Read more
Guru: IBM i Experience Sharing, Case 5 – Using IBM i PDI Charts To Answer Performance Questions

July 18, 2022 Satid Singkorapoom

During my long career as an IBM i performance specialist, it was natural for people to ask me performance-related questions of various kinds. But in many cases, it seemed to me that the customer could not understand my answers, and I could not provide supporting evidence due to the lack of a performance reporting tool that could produce easy-to-understand explanatory information. The situation changed for the better with the availability of IBM i Performance Data Investigator (PDI) tool as of release 6.1. I would say that the PDI tool provides charts of information that resemble those used by business people …
Read more