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... by Andrea | 17 April 2026 | IBM i, Sql Tricks & Tools, System Management
I often find myself needing to search through tape catalogs to locate specific libraries or datasets, and manually reviewing DSPTAP spool files for each tape becomes tedious very quickly. So I decided to wrap the DSPTAP command in a SQL table function to make batch... by Andrea | 14 March 2026 | IBM i, Programming
In today’s article, we will see how it is possible to integrate an MCP server installed directly on IBM i with BOB, and yes, it can be done with very interesting results. An MCP (Model Context Protocol) server is middleware that allows you to define a set of... by Andrea | 7 March 2026 | IBM i, Programming
A few weeks ago, I wrote an article about BOB in which I talked about my initial experience and how I had used it in Java. Now, some time later and after reaching the $200 ceiling, let’s talk about support for typical IBM i languages, RPG, and CL. We are still a... by Andrea | 22 February 2026 | IBM i, System Management
The ACS tool is very convenient and rich in features that go beyond simple 5250 emulation. In fact, this tool can be used to perform database management and maintenance operations, transfer IFS data or database files rather than spools. These are some of its...