• IBM i PTF Guide, Volume 26, Number 1

  January 15, 2024 Doug Bidwell

  Well, there are two new security vulnerabilities in the IBM i stack, as we report elsewhere in this issue of The Four Hundred. And there is also an update to the System Planning Tool. Let’s do the latter first and the former last.

  The System Planning Tool, version 6.23.340, is now available for download at this link. The System Planning Tool is used by customers and business partners to build valid system configurations for Power Systems machines and their software stacks. You can look at the release notes for various SPT generations here.

  Now on to the …

  Read more

• 2023: An IBM i Year in Review

  December 13, 2023 Alex Woodie

  With another year nearly in the books, it’s time to take a stroll through the IT Jungle archives and reconsider some of the 728 stories we published in 2023. Here’s a look back at the biggest IBM i news stories of 2023.

  January

  The top concern of IBM i professionals, according to Fortra’s annual IBM i Marketplace Study, was once again security, a position it has held for six straight years. The latest crop of IBM Champions unveiled in January featured about 90 members from the IBM i community, out of a total of 839 for the year. Is …

  Read more

• ACS, Merlin Hit With Serious Security Vulnerabilities

  December 11, 2023 Alex Woodie

  Three serious security vulnerabilities in IBM i Access Client Solutions and six in Merlin were disclosed and patched by IBM last week. The flaws could allow attackers to commit a range of crimes, from executing arbitrary code and denial of service attacks, to obtaining sensitive data on IBM i conducting phishing attacks. All of the flaws – including another three reported by IBM in November – should be patched immediately.

  IBM published a security bulletin December 8 covering all three of the ACS flaws, which impact ACS versions 1.1.2 through 1.1.4 and 1.1.4.3 through 1.1.9.3. The fix is to download …

  Read more

• IBM i PTF Guide, Volume 25, Number 50

  December 11, 2023 Doug Bidwell

  Well, there are two new security vulnerabilities in the IBM i stack, as we report elsewhere in this issue of The Four Hundred. And there is also an update to the System Planning Tool. Let’s do the latter first and the former last.

  The System Planning Tool, version 6.23.340, is now available for download at this link. The System Planning Tool is used by customers and business partners to build valid system configurations for Power Systems machines and their software stacks. You can look at the release notes for various SPT generations here.

  Now on to the …

  Read more

• Fall 2023 IBM i Tech Refresh Brings Something For Everyone

  October 11, 2023 Alex Woodie

  As expected, IBM yesterday unveiled its fall Technology Refresh (TR) for IBM i, with updates starting to become available on November 17. IBM announced no new products as part of the fall 2023 TR cycle, but it did spread the love around by giving just about everybody something to cheer about in IBM i 7.5 TR3 and 7.4 TR9.

  Lots of different products that make up the IBM i environment will see some pretty meaningful enhancements with this release. If you spend a lot of time in Navigator for i or ACS, you will see new stuff. We haven’t had …

  Read more

• New Run SQL Scripts Features in ACS Update

  August 23, 2023 Alex Woodie

  If you’re a fan of the Run SQL Scripts features in IBM i Access Client Solutions, then there’s good news: IBM has adopted several suggestions on how to improve the functionality in the latest release of ACS.

  IBM quietly released ACS version 1.1.9.3 last month, enabling a series of new functions in the popular Java-based utility used by IBM i professionals to interact with the platform, as well as a handful of fixes.

  At the top of the list, according to an IBM Support document on the new release, are enhancements to Run SQL Scripts (RSS), the handy facility that …

  Read more

• IBM i PTF Guide, Volume 25, Number 32

  August 7, 2023 Doug Bidwell

  Here is what is new: A new “version” of Access Client Solutions (ACS) is available for download, catch the link in the Guide. (Your “Check for Update” won’t catch it, and you won’t see the version until you get all the way into the ACS Main window, and do the Help/About.) This is an updated version, no change to the ODBC driver. This version of ACS uses the IBM GSKit version 8.0.55.31 with the latest security updates.

  This is important: Prior versions of ACS have security defects. Specifically, Security Bulletin: IBM i Access Client Solutions – Windows Application Package is …

  Read more

• Guru: Comparing IFS Directories Using SQL

  June 19, 2023 Mike Larsen

  I use SQL almost every day at my job. It may be just a query in ACS, or it may be embedded SQL in an RPG program. A few days ago, I needed to compare the contents of one IFS directory to another. Combining a few different table functions, I was able to develop a nice solution.

  Note: The code for this article can be downloaded here.

  In this example, I have a directory that has five text files in it. I have a second directory that has three text files in it, and they are the same documents …

  Read more

• Entry Servers: IBM i Versus Windows Server, Redux

  April 10, 2023 Timothy Prickett Morgan

  No comparison between similar but different things is ever perfect. It is the nature of language, constructed of similes and metaphors, as well as science, which speaks in generalities but craves ever-finer precision. It is no different when trying to compare different system platforms, which we do quite often around here at The Four Hundred and have for three and a half decades.

  The comparison between the Power S1022s running IBM i and a Dell PowerEdge R7515 running Windows Server and SQL Server, which we did last week, needed some refinement, I learned from an intrepid reader who reminded …

  Read more

• IBM i PTF Guide, Volume 25, Number 4

  January 23, 2023 Doug Bidwell

  Here are some reminders to start off the IBM i PTF Guide this week.

  First, there are new releases for Access Client Solutions and the ODBC database driver. (See ACS_NAV in the Guide for the links.) The funny bit – funny odd, not funny hilarious – is that version 26 of ACS did not allow companies to create a database source for ODBC, which is serious shortcoming. Now, there is a new version 27 that will let you do it. Here is the updated software:

  Description				   Version
  IBM i Access Client Solutions (1.1.9.1)	   1.1.9.1
  ACS Windows App Pkg English (64bit)	   

  …

  Read more

Previous Articles Next Articles