• 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

• Entry Server Bang For The Buck, IBM i Versus Red Hat Linux

  November 11, 2019 Timothy Prickett Morgan

  In last week’s issue, we did a competitive analysis of the entry, single-socket Power S914 machines running IBM i against Dell PowerEdge servers using various Intel Xeon processors as well as an AMD Epyc chip running a Windows Server and SQL Server stack from Microsoft. This week, and particularly in the wake of IBM’s recent acquisition of Red Hat, we are looking at how entry IBM i platforms rate in terms of cost and performance against X86 machines running a Linux stack and an appropriate open source relational database that has enterprise support.

  Just as a recap from last week’s …

  Read more

• Entry Server Bang For The Buck, IBM i Versus Windows Server

  November 4, 2019 Timothy Prickett Morgan

  Some big changes that Microsoft has instituted with its Windows Server platform to make pricing consistent across on premises and public cloud deployments has had the interesting side effect that entry IBM i machinery based on Power9 iron is now more competitive with entry X86 servers using the latest processors from Intel and AMD.

  This is not universally true, mind you, but it is certainly true of machinery in the P05 software tier where a lot of the IBM i base hangs out. There is still a large gap on entry iron in the P10 software tier, and we did …

  Read more

• IBM i TRs Bring Database Enhancements, Too

  October 30, 2019 Alex Woodie

  The heart of the IBM i server is its database, so it’s natural that we would see some enhancements to Db2 for i with delivery of IBM i 7.4 Technology Refresh 1 and 7.3 TR 7 next month. The new features may not be earth-shaking, but they deliver some useful functionality nonetheless.

  Let’s start with some foundational changes to the database itself, including the way that database engineers architect the tables that store information in the database. With 7.4 TR1, IBM i shops can now add a new child table to the database without having an exclusive lock on the …

  Read more

• Data Protection in the New Regulated Era

  October 23, 2019 Alex Woodie

  Companies must protect their data from all sorts of threats these days, including power outages, failed servers, and drive crashes. But one of the most important aspects of data protection today is ensuring the security and privacy of data, which is mandated by a slew of emerging data regulations.

  In May 2018, the European Union enacted the General Data Protection Regulation (GDPR), a far-reaching new law that gave people sweeping new rights over their data. While GDPR ostensibly just impacts EU citizens, many large companies in the U.S. and other countries adopted new security and privacy processes to ensure consistence …

  Read more

• Guru: Debugging Common Table Expressions

  October 21, 2019 Ted Holt

  I cannot say enough good things about common table expressions. Words like wonderful and marvelous don’t begin to describe them. However, CTEs do add a bit of complexity to an SQL query, and when the result set doesn’t contain the correct results, any common table expression can be the culprit. Fortunately, debugging queries with common table expressions is not difficult.

  To illustrate what I mean, let’s assume we have a query that retrieves shipment information for one day. It involves a few tables:

  • a one-row table containing a shipment date
  • a table of shipment header information
  • a customer master table

  …

  Read more

• Monoliths, Microservices, and IBM i Modernization: Part 2

  October 14, 2019 Alex Woodie

  Microservices are the future, right? After reading part one of this series, you can be excused for thinking that. Breaking up applications into smaller components brings clear benefits to both the development and operations staff, and clearly is an architectural approach that has a lot of momentum. But it turns out there might be practical limits to how far the microservices approach can take us.

  “Loosely coupled, yet tightly integrated.” That phrase became something of a running joke at an Infor conference attended by this reporter several years ago. The company at the time was betting heavily on its ION …

  Read more

Previous Articles Next Articles