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...