November 10, 2026
IBM has released the latest "IBM i on Power - Performance FAQ" dated June 2026.
The online PDF to it can be found here
Note: It is also listed on the "IBM i Extras" and "Performance" pages.
The IBM i 1 Stop Research Source for Administrators, Operators and more.
Sad Day for IBM i Nation
Nov 4, 2026
It is with profound sadness to report that Scott Klement, one of the most helpful, knowledgeable and famous IBM i professionals most of us have run into 1 way or another, has passed on. The link below is a tribute to Scott from @COMMON
IBM i ACS 1.1.9.17
Oct 20, 2026
IBM has announced an update to ACS (Access Client Solutions) from current
version 1.1.9.16 to new version 1.1.9.17
The announcement looks like this:
Info on ACS can be found on this blog on the "Helpful Tips by Category" page here.
Click open "IBM i Access - ACS Updates"
If your version of ACS is set to "Edit", "Preferences", "Notify when update is available":
The "IBM i Access Client Solutions" dialog box will be displayed showing
the Current Version and Available Version.
It will also be displayed when opening ACS and utilizing the Help Tab and "Check for Updates".
IBM i SQL's for Storage and System Mgmt
Oct 16, 2026
Good day everyone.
As most of the IBM i professionals know, there is an IBM i Guided Tours Site
dedicated to various IBM i Topics. The Guided Tour webinars are free and can be found on the IBM i Reference Pages Blog "IBM i Extras" page here.
Page down a bit to locate the Guided Tour links shown below.
You can sign up for the webinars that are of interest to you. Note that you will
have to register for a free COMMON account to access the replay webinars and
PDF slide decks.
I posted about the Guided Tours in July 2025 but wanted to mention it again. I was recently looking for something to help me on the job. I ran into a Guided Tour webinar from March 2026 presented by IBMer's:
@Ryan Moeller - Advisory Software Engineer
@Ann Wilkerson - Software Developer
The Guided Tour they presented was IBM i SQL for Storage and System Mgmt.
Click the highlighted link above to access this webinar. Included with this webinar was a 60 page PDF of helpful, ready to use SQL's to help you manage your system(s).
I've included this link which will open the PDF slide deck.
Note: It is on google drive but you should be able to open the link.
The first page of the PDF slide deck looks like this:
This is IBM i SQL material that should not be missed.
The webinar is described as follows:
"Discover practical and powerful ways to manage IBM i environments in this Guided Tour, SQL for System and Storage Management, presented by industry experts Ann Wilkerson and Ryan Moeller. In this session, they walk you through real-world SQL techniques that simplify monitoring, enhance visibility into system performance, and streamline storage management. Whether you're strengthening your SQL skills or looking for smarter, more efficient approaches to system administration, this guided tour offers clear, actionable insights you can begin using immediately in your IBM i operations."
Enjoy, MM
Please contact me via the blog if the PDF slide deck link does not work.
IBM i CVE SQL - V7R5 TR8, V7R6 TR2 Minimum to Run
Oct 14, 2026
Good day everyone.
This IBM i CVE SQL was posted to LinkedIn by Leonardo Villalobos Prieto, IBM i Security Subject Matter Expert out of Santiago, Chile. Leonardo works for Grupo Clip.
I think you'll find it most helpful when researching IBM i CVE's (Common Vulnerability Exposures) on your IBM i. Your system very well could be required to be protected from the CVE's you'll find.
This is reposted with his permission. Copy / paste into ACS Run SQL Scripts or
on the 5250 STRSQL screen.
=========================================================================
-- Script: Query for Vulnerabilities Unique to Pure HTTP (IBM i)
-- Range: Last 6 Months (Excluding WebSphere and Liberty)
=========================================================================
SELECT
CVE_ID,
SCORE,
PUBLISH_DATE,
MODIFICATION_DATE,
PRODUCT_NAME,
TITLE,
IBM_SUPPORT_URL,
SUMMARY
FROM TABLE
(SYSTOOLS.CVE_INFO()) AS x
-- Filter by last 6 months
WHERE PUBLISH_DATE >= CURRENT DATE - 6 MONTHS
-- Filter only mentions to HTTP
AND(
UPPER(PRODUCT_NAME) LIKE '%HTTP%'
OR UPPER(TITLE) LIKE '%HTTP%'
OR UPPER(SUMMARY) LIKE '%HTTP%'
)
-- Explicitly exclude any traces of WebSphere or Liberty
AND UPPER(PRODUCT_NAME) NOT LIKE '%WEBSHERE%'
AND UPPER(PRODUCT_NAME) NOT LIKE '%LIBERTY%'
AND UPPER(TITLE) NOT LIKE '%WEBSHERE%'
AND UPPER(TITLE) NOT LIKE '%LIBERTY%'
ORDER BY
-- Sort first by criticality and then by most recent date
CASE SCORE
WHEN 'Critical' THEN 1
WHEN 'High' THEN 2
WHEN 'Medium' THEN 3
WHEN 'Low' THEN 4
ELSE 5
END,
PUBLISH_DATE ASC;
-- Script: Query for Vulnerabilities Unique to Pure HTTP (IBM i)
-- Range: Last 6 Months (Excluding WebSphere and Liberty)
=========================================================================
SELECT
CVE_ID,
SCORE,
PUBLISH_DATE,
MODIFICATION_DATE,
PRODUCT_NAME,
TITLE,
IBM_SUPPORT_URL,
SUMMARY
FROM TABLE
(SYSTOOLS.CVE_INFO()) AS x
-- Filter by last 6 months
WHERE PUBLISH_DATE >= CURRENT DATE - 6 MONTHS
-- Filter only mentions to HTTP
AND(
UPPER(PRODUCT_NAME) LIKE '%HTTP%'
OR UPPER(TITLE) LIKE '%HTTP%'
OR UPPER(SUMMARY) LIKE '%HTTP%'
)
-- Explicitly exclude any traces of WebSphere or Liberty
AND UPPER(PRODUCT_NAME) NOT LIKE '%WEBSHERE%'
AND UPPER(PRODUCT_NAME) NOT LIKE '%LIBERTY%'
AND UPPER(TITLE) NOT LIKE '%WEBSHERE%'
AND UPPER(TITLE) NOT LIKE '%LIBERTY%'
ORDER BY
-- Sort first by criticality and then by most recent date
CASE SCORE
WHEN 'Critical' THEN 1
WHEN 'High' THEN 2
WHEN 'Medium' THEN 3
WHEN 'Low' THEN 4
ELSE 5
END,
PUBLISH_DATE ASC;
=========================================================================
The results will look something like this - Remember, V7R5, TR8 or V7R6 TR2 minimum OS / TR level needed to run. The SQL returns data about vulnerabilities for HTTP.
Click to open the results picture.
IBM i 2027 FORTRA Marketplace Survey
Sept 14, 2026
Good day everyone.
It is THAT time of year - The 2027 FORTRA IBM i Marketplace Survey is now open.The survey runs from Monday, Sept 14, 2026 through Friday, Nov 20, 2026.
From AI and cybersecurity to modernization and cloud strategy, the insights gathered from this survey help tell the story of the IBM i community.Your voice matters!
Share your experience and help shape this year's industry insights.
Start the survey here.
IBM i ACS Version 1.1.9.16
Sept 11, 2026
IBM has announced an update to ACS (Access Client Solutions) from current
version 1.1.9.15 to new version 1.1.9.16
The announcement looks like this:
Info on ACS can be found on this blog on the "Helpful Tips by Category" page here.
Click open "IBM i Access - ACS Updates"
If your version of ACS is set to "Edit", "Preferences", "Notify when update is available":
The "IBM i Access Client Solutions" dialog box will be displayed showing
the Current Version and Available Version.
It will also be displayed when opening ACS and utilizing the Help Tab and "Check for Updates".
IBM i User Profile Analysis Using QSYS2.USER_INFO
August 26, 2026
Like many of you, I receive IBM Notifications via email multiple times per day. The IBM Notification Page can be found here.
Take advantage of this if you haven't already.
Sign up:
- Select IBM products in which you are interested.
- Choose daily or weekly notifications.
- Select a delivery method: e-mail and/or RSS news feed.
- Choose daily or weekly notifications.
- Select a delivery method: e-mail and/or RSS news feed.
In a recent notification, a topic and link about "IBM i User Profile Analysis" was presented. There is a lot of good material to review. Many admins already have SQL's and queries relating to this topic.
IBM summarizes the page as follows:
"IBM i User Profile Analysis Using QSYS2.USER_INFO explains how IBM i security administrators can use SQL services to audit and analyze user profiles across the system".
"The document focuses on the QSYS2.USER_INFO view, which provides detailed information about all user profiles defined on an IBM i partition. By combining this view with related services such as QSYS2.GROUP_PROFILE_ENTRIES and SYSTOOLS.AUDIT_JOURNAL_CP, administrators can perform comprehensive security reviews directly through SQL, eliminating the need for traditional green screen commands and manual profile inspections."
The link to the QSYS2.USER_INFO page can be opened here.
There are 12 SQL's listed with related IBM i Services and References including
composed SQL's that can copied off of the page and used. There is also recommended action for each SQL.
NOTE: Read the comments at the top of the SQL's. They show the V7Rx OS
the SQL's can be run on. In a couple of cases, I could comment out a field
on a V7R4 partition and get the SQL to run where it indicated it was a V7R5 / V7R6
SQL. Simple enough.
IBM i SQL Services
August 23, 2026
On Wednesday, August 19th, IBM STSM @Scott Forstie ran a webinar titled
"What’s New in IBM i Access Client Solutions: Modern Tools for Accessing, Managing, and Innovating with IBM i". It might have been 1 of the most informative webinars this year.
A replay of that webinar can be found on the 2026 IBM i Guided Tours replay website
here. Note that the IBM i Guided Tours site can be accessed here. IBM i Guided Tours are free, just register for them. To view a Guided Tour replay, registering with COMMON.org is required. That is free.
One of the best parts of the webinar was spent on IBM i SQL System Services.
The IBM i SQL Services page can be found here.
IBM Lifetime Champion @Pete Massiello recently composed an outstanding LinkedIn
post about these services. That post can be opened here with his permission.
This is free IBM i material at it's finest.
If you have IBM i Access Client Solutions, the IBM i SQL Services can be found
as follows:
Bring up ACS and open "Run SQL Scripts".
Open the "Edit" tab, then "Examples", "Insert from Examples".
This will be displayed:
Use the down arrow indicated to open a dialog box of choices.
Open "IBM i Services" and this will be presented:
There are hudreds of IBM i SQL Services. Scroll through, click on any of them
to open an SQL Service that can be run as needed.
An example, would be "Work Management - Active Job Info - Largest Query".
Open that selection and copy it into an open Run SQL Scripts session. The SQL looks like this:
SELECT JOB_NAME, LARGEST_QUERY_SIZE, J.*
FROM TABLE(QSYS2.ACTIVE_JOB_INFO(
subsystem_list_filter => 'QUSRWRK',
job_name_filter => 'QZDASOINIT',
detailed_info => 'ALL')) J
ORDER BY LARGEST_QUERY_SIZE DESC
LIMIT 10;
The result will look something like this:
IBM i ACS Version 1.1.9.15
Aug 22, 2026
IBM has announced an update to ACS (Access Client Solutions) from current
version 1.1.9.14 to new version 1.1.9.15
The announcement looks like this:
Info on ACS can be found on this blog on the "Helpful Tips by Category" page here.
Click open "IBM i Access - ACS Updates"
If your version of ACS is set to "Edit", "Preferences", "Notify when update is available":
This dialog box will be displayed when ACS is opened.
It will also be displayed when opening ACS and utilizing the Help Tab and "Check for Updates".
Modernizing IBM i Applications
August 13, 2026
This was brought to my attention by several IBM i professionals. Shout-out to IBM Champion @Steve Bradshaw of Rowton IT Solutions Ltd for posting about this on LinkedIn.
It is the "Modernizing IBM i Applications" Redbook. It was published on Aug 10, 2026. The list of contributors to this Redbook reads like a Who's Who of IBM i Expertise. This IBM i material is subject matter that should not be missed.
The Redbook can be opened here
The Modernization Model - courtesy of the "Modernizing IBM i Applications"
IBM i ACS Version 1.1.9.14
Aug 8, 2026
IBM has announced an update to ACS (Access Client Solutions) from current
version 1.1.9.13 to new version 1.1.9.14
The announcement looks like this:
Info on ACS can be found on this blog on the "Helpful Tips by Category" page here.
If your version of ACS is set to "Edit", "Preferences", "Notify when update is available":
This dialog box will be displayed when ACS is opened.
It will also be displayed when opening ACS and utilizing the Help Tab and "Check for Updates".
IBM i Performance Page
July 24, 2026
A new page has been added to this blog. It is the IBM i Performance Page.
It can be found on the right side of the blog under "IBM i Pages" list or here.
The page looks like this:
If you have anything to add to this page related IBM i performance, please
reach out via the contact form.
IBM i "Bob" Issues Site
July 23, 2026
This site was brought to my attention by several IBM i professionals.
It is the IBM "Bob" GitHub Issues Site. It can found here.
I have added the link to that page on both the IBM i Reference Pages Blog
"Bob and MCP Server" page and the "GitHub Resources Collection" page.
It looks like this:
Announcing the IBM "Bob" Premium Package for i
July 9, 2026
IBM "Bob" Announcement
"Today, IBM is announcing the general availability of the IBM "Bob" Premium Package for i, bringing AI-Powered development and modernization capabilities directly to IBM i teams."
The entire announcement can be found here.
IBM "Bob" Meets IBM - Courtesy of @Sanjula Gonepola
"Bob" pricing can be found here.
IBM i on Power - Performance FAQ: June 2026
July 2, 2026
IBM has released the latest "IBM i on Power - Performance FAQ" dated June 2026.
The online PDF to it can be found here
Note: It is also listed on the "IBM i Extras" page.
IBM Bob Advocate 2026 Badge
June 26, 2026
Introducing the IBM Bob Advocate 2026 Badge: Recognizing Advocacy that Drives Momentum.
Per @Kathryn DuPont - IBM User Advocacy Team - "
IBM Bob is gaining momentum and community advocacy plays a critical role in that growth.
"Meet the IBM Bob Advocate Badge here
Subscribe to:
Posts (Atom)