The IBM i Reference Pages Blog: August 2026

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.

- Select IBM products in which you are interested.
- 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:

Take advantage of these free services. It's a great way to look deeply into your systems.

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"