• IBM Mulls Using DataMigrator as Cloud Warehouse Pipeline

  June 29, 2022 Alex Woodie

  IBMers are playing around with an update to a little-known ETL tool called DataMigrator for i that would make it easier for IBM i shops to move transactional data to cloud-based data warehousing platforms. The update would use Apache Kafka for the final connection to the cloud.

  DataMigrator ETL Extension, as the product is formally known, is an extract, transform, and load (ETL) tool created by IBM back in 2015. The product was developed to work with Db2 Web Query, the Java-based business intelligence tool that it OEMed from Information Builders (now owned by TIBCO).

  DataMigrator for …

  Read more

• COMMON Set for First Annual Conference in Three Years

  May 18, 2022 Alex Woodie

  Don’t look now, but COMMON is about to hold its first annual conference in three years. Starting on Monday in New Orleans, POWERUp 2022 will be the biggest gathering of the IBM i community since the pandemic started more than two years ago. There is still time to register for the conference, which will feature a raft of presentations on the newly released IBM i version 7.5.

  COMMON’s annual conference scheduled for the New Orleans Marriott next week is shaping up to be a good one. More than 100 speakers are scheduled to present more than 300 sessions on …

  Read more

• Big Blue At Your Power Systems Service

  February 14, 2022 Timothy Prickett Morgan

  IBM may have spun off its managed services and system hosting businesses into Kyndryl, but it still has a sizable remaining technical support, systems integration, technology consulting, business transformation, and application operations business that represents close to 40 percent of its revenues. And so it is very keen on selling Power Systems shops all kinds of services.

  To that end, IBM made two announcements last week regarding the Power Systems hardware platform.

  The first, in announcement letter 222-033, is a new plan to offer Software Maintenance – what IBM i shops and resellers and even IBM itself usually call …

  Read more

• The Mod Squad Comes Together to Modernize Old RPG

  October 6, 2021 Alex Woodie

  In the early 70s, a group of fictional social misfits joined up to solve crimes on the hit television series The Mod Squad. Now a group of real-life IBM i professionals of the same name are uniting to solve an equally pressing problem: modernizing old RPG code, including some that dates back to the 1970s.

  “You’ve heard of IBM‘s upward compatibility,” says Rich Ollari, an IBM i veteran who is one of the ringleaders of the new Mod Squad. “Code that ran back in the 80s, even the 70s, is still running today, and that’s what we’re fighting with. …

  Read more

• Additions To The Db2 Web Query Family

  November 9, 2020 Alex Woodie

  Change is in the air for Db2 Web Query, the primary business intelligence tool for IBM i environments from Big Blue. Earlier this year, IBM launched two new versions of the product, and this fall, IBM delivered version 2.3 of the product. Finally, there’s been a change of ownership of the third-party company behind the software.

  Let’s start with the change in ownership. Last month, TIBCO Software announced its intent to acquire Information Builders, the privately held New York City business intelligence software company that Gerald Cohen founded way back in 1975. IBI’s primary product is WebFOCUS, which forms …

  Read more

• What’s New With Db2 Web Query?

  May 11, 2020 Alex Woodie

  Db2 Web Query, which is IBM’s strategic business intelligence tool for IBM i, doesn’t follow the same release cycle as the operating system itself. But as part of activity surrounding the latest round of Technology Refreshes (TR) for IBM i 7.3 and 7.4, IBM discussed the recent updates that it’s made to Db2 Web Query, along with new features that are due very soon.

  To get the lowdown on the new Db2 Web Query features, we tuned into a recent presentation made by Doug Mack, IBM’s Db2 Web Query product manager. Mack presented a session with Db2 for i …

  Read more

• Here’s What’s In the Latest IBM i Technology Refreshes

  April 15, 2020 Alex Woodie

  As expected, IBM today officially unveiled its spring Technology Refreshes for IBM i. Among the goodies that will become available for IBM i 7.4 TR2 or IBM i 7.3 TR8 (or both) are enhancements to Db2 Mirror, a new approach to tape library virtualization, improvements to open source, and new features and functionality around Db2, RPG, RDi, and security, too.

  Months ago, IBM execs circled April 14 on their calendars as the day for the big IBM 7.4 TR2 and IBM i 7.3 TR8 reveal, with the idea that the following week’s POWERUp conference in Atlanta, Georgia (now canceled, but …

  Read more

• 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. …

  Read more

• Guru: Health Indicators

  January 28, 2019 Dawn May

  In Configure Collection Services, I reviewed how you can improve the configuration of Collection Services. In this tip, I’m going to demonstrate how to easily review your Collection Services data and understand your partition’s performance characteristics using the Health Indicators.

  Navigator for i has a rich set of performance tasks, one of which is Investigate Data, also referred to as the Performance Data Investigator (PDI). The base operating system allows you to manage and visualize Collection Services data. The Performance tasks (and PDI) also support other types of performance data, but those graphical features require installing the Performance Tools …

  Read more

• IBM Tweaks Power Iron, Pulls Software, Adds Proactive Support

  September 17, 2018 Timothy Prickett Morgan

  Big Blue announced the “ZZ“ Power9 entry systems back in February, the “Boston” entry machines in May, and the midrange “Zeppelin” and high-end “Fleetwood” machines in August, which is the full product line. But IBM is still nipping and tucking the product line as customers react to it and want slightly different things than what initially came out with the systems.

  In announcement letter 118-079, IBM made a few tweaks that will be interesting to IBM i shops. First of all, the mainstream Power S924 system, a 4U rack or tower system with two Power9 processors, …

  Read more

Previous Articles