by Andrea | 4 October 2026 | IBM i, System Management
Recently, a client came to me after a penetration test with a short report and a long list of red lines. Most of them pointed to the same thing: ports 8470 to 8476 open on the IBM i, accepting connections in clear text. His question was simple: how do I protect the...
by Andrea | 27 August 2026 | IBM i, Sql Tricks & Tools, System Management
Sooner or later the question arrives, usually from an auditor or from a security team that has just discovered your IBM i exists: which known vulnerabilities affect this system, and are we covered? Answering it by hand is not hard, it is just tedious. You open the IBM...
by Andrea | 14 July 2026 | IBM i, Sql Tricks & Tools, System Management
Recently, a client came to me with a request that sounds trivial but is actually quite common: he wanted to know which jobs had passed through one specific subsystem, and when. Not the jobs running right now, anyone can get those with WRKSBSJOB, but the full history:...
by Andrea | 28 June 2026 | IBM i, Programming, Sql Tricks & Tools, System Management
Recently, a client reported performance issues with some of his new SQLRPGLE programs that were retrieving data via REST APIs provided by the other party. Now, after doing a bit of analysis, we immediately identified the cause of that slowness: the SYSTOOLS HTTP...
by Andrea | 3 June 2026 | IBM i, Programming, Sql Tricks & Tools, System Management
Managing objects in the IBM i QSYS file system has always been a challenge. The traditional approach requires switching between multiple CL commands ‘WRKOBJ’, ‘WRKJOB’, ‘WRKSPLF’, ‘DSPOBJ’, each with its own interface...
by Davide Caputo | 20 May 2026 | IBM i, Sql Tricks & Tools, System Management
I often find myself in situations that require quick action and a strong commitment to system analysis. When there is a sudden spike in system temporary storage growth—often caused by an abnormal increase in temporary storage consumption—it becomes difficult to...
