• IBM Brings Active-Active Mirroring Into Db2 For i Database

  April 24, 2019 Timothy Prickett Morgan

  As a platform that is approaching 40 years of deployment within enterprises that can’t afford downtime with their mission critical systems – that’s counting the System/38 as well as the AS/400 and its follow-ons as part of the same continuum – it is no surprise at all that IBM midrange systems running RPG and COBOL had some of the most sophisticated – and perhaps the only application-centric – clustering software ever developed.

  Concurrent with the launch of IBM i 7.4 this week, Big Blue is rolling out a new kind of database clustering, which is called Db2 Mirror, that is …

  Read more

• Let’s Try Converged Power Infrastructure One More Time

  April 8, 2019 Timothy Prickett Morgan

  Do you remember the Flex System modular servers launched seven years ago this month? These were the innovative machines that Big Blue sold off to Lenovo about two and a half years after they were launched and they were ramping? Do you remember the PurePower follow-ons to these that came out in May 2015? Or did we all just imagine that happened?

  These modular machines, which were somewhere halfway between a rack server and a blade server, were put into preconfigured stacks and as the PureFlex system had cloud automation software to create a private cloud and then had …

  Read more

• Attention Synon Users: You Can Automate Your Move To RPG Free Form And DevOps

  April 3, 2019 Philippe Magne

  Depending on who you ask, there are about 1,000 IBM i shops that used the CA 2E (Synon) CASE tool to create their applications and are still using this tool to maintain those applications. This is not an easy task any more, and there is a much better way.

  After three years in development and very stringent testing with five early adopter Synon shops, ARCAD Software is rolling out what it calls Modernization as a Service, or MaaS for short, which seeks to completely automate the move from Synon generated code to modern RPG Free Form, SQL, and a complete …

  Read more

• Guru: Change XML Elements in SQL

  February 18, 2019 Paul Tuohy

  Over the last few years, it has become more common to store XML or JSON in a column in a table. Whereas SQL provides all the necessary functions to construct/deconstruct XML or JSON from/to relational data, it does not provide an easy means to change the contents of an element. In this article, I am going to demonstrate a technique for changing the contents of an XML element using an SQL stored procedure.

  Just to provide some background, I was recently working on a project where DB2 XML Extender functionality was being replaced with the standard XML functions. The project …

  Read more

• LANSA Bought By Software Conglomerate Idera

  January 7, 2019 Alex Woodie

  LANSA, one of the oldest independent software vendors targeting the IBM midrange server and arguably one of the most successful, has been acquired by Idera, a growing conglomerate of software companies that also owns Sencha, and which is owned in part by the same private equity firm behind HelpSystems.

  LANSA was founded in 1987 by Australian businessmen Peter Draney and Lyndsey Cattermole to create and sell software development tools for the IBM System/38. When IBM launched the AS/400 a year later, LANSA supported it with its fourth generation language (4GL) development environment. It hasn’t looked back, and today the company, …

  Read more

• An IBM i Year In Review

  December 10, 2018 Alex Woodie

  Another year is just about wrapped up for us here at IT Jungle. That means it’s time to ease off the news pedal just a tad and enter into a retrospective mood, with the hope of gaining some perspective on where we’ve been in 2018 and perhaps how we’ll start off 2019.

  It all started off rather poorly, way back in. . .

  January

  . . . when the big news was about Spectre and Meltdown, the two vulnerabilities that brought everybody rudely back to the real world following the New Year’s celebration. Nearly all types of processors, including …

  Read more

• Guru: Addressing A Legitimate Question

  December 10, 2018 Ted Holt

  This is the last Monday issue of The Four Hundred for 2018. My, how time flies! I like to do something different at year end. In previous years I have solved Sudoku puzzles, found my way through mazes, solved the peg game, and more. This year I wish to honor a request that has come from various people and to address what they consider to be a legitimate question.

  As I wrote recently, the question I hear occasionally goes something like this: “Why bother with service programs? Why not use dynamic calls?” Rather than insult the …

  Read more

• IBM Delivers New Goodies with ACS Update

  December 5, 2018 Alex Woodie

  IBM has issued a new release of Access Client Solutions (ACS), the indispensable Java-based client that delivers a range of functionality to administrators, developers, and users alike. In the new release of ACS, IBM delivers enhancements across a range of functions, including SQL queries, database schemas, data transfer, and printing and emulation.

  IBM first unveiled ACS way back in August 2012 as the strategic replacement for older IBM i client interfaces, such as Access for Windows, Access for Web, and Access for Linux. With a full 5250 emulator, support for printing, the capability to view IFS, spool file, and message …

  Read more

• Guru: More About Merge

  November 5, 2018 Ted Holt

  I often read back through articles that have appeared in this august publication to look for errors and omissions. Such an expedition recently made me aware that I have not told you as much as I would like to about the SQL MERGE statement. Today I am pleased to provide more information.

  First I want to be sure that everybody understands is that you can add conditions to the WHEN MATCHED and WHEN NOT MATCHED expressions. That means that you do not have to treat all matched or unmatched rows in the same way. Look at this example:

  merge . 

  …

  Read more

• CM First Removes IBM i Requirement From ALM

  October 17, 2018 Alex Woodie

  Companies that are adopting the application lifecycle management (ALM) software from CM First no longer need an IBM i server, the company announced recently. The move with CM MatchPoint is intended to widen the deployment options for CM First’s targeted customer base, which is CA Plex and 2E users.

  CM MatchPoint is used to automate the development of CA Plex and CA 2E environments, particularly among large development teams that are geographically dispersed. The software manages several aspects of Plex and 2E development, from user-submitted change requests and workflow to version control and deployment.

  With the delivery of CM MatchPoint …

  Read more

Previous Articles Next Articles