Last Updated on 11 September 2025 by Roberto De Pedrini
I’d like to share with you this interesting post by Massimo Duca, the first in a series of articles dedicated to SQL on IBM i.
In this contribution, Massimo shows how to leverage the QSYS2.OBJECT_STATISTICS table to identify objects in specific libraries that have not been used for a long time, filtering them by their last used date.
All the code in the post is available on Github!
A practical and immediately applicable example, very useful for anyone looking to do some “housekeeping” in their environments and keep object usage under control.
👉 Read the full post on LinkedIn:
IBM i & SQL Tips – Massimo Duca
Introduction Often, in our applications, we need to work with text strings, and DB2 SQL can come in very useful Read more
DB2 Database and SQL ... maybe the most important things on IBM i platform: here's a collection of FAQs, tips Read more
Comes directly with the Easter egg this IBM announcement for the news of the IBM i 7.4 version, iNext version Read more
Introduction "Generated Always Column": are columns, table fields, filled by DB2 engine: something like columns with a default value but Read more
