• Time To Design – And Deliver – The Application System/360

  July 19, 2021 Timothy Prickett Morgan

  The stupidest thing IBM ever did was create a system other than the System/360. It had the perfect name and it had the right idea of creating a compatible line of small, medium, and large enterprise systems that ran a widening variety of operating systems and workloads, often concurrent on the same machine. The AS/400 really should have been the third generation of System/360 machines, and the systems today would be somewhere around the sixth of seventh or even tenth generation, however you want to think about it.

  Every decade or so in IBM’s history, it has tried to converge …

  Read more

• Guru: Understanding Database Performance Using The Performance Data Investigator, Part 1

  June 21, 2021 Dawn May

  This is a two-part series on how to use the Performance Data Investigator (PDI) for investigating performance of Db2 for i. While the SQL Performance Center in Access Client Solutions is the tool of choice for Db2 performance analysis, there is valuable information that you can get from using PDI. PDI is often a useful starting point to help guide you in the correct direction when trying to identify performance issues. In my experience, PDI is under-utilized for Db2 investigation. For those not familiar with PDI, you may want to read the article, Getting Started with the Performance Data Investigator …

  Read more

• Locking Down Exit Point And IFS Vulnerabilities On IBM i

  March 24, 2021 Pauline Brazil Ayala

  It’s true that the IBM i server is among the most securable servers on the planet. But all too often, customers do not take the time to secure their environments properly. This is particularly true for two of the most oft-neglected components of the IBM i environment: exit points and the IFS.

  IBM introduced exit points with the launch of OS/400 V3R1 way back in 1994. We remember that version well here at Trinity Guard, because soon after that, we developed the industry’s first exit point monitoring software for the AS/400 at PentaSafe, the spiritual predecessor of our company. …

  Read more

• iTech Solutions Keeps You In The Know With VERIFi

  February 22, 2021 Alex Woodie

  “An ounce of prevention is worth a pound of cure.” That time-tested bit of advice from Ben Franklin has many applications, including, it turns out, IBM i systems management. And through its new VERIFi offering, iTech Solutions is set to provide many ounces of prevention by keeping customers on top of what is happening with their IBM i servers.

  iTech Solutions’ VERIFi comes in three flavors. With VERIFi Weekly Status Reporting, the company remotely monitors key aspects of IBM i server health and summarize those findings in a PDF sent once a week for $295 per year. It offers …

  Read more

• Thoroughly Modern: What’s New With PHP On IBM i?

  December 7, 2020 Timothy Prickett Morgan

  If you use PHP on IBM i, you’ve likely seen some recent announcements about some great changes coming to the open-source language. According to the latest blog post from Zend on PHP 8, there are a number of new functions being introduced including str_contains, str_starts_with, and str_ends_with, preg_last_error_msg and get_debug_type. In addition, the core PHP 8 engine has many new features, optimizations and improvements in the type system, error handling, and consistency. The key areas include:

  • JIT Compiler
  • Fatal errors on incompatible method signatures
  • LSP Enforcement
  • Resource “Classes”
  • Assertion behavior
  • XML-RPC is now in PECL
  • Reflection changes

  This is …

  Read more

• MariaDB Now Available Via RPM

  December 7, 2020 Alex Woodie

  When it comes to databases for the IBM i community, Db2 for i is, and always be, number one. But there’s no reason to limit yourself to just one database, and now IBM is making it easier for IBM i shops to get their hands on MariaDB, which could be the number two database on the platform.

  MariaDB is an open source relational database that is a fork of MySQL. MySQL, of course, has been supported on the IBM i server for many years. But following Oracle’s acquisition of Sun Microsystems, which had acquired the company that developed MySQL, …

  Read more

• Open Source The Path To Software Riches For IBM i

  December 2, 2020 Alex Woodie

  For what is supposed to be a proprietary platform, the IBM i server sure has a lot of open source software running on it. In recent months, it appears that the majority of new programs introduced to IBM i are open source in nature. That pattern shows no signs of changing any time soon, according to a recent report by OpenLogic.

  Open software has existed on the IBM i platform for many years. The first highly publicized dip into the open source well occurred in 2005, when IBM partnered with a company called Zend to bring its PHP runtime to …

  Read more

• Db2 And SQL Services Get Upgrades With TRs

  October 12, 2020 Alex Woodie

  Among the biggest enhancements that IBM is bringing to IBM i with the latest batch of Technology Refreshes are new capabilities added to the integrated Db2 database and, specifically, the slew of SQL-based services that retrieve all types of data from the platform for IBM i professionals.

  As we previously told you, IBM has decided to rename SQL Services, which were the collection of pre-defined SQL queries that recreate traditional IBM i commands and sometimes bring something entirely new. The growing gaggle of services (or perhaps it’s a herd?) are now being officially referred to as IBM i services, …

  Read more

• Guru: Scalar Use of LISTAGG

  August 24, 2020 Ted Holt

  The SQL LISTAGG function is as handy as a pocket. Only recently I used it to build a string of comma-separated values (CSV) to populate a drop-down box. It sure beats a cursor and a loop. I’ve noticed in my reading that LISTAGG can be used for both aggregate and scalar purposes under Oracle. Db2 doesn’t support the scalar use, but I found another way to do the same thing.

  To see what I’m talking about, check out example 7 in the article Oracle LISTAGG Function Usage, Tips & Examples, by Ben Brumm. I recommend studying the entire article; …

  Read more

• New Option Emerges for Refactoring IBM i Apps

  August 19, 2020 Alex Woodie

  IBM i shops that want to refactor their RPG and COBOL applications into different languages have a new option available to them. In late June, Astadia and Blu Age announced they’re working together on a new service that automates the conversion of customers’ older apps into Java and .NET code that can run on X86 systems in your basement or the cloud.

  Based in Boston, Massachusetts, Astadia claims to have completed more than 200 mainframe migrations and more than 100 mainframe modernization projects over about two-and-a-half decades. The company has modernized millions of lines of COBOL code running on mainframes …

  Read more

Previous Articles