Glad to have you back for this week's IBM i Pulse! Each week we'll take a deeper look at the latest IBM i and Profound Logic news. This week we are looking at an interview with a Db2 expert as well as diving deeper into the features of the Db2 Mirror release a few weeks ago.
From Our Experts:
- Ted Holt's recent article for IT Jungle helps with Dealing with RPG Errors and Embedded SQL.
Profound Logic News:
- The Profound Logic team will be attending COMMON POWERUp conference!
Educational Resources:
- Ted Holt helps you eliminate the perception of outdated green-screens with this Intro to Profound UI Genie video.
- See how Node.js & RPG are the Perfect Partners in this Alex Roytman webinar.
- Get a look at our Guided Lab: Part 5 on creating an Employee Data Application in NodeRun.
Product News:
- Product enhancements for Profound UI V6 and Profound.js 4.10 have been released... check out the details here!
Industry News:
Scott Forstie on Db2 Mirror for i by Paul Tuohy
Paul recently sat down with Scott Forstie, Db2 architect for IBM i, about all things Db2 and IBM i. Here are some of the highlights from that interview:
"We've had a monumental effort bring Db2 Mirror to realization, we found time to add enhancements to not only 7.4 but also IBM i 7.3. We call it TR6—and I need to make one point clear: This is 2019. I've been telling customers at this event of yours, and others, that we won't enhance 7.2 anymore."
" I'd encourage your listeners to go out to our developerWorks technology updates Wiki and see the full complement of features. Yours truly is the content managers there, so we take the time to describe it for the technical audience. So I really need them to go see it so they have a chance to adopt what they already own."
"A different example of an enhancement would on the IBM i services front. This has grown in popularity quite a bit, so we've added in a number of new features for the services: things like data areas. You can use SQL as an alternative to retrieve data area and we have full support for all the different styles of data areas. We really leverage the capability of the SQL language to overcome the idea that maybe a data area has a number or a character. Well we don't care because we can—we can implicitly convert those in either direction."
Drilling Down Into Db2 Mirror for IBM i by Timothy Prickett Morgan
After their initial coverage of the release of the new Db2 Mirror for IBM i, the crew at IT Jungle decided to do a deeper dive into the ins and outs of the new Db2 Mirror option on the IBM i. The Db2 Mirror creates an active-active database cluster running on databases installed on two different logical partitions with two different copies of IBM i 7.4 running atop the PowerVM hypervisor. While these logical partitions can be on the same physical machine, the idea is to use Db2 Mirror to create an active-active database such that two copies of the database tables used by applications are synchronously updated over a Remote Direct Memory Access supported link. By putting the two mirrored partitions on different machines, you can continually keep one running and essentially remove downtime for your applications during upgrades, reboots, etc. Once you bring one of your machines back online the database information re-synchronizes with the one that never went offline. The active-active setup can also give you the ability to roll back an upgrade/update of a system if something went wrong, again without any downtime to your applications.
Read more about Db2 Mirror here
----------------------------------------------------------------------------------------------------------------------------------------------
