by Andrea | 12 November 2026 | IBM i, System Management
Recently, a client’s security team submitted a request to me that seemed straightforward: every security event on the IBM i must be logged in their SIEM, in near real time, along with the logs from all the company’s other servers. The IBM i already logs everything... by Andrea | 12 October 2026 | IBM i, Sql Tricks & Tools
If someone were to ask me what I really love about IBM Bob, it’s not so much the code generation as the inclusion of the Premium Package for IBM i. Some people describe it as a simple connector that lets you connect directly to the system, analyze the source code, and... 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...