Use an IBM i Service to Find Your TR Level

i for BusinessWith another new IBM i Technology Release upon us, here’s a quick reminder how to find your server’s current TR level.

It’s getting easier and easier to do. An IBM i Service using DB2 and SQL provides the TR level more cleanly than older approaches. I love that we can use the universal SQL to expose the innards of our beloved system!

IBM i services comprise a collection of DB2 and SQL objects that provide a wealth of system information, not just your TR level.

The GROUP_PTF_INFO view is the service that displays an IBM i’s Technology Refresh (TR) level to the user who runs this SQL statement:

SELECT CURRENT SERVER CONCAT ' is running ' CONCAT PTF_GROUP_TARGET_RELEASE 
CONCAT ' with TR level: ' CONCAT PTF_GROUP_LEVEL AS TR_LEVEL 
FROM QSYS2.GROUP_PTF_INFO WHERE PTF_GROUP_DESCRIPTION = 'TECHNOLOGY REFRESH' 
AND PTF_GROUP_STATUS = 'INSTALLED' ORDER BY PTF_GROUP_TARGET_RELEASE DESC 
FETCH FIRST 1 ROWS ONLY

When run on my server, the result was a single column, TR_LEVEL, with the value:

SEIDENI is running V7R2M0 with TR level: 3

Time for me to upgrade, yes?

This entry was posted in IBM i, System i. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *