by Andrea | 8 February 2026 | IBM i, Programming, Sql Tricks & Tools, System Management
I often find myself needing to run several commands in QSH, and I have now found an alternative way to do this compared to the classic bash scripts. Once again, SQL comes to our aid. Now, using QSH in batch mode is very simple but requires a little attention. In our...
by Andrea | 25 January 2026 | IBM i, Sql Tricks & Tools, System Management
This week, a customer opened a ticket complaining that there were too many job logs on their system… this meant that when a user searched for their print job with WRKSPLF, they were inundated with a considerable number of job logs, making it difficult to find the...
by Andrea | 17 January 2026 | IBM i, Programming, System Management
During the Christmas holidays, between various lunches with relatives, an outing, and, of course, some rest, I had the opportunity to rework the Code4i FS extension a bit. It was very challenging in that it allowed me to learn a new language, TypeScript, and to learn...
by Andrea | 2 January 2026 | IBM i, Sql Tricks & Tools, System Management
System security is becoming one of the most important issues that IT managers have to deal with. This also applies to IBM i systems. In fact, the days when the only access to systems was via a terminal are long gone. Now systems are at the center of complex ecosystems...
by Andrea | 6 December 2025 | IBM i, Programming
This week, the wait is finally over… a few weeks after signing up for the demo, BOB has finally arrived, and I have the chance to try it out in advance. For those who are not yet familiar with it, BOB is a new IDE owned by IBM. It is not a completely new IDE; in...
by Andrea | 16 November 2025 | IBM i, Sql Tricks & Tools, System Management
It is quite common to have customers with specific backup requirements, such as changing the expiration date of the tape used based on the day of the month or year for tax purposes. For this reason, it is always complicated to have standard jobs or calendars with a...
by Andrea | 8 November 2025 | IBM i, Sql Tricks & Tools
I often find myself in a situation where I have several different systems and need to extract data from all of them by running queries from a single partition. Well, there is a DB2 for i function that allows you to run SELECT SQL on remote machines. What do we need?...
by Andrea | 8 October 2025 | IBM i, Programming, Sql Tricks & Tools
A few days ago, a customer opened a case with me because he couldn’t understand the origin of the locks that were occurring on certain objects. In fact, this lock condition was causing problems for the application procedures, which clearly found the files busy...
by Andrea | 29 September 2025 | IBM i, Programming, Sql Tricks & Tools
A few articles ago, we talked about the native integration of the syslog format within IBM i. We also looked at two SQL services (the history log and the display journal) that were able to generate data in this format in a simple way. Today, in this article, I propose...
by Andrea | 7 September 2025 | AIX, IBM i, Linux
These days, I am preparing documentation for an event I will be holding on 1 October concerning security on IBM i systems. One of the things that still amazes me about the use of IBM i systems is the huge number of customers who still use unencrypted protocols, such...
