by Andrea | 24 February 2025 | IBM i, Programming, Sql Tricks & Tools, System Management
In the last post, we have seen how to manage defective PTFs automatically using SQL.Today, we will see how it’s easy to check current PTFs level directly from IBM servers. Let me say that is quite important to keep systems update, both in terms of version and...
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 | 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 | 3 January 2025 | IBM i, Sql Tricks & Tools
Oh yes, playing with SQL on an IBM i system can reserve more and more fun. SQL on these systems can also help sysadmin (as me) that not know perfectly how to program in RPG & co. to optimize day by day activities; that because since V7R3M0 IBM invests a lot in...
