• Guru: SUBSET on EXECUTE and OPEN

  June 15, 2020 Paul Tuohy

  The DB2 for i Enhancements in IBM i 7.3 Technology Refresh 8 / IBM i 7.4 Technology Refresh 2 just made dynamic SQL, embedded in RPG, a lot easier to use. It includes an enhancement entitled USING SUBSET on EXECUTE and OPEN with Extended indicators. This enhancement provides a simple and effective solution to a problem that I first highlighted in an article I wrote back in September of 2015. (See A First Look At SQL Descriptors.)

  The “problem” we are dealing with is how to handle a variable number of host variables being used in a dynamic …

  Read more

• Seiden Group Offers PHP Migration Service

  May 27, 2020 Alex Woodie

  Change is in the air when it comes to PHP on IBM i. The free Zend distribution of PHP that has been adopted by thousands of IBM i shops over the years is going away, and it’s being replaced by a new community distribution that’s installed via RPM. But how can you move existing PHP apps to the new environment? Seiden Group has a potential solution.

  As we told you last week, the Zend Server Basic environment will stop being offered by Perforce (the company that now owns Zend Technology) or distributed with the IBM i operating system on …

  Read more

• A Simple Web Service Framework from Core-I Solutions

  May 20, 2020 Alex Woodie

  It can sometimes be difficult for IBM i shops to communicate with the outside world. RPG developers can get lost in the weeds of trying to figure out how to move data off IBM i to another platform. One potential solution is a new REST/Web services framework called Corei RSt that its creator says will simplify APIs.

  According to Core-I Solutions principal Jefferson Vaughn, a senior software engineer based in South Carolina, the Corei RSt framework streamlines the process of exposing IBM i data to business partners, customers, and outside developers who aren’t inside the company’s intranet.

  The framework leverages …

  Read more

• PowerHA Updates Focus on Integration and Automation

  May 13, 2020 Alex Woodie

  Despite the introduction of Db2 Mirror last year, PowerHA remains a critical component ensuring the high availability and disaster recoverability for thousands of IBM i shops around the world. Recent updates, including the delivery of PowerHA version 7.4 in the second half of 2019 and a minor update delivered in March 2020, have focused on bolstering the product’s integration with Db2 Mirror, as well as HyperSwap in the DS8000. Automation, monitoring, and usability have also been improved.

  Brian Nordland, the PowerHA technical product manager with HelpSystems (which develops the product on behalf of IBM) recently updated the IBM i …

  Read more

• Idera Bolsters Visual LANSA 15

  May 13, 2020 Alex Woodie

  Idera last month issued the first major announcement for its LANSA product lineup since it bought the application development toolmaker last year. With Visual LANSA 15, the company has delivered more than 500 enhancements, including a new API creation experience, native chart controls for Web apps, and a host of sample apps, among many other new features.

  Before LANSA sold itself to Idera in January 2019, Visual LANSA was the company’s flagship integrated development environment (IDE) for creating modern graphical applications that run on IBM i, Windows, and cloud platforms.

  While Visual LANSA users can get down and dirty …

  Read more

• Big Blue Makes Moves To Mainstream Db2 Mirror

  May 4, 2020 Timothy Prickett Morgan

  When IBM brought out its active-active Db2 for i database clustering extensions, called Db2 Mirror appropriately enough, almost exactly a year ago to improve the resiliency of databases and therefore the applications that run atop them on the IBM i platform, we had a few asks. As part of the April Technology Refresh announcements for IBM i 7.3 and 7.4, some of those asks are answered and it looks like another one might be in the works.

  The two most important things that we asked for are related, and it is all about making Db2 Mirror available and affordable for …

  Read more

• What’s New In Open Source With The Latest TRs

  April 27, 2020 Alex Woodie

  New technology is exciting. And when it can help you run your business more profitably or efficiently, well, it becomes very exciting. With IBM i, the open source community is arguably the biggest contributor of new technology to the platform. IT Jungle recently checked in Jesse Gorzinski, the IBM i open source architect, to hear how the open source story has improved with the recent technology refreshes.

  Arguably the biggest open source-related enhancement with IBM i 7.4 TR2 and 7.3 TR8 revolves around a change in RPM, the new delivery method that IBM adopted two years ago to distribute new …

  Read more

• Database Enhancements Galore In Technology Refresh

  April 20, 2020 Alex Woodie

  Db2 for i is the beating heart of the IBM i server. There’s no doubt about that. So when IBM delivers the next set of Technology Refreshes (TRs) for IBM i 7.3 and 7.4 next month, you can bet that they’ll be loaded with new and improved features to keep the database humming.

  To get up to speed with the database-related enhancements in IBM i 7.4 TR2 and IBM i 7.3 TR8, IT Jungle caught up to Scott Forstie, a senior technical staff member at IBM’s lab in Rochester, Minnesota, and the database architect for Db2 for i.

  There’s …

  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

• 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

Previous Articles Next Articles