• 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

• Guru: Use SQL To Replace Reports

  June 14, 2021 Ted Holt

  Does anybody write report programs anymore? If so, why? Reports are so twentieth-century. The people we serve want spreadsheets, Web pages, cell-phone apps and other modern conveniences. What we need is an easy way to make our report programs write the same information to modern interfaces without having to perform major surgery on them.

  Some 10 years or so ago, I built a scripting language to enable me to reformat spooled files into stream files in CSV format. I called my utility BASS. It was, and continues to be, a successful project.

  But BASS is not the only way …

  Read more

• Watson-Inspired Pattern Matching Drives IBM i Performance Breakthrough

  June 9, 2021 Alex Woodie

  What do human diseases and IBM i performance problems have in common? For starters, they both can generate quite a bit of data. In the case of the humans, it was enough for IBM to train its AI technology, Watson, to find patterns buried in the data and come up with diagnoses. Now the Danish software company iPerformance is using a variation on that approach with GiAPA, its Global i Application Performance Analyzer.

  When iPerformance founder Kaare Plesner saw a demo of IBM Watson developing medical diagnoses, he figured a similar approach could work for sorting through the reams of …

  Read more

• Modern Tools For A Modern IBM i

  May 26, 2021 Alex Woodie

  IBM i shops may be in for a rude awakening when they suddenly realize their applications are not keeping up with the times. How can these IBM i shops get on the right track in the modernization department? A trio of IBMers offered some tips.

  Brad Bentley, Tim Rowe, and Kris Whitney took to the virtual airwaves last week to present “IBM Tools for Modernizing Your IBM i Applications,” a one-hour webinar from IBM. Application modernization is an extremely broad topic, as the 266-page IBM Redbook of the (almost) same name will attest to, so they obviously didn’t cover …

  Read more

• Guru: Generate SQL for Dependents

  May 24, 2021 Paul Tuohy

  Way back in October 2014, in the article Find A View Of A View Of A View. . ., I detailed a stored procedure that, given the name of a table or a view, provides the full list of dependent views and all of their dependents and all of their dependents, etc. This is a stored procedure that has served me well in the world of DDL, where it is common to have views of views of views.

  In this article I will describe a follow-on stored procedure that will generate the DDL for a given table/view and all …

  Read more

• Guru: Date Format Confusion

  May 10, 2021 Ted Holt

  Hey, Ted:

  I use the Copy to Import File (CPYTOIMPF) command to build a CSV file to be sent to a MySQL system. My colleagues are unable to import the file because of the format of a timestamp field. CPYTOIMPF puts a hyphen between the date and time (e.g. 2021-05-10-04.36.24.849555), but the other system wants a space between them. Other than writing a custom program do you know of another way to change the format of the timestamp output?

  — Richard

  You won’t need a custom program, Richard. There’s another way to handle this requirement.

  IBM has already very thoughtfully …

  Read more

• What’s New With BRMS, PowerHA, And Db2 Mirror

  April 28, 2021 Alex Woodie

  The latest IBM i Technology Refreshes (TRs) brought a number of enhancements to various parts of the operating system and related licensed products. That includes new stuff for its backup and recovery product, BRMS, as well as the two high availability offerings, PowerHA and Db2 Mirror.

  On the Backup and Recovery Media Services (BRMS) front, IBM added several new features with IBM i 7.4 TR4 and IBM i 7.3 TR10, including new SQL services that returns log information for BRMS activities. This new SQL service generates the same information that the Display Log for BRM (DSPLOGBRM) command does, but it …

  Read more

• Query Supervisor Gives Database Engineers New Power

  April 14, 2021 Alex Woodie

  One of the most exciting new features in the upcoming releases of IBM i 7.4 Technology Release (TR4) and 7.3 TR10 is the Query Supervisor. We recently caught up with Scott Forstie, IBM’s Db2 for i business architect, who gave us the low down on the new tech for controlling the database.

  Forstie told IT Jungle said that the Query Supervisor was the biggest new feature added to Db2 for i with IBM i 7.4 TR4 and 7.3 TR10, which IBM announced yesterday (see “IBM Unveils Spring 2021 Batch of TRs” for more news about the TRs).

  So, …

  Read more

• IBM Unveils New and Improved IBM i Services

  April 14, 2021 Alex Woodie

  If you like IBM i Services — those SQL-based methods for executing a range of tasks in the operating system — then you’re in luck, because IBM has included a handful of new and improved IBM i Services in the Technology Refreshes (TRs) for IBM i 7.4 and 7.3, which were unveiled yesterday and ship this Friday.

  IBM has developed an affinity for IBM i Services in the last few releases of the operating system. And why not? Users seem to like having a SQL-based alternative to CL commands and APIs. And since the IBM i Services are so easily …

  Read more

• IBM i PTF Guide, Volume 23, Number 14

  April 12, 2021 Doug Bidwell

  Apologies to all in the IBM i community for being late for putting together the IBM i PTF Guide last week. Sometimes real life interferes with business life, as you all know well. So this is a catch up issue of the Guide, with everything back on track with an update to get current coming out in this Wednesday’s issue of The Four Hundred.

  Editor’s Note: It goes without saying that we all owe a big hearty thanks to Doug Bidwell for his tireless efforts over many decades in keeping track of the patches for the firmware, operating …

  Read more

Previous Articles Next Articles