IBM Power 11 Performance Optimization for IBM i
TOOLS/400
@Tools/400 is a collection of freeware for IBM i. It is the home of plug-ins for IBM Rational Developer for i, of the Peek/400 file editor and of many utilities and service programs for RPG and CL.
All tools are free and open source. Sources, releases and issue trackers are on the GitHub Tools/400 Site.
Tools/400 can also be found on the IBM i Reference Pages Blog Vendor and Resources Page here.
The main page looks like this:
IBM i on Power - Performance FAQ: November 2026
IBM has released the latest "IBM i on Power - Performance FAQ" dated November 2026.
The online PDF to it can be found here
Note: It is also listed on the "IBM i Extras" and "Performance" pages.
Sad Day for IBM i Nation
IBM i ACS 1.1.9.17
IBM i SQL's for Storage and System Mgmt
IBM i CVE SQL - V7R5 TR8, V7R6 TR2 Minimum to Run
-- 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;
IBM i 2027 FORTRA Marketplace Survey
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.
IBM i ACS Version 1.1.9.16
IBM i User Profile Analysis Using QSYS2.USER_INFO
- Choose daily or weekly notifications.
- Select a delivery method: e-mail and/or RSS news feed.
IBM i SQL Services
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;
IBM i ACS Version 1.1.9.15
Modernizing IBM i Applications
IBM i ACS Version 1.1.9.14
Info on ACS can be found on this blog on the "Helpful Tips by Category" page here.


















