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