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?