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.
