by Andrea | 17 February 2025 | IBM i, Programming, Sql Tricks & Tools, System Management
Several days ago, I opened a ticket to the IBM support for a problem that was affecting one of my production lpar. The technician ask me to generate a System Snapshot and once uploaded to website an automatic agent warned me about a defective PTF that was installed on...
by Andrea | 4 February 2025 | IBM i, System Management
In the last post, I’ve presented a simple way to monitor some particular metrics of your IBM i. In addition to system monitors, you can go for message and queue monitoring. It is often the case that some information about the status of some system services as...
by Andrea | 20 January 2025 | IBM i, System Management
One of the most important allies of a sysadmin is a good monitoring system. In this first tutorial, I will show you how it’s so easy implementing an IBM i system monitor using features that are already included in the OS without using third part software. To do...
by Andrea | 8 January 2025 | IBM i, Sql Tricks & Tools, System Management
One of the dream of sysadmins is monitoring system SQL usage, to check how much temporary storage is used by SQL statements, to check long-running SQL statements and so on. Daily, in my job I am able to see a lot of situations in which user run a lot of SQL statements...
by Andrea | 30 December 2024 | IBM i, System Management
In IBM i a lot of attention is given to startup programs… we all love our QSTRUPs, but not so much people give the right attention to shut down programs. As you can understand, shutdown programs are a program that will be executed when our IBM i system is powered off....