Find the Technology Refresh (TR) level of an IBM i

Update: I have since learned that the “PTF” IBM i Service (DB2 and SQL) provides one’s TR level more cleanly than with other approaches. I read of the improved approach in an article by Tim Rowe: https://systemideveloper.com/blogs/db2-for-i-services-use-sql-instead-of-system-apis/ by way of Club Seiden member PHP Dave.

IBM i services comprise a collection of DB2 and SQL objects that provide a wealth of system information. The GROUP_PTF_INFO view, for example, will display an IBM i’s Technology Refresh (TR) level to the user who runs this SQL:

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?

Here was the original post with older techniques:

I recently needed to know if a client’s IBM i 7.1 system had Technology Refresh 4 (TR4). If it did, I could use the relatively new INSERT with remote SUBSELECT technique, which allows a single SQL statement to copy DB2 data from one partition to another. Such are the benefits of keeping current with Technology Refreshes.

After reading an article on TRs by Steve Will, I decided to document how to determine which TRs are installed on an IBM i system.

TRs, which were introduced with IBM i 7.1, are packaged as Program Temporary Fixes (PTFs). They can be found with the DSPPTF command.

First, determine the product number of the licensed internal code of  your system. For 7.1, the product number is 5770999.

Then use the DSPPTF command followed by this product number. For example:

DSPPTF 5770999

When run on my test system, this command produced a list of PTFs that included MF99007, MF99006, MF99005, MF99004, MF99003, MF99002, and MF99001.

Because Technology Refresh PTF numbers follow the format MF99nnn, where nnn is the TR number (bolded above), I knew that TR7, TR6, TR5, TR4, TR3, TR2, and TR1 were available. I was pleased to learn I could use TR4’s enhancements to DB2.

8 replies
  1. Alex
    Alex says:

    Hi guys,

    we had a controversy with this as I always used the WRKPTFGRP command and we called IBM.
    This is wrong, the MF99xxxx PTFs just enables you yo have the TR, it does not mean you have the TR.
    The actual TR for V7.1 is on SF99707 (WRKPTFGRP and see the level on SF99707).
    Hope it helps.

    Alex.

    Reply
  2. stefant
    stefant says:

    Excellent, I faced the challenge to validate the interoperability between my Storwize v7000 & the OS400 required PTF/TR level

    Reply
  3. Rozé Olivier
    Rozé Olivier says:

    Hi guys.

    I think there is something misunderstood : If I read http://m.ibm.com/http/www-947.ibm.com/systems/support/i/planning/techrefresh/faqs.html

    DSPPTF 5770999 for “How do I determine whether the Technology Refresh PTF is installed on a system, and what level is installed?”

    and

    WRKPTFGRP SF99707 for “How do I determine whether the Technology Refresh PTF Group is installed on a system, and what level is installed?”

    So DSPPTF for level installed, and WRKPTFGRP for GRPPTF installed.

    I think you can be in TR10 (MF99010 installed in DSPPTF 5770999) but not have SF99707 installed in WRKPTFGRP.

    Olivier.

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

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