• Guru Classic: Tuning SQL Environments On i

  March 4, 2020 Paul Tuohy

  Author’s Note: This article was originally published in November 2015. This was one of the first DB2 for i Services that I used in anger. I have used a lot since.

  One of the frustrating things about being a speaker at conferences is that when you want to attend another session with a topic that piques your interest, it invariably clashes with when you are speaking. But every now and again, the scheduling gods work in your favor. Such was the case when I spoke at the excellent International i-Power 2015 conference at Wyboston Lakes Executive Centre in the UK. …

  Read more

• Boadway’s 25-Year Performance Shows No Let Up

  March 2, 2020 Alex Woodie

  Batch jobs running a little long? Throw some hardware at it. For as long as Mike Boadway can remember, that’s been the default response to dealing with most performance issues on the IBM i server. But when today’s fast Power9 processors and Flash drives fail to move the performance needle, maybe it’s worth reconsidering Boadway’s approach to tweaking the code and the data instead.

  As the CEO of MB Software & Consulting, Boadway makes his living off solving other people’s IBM i performance issues. Since founding the company in 1995, Boadway has used his proprietary software to deliver an …

  Read more

• NGS Breaks Scalability Barrier With OLAP Client

  February 10, 2020 Alex Woodie

  New Generation Software is putting the finishing touches on an overhaul of its OLAP client, called QPort SmartView, that it says removes limitations on the amount of data IBM i shops can analyze. The Windows program gives users the ease of use and flexibility of Excel on the front-end, but utilizes the scalability and OLAP processing heft of IBM i on the backend to analyze substantially larger data volumes.

  Typically, New Generation Software plays it down the middle when it comes to business intelligence and analytics on the IBM i platform. On the one hand, the company’s predominantly midsize clientele …

  Read more

• Where Does SAP On IBM i Go From Here?

  January 15, 2020 Alex Woodie

  In Monday’s issue of The Four Hundred, we covered some of the challenges that SAP has created for itself by having two very different mainstream ERP suites (see “SAP Sending Mixed Messages on ERP Platform Support.”) On the one hand, it wants to move forward with S/4 HANA, but on the other hand, it doesn’t have all the features that exist in the older Business Suite. That puts customers who run Business Suite on IBM i in a bit of a bind.

  HANA debuted in 2010 as an in-memory columnar database for handling online application processing (OLAP) workloads. In …

  Read more

• Update On Migration Of developerWorks Content

  January 15, 2020 Alex Woodie

  On New Year’s Day, IBM fulfilled its promise to turn off the developerWorks Connections website, which hosted technical content posted by members of the IBM i community. But before it hit the “delete” button, Big Blue worked with content owners to migrate the most active content to other websites, to redirect browser traffic, and to archive the rest.

  IBM made good on its previous promise to ensure that no content was left behind when it permanently shuttered the popular developerWorks Connections website. It was forced to make that promise after it caused an uproar in October, when it announced that …

  Read more

• The (More) Modern RPG Language

  December 16, 2019 Bob Cozzi

  Back in 1988, I wrote what became the book on RPG III. Then in 1996, I published the RPG IV version and updated it again circa 2000. But in the years that followed, RPG IV became mostly stale; a tweak here and there, but nothing too spectacular.

  In recent years, a wave of RPG IV enhances has been revealed, most notably free-format was completed and helped propel RPG IV, once again into a truly modern language. Although the measure of “modern” for RPG IV seems to lean toward how much free-format syntax is supported; which is ironic considering COBOL and …

  Read more

• Important: Some LPARs Hang With New TRs – IBM i PTF Guide, Volume 21, Number 50

  December 16, 2019 Doug Bidwell

  Listen up, folks. This one is serious. A few weeks ago, there were some bad patches on the Db2 for i database for IBM i 7.3, as we detailed here, and as last week was coming to a close, we found out that LPARs are hanging on machines that have the latest Technology Refreshes applied to IBM i 7.3 and IBM i 7.4 in cases where the Hardware Management Console (HMC) is not managing the partitions.

  The details of the issue with the Technology Refreshes are outlined in APAR MA48101, which is essentially a bug report that warns …

  Read more

• Db2 For IBM i 7.3 Hits A Bad Patch

  December 2, 2019 Timothy Prickett Morgan

  As you know, we are among the people in the IBM i community who are always telling you to keep current on your PTF patches for the best operating system available on Power Systems. (No, we are not talking about AIX or Linux.) But every now and again, as happens with all operating systems, something gets fixed and the fix is worse than the problem it was solving.

  That has apparently happened with the database patches for the Db2 for i relational database management system embedded in the IBM i 7.3 release once the Db2 Group patches from November 13 …

  Read more

• How Infor’s Coleman Strategy Is Evolving, and How IBM i Fits In

  November 20, 2019 Alex Woodie

  It’s been more than two years since Infor unveiled Coleman, the company’s AI platform which became generally available earlier this year. It’s not on the roadmap for IBM i just yet, according to Infor. That may not sound ideal for Infor’s IBM i customers, but it’s not necessarily a bad thing.

  Coleman was unveiled by ERP software giant Infor in 2017 primarily as a digital assistant, which is a fancy way of saying a chatbot. Just as Siri and Alexa can answer questions about the weather or sports, Coleman could answer basic questions about the business, and even handle some …

  Read more

• Microsoft Wants to Migrate Your IBM i Code to Azure

  November 13, 2019 Alex Woodie

  Microsoft is executing a plan with its partner Skytap to bring IBM i into its Azure cloud, as we’ve previously told you about. But another group within the technology giant has plans of its own to migrate IBM i applications to languages that can run natively on X86 servers and integrate more easily with Azure services.

  We caught wind of this group’s code migration plan a month ago when one of the technical specialists in the Microsoft Azure Global Customer Advisory Team (CAT) wrote a blog entry about the work they do. IT Jungle followed up with the IBM i …

  Read more

Previous Articles