• 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

• IBM i 7.2 End Dates Revealed as Power7 Shutdown Looms

  September 18, 2019 Alex Woodie

  IBM surprised nobody last week when it announced that it will stop selling IBM i 7.2 next April and cease supporting the operating system a year later. The lead time should give IBM i shops plenty of runway to prepare their upgrade strategies and transition to newer versions of the operating system. A potentially more impactful deadline for those not paying close attention is the end of hardware support for Power7 boxes in less than two weeks.

  Last week’s announcement of end of sales and support for IBM i 7.2 and related software products was not unexpected. That’s because IBM …

  Read more

• PTC Completes Database Support In Implementer

  September 11, 2019 Alex Woodie

  As a change management tool, PTC’s Implementer is well-regarded among IBM i users for its ability to track development tasks and smooth out the promotion process. While the product has mostly been used to track source code in programming languages like RPG and Java, customers have increasingly been putting business logic into Db2 for i. With the recent launch of Implementer 12.3, PTC has wrapped up planned enhancements for the database.

  PTC‘s Implementer provides a full range of capabilities for managing development processes for IBM i shops. The software works closely with IBM‘s Rational Developer for i (RDi) …

  Read more

• Fresche Hires Database Modernization Expert

  September 11, 2019 Alex Woodie

  IBM i database modernization expert Birgitta Hauser has a new software house to call home following her hiring at Fresche Solutions. The new gig marks the start of a new era in the German’s 20-year career on the IBM i, and adds to Fresche’s growing arsenal of midrange talent.

  IBM i shops around the world are under pressure to either modernize their systems or migrate to something newer. While IBM i applications largely do what they were designed to do, the requirements have changed, and the siren call of digital transformation and big data analytics is too hard for …

  Read more

• Guru: I’m A Number, You’re A Number, Everybody’s A Number

  September 9, 2019 Ted Holt

  Do you, like Bob Seger, sometimes feel that you are nothing more than a number? Me too. That’s because to many people, that’s exactly what we are. And if there’s one thing that computers are good at, it’s assigning numbers — to orders, to accounts, to invoices, to transactions, and of course, to people. Since we have to make the computer assign numbers, we may as well learn the modern way to do it.

  In my earliest days of programming, I would store the last assigned of a series of numbers in a data file. (The S/34 and S/36 …

  Read more

• Stacking Up IBM i And Windows In The Clouds

  August 5, 2019 Timothy Prickett Morgan

  So how does the IBM Cloud running IBM i stack up against the main competition in the midrange, which is on premises Windows Server plus SQL Server from Microsoft as well as that same stack running in the Amazon Web Services cloud? We can’t give you a definitive answer, but we can give you some food for thought as you ponder how good of a deal Big Blue is giving customers who want to put IBM i on the cloud.

  Making comparisons between on premises iron and cloudy infrastructure is difficult and problematic. The good thing about a public cloud …

  Read more

• Remain Breaks New Ground With ALM Suite

  July 15, 2019 Alex Woodie

  Coding season just ended for Remain Software, the Dutch application lifecycle management (ALM) vendor with a growing US presence. That means customers are sorting through a torrent of new functionality in its flagship TD/OMS product, including improved hooks to DevOps tools like Git and Jenkins, a new cross-platform cross-reference module, and a nifty API generator too.

  New stuff started emerging from Remain Software around the POWERUp conference in May, when IT Jungle sat down with company representatives to talk about development trends, current and upcoming releases of Remain’s software, and what customers are looking to get next.

  Arguably the biggest …

  Read more

Previous Articles Next Articles