To Rob's point a bit further, " .... Basically you will never get the ability to check individual ptf currency with IBM the way you can check group PTF currency because they will never put the listing of PTF's available at IBM in a xml document consumable by a individual ptf currency service. Reasoning being: "Our platform strategy is for clients to manage IBM i by PTF Groups, not individual PTFs. .... "
On the front page of my IBM i Reference blogspot page are 2 SQL's that can be used to check PTF Group's on your system vs PTF's Group's available FOR your system.
Note: These will run in green screen STRSQL or ACS Run SQL Scripts.
The CCSID of the user profile must be set to 37 on the green screen.
These work on a V7R2 system and should run on V7R3 / R4.
SQL 1:
with ilevel (iversion, irelease) as (
select os_version, os_release
from sysibmadm.env_sys_info
)
select Row_Number() over (Order by ptf_group_level_available - ptf_group_level_installed desc, ptf_group_id) as "Row #", p.* from ilevel, systools.group_ptf_currency p where ptf_group_release = 'R' concat iversion concat irelease concat '0'
order by "Row #"
or
SQL 2:
Select Row_Number() over (ORDER BY PTF_GROUP_CURRENCY DESC, PTF_GROUP_ID ASC) as "Row #",
PTF_GROUP_CURRENCY, PTF_GROUP_ID,
PTF_GROUP_TITLE, PTF_GROUP_LEVEL_INSTALLED,
PTF_GROUP_LEVEL_AVAILABLE,PTF_GROUP_LAST_UPDATED_BY_IBM,
PTF_GROUP_RELEASE, PTF_GROUP_STATUS_ON_SYSTEM
From SYSTOOLS.GROUP_PTF_CURRENCY
Very Respectfully,
Michael Mayer
IBM i on Power System Admin.
IT Operations.
The Florida Bar
Tallahassee, Florida 32399-2300
mmayer@xxxxxxxxxxxxxx
https://www.floridabar.org
Office: 850.561.5761
Cell: 518.641.8906
IBM i Personal Blog Page:
https://ibmireference.blogspot.com/
-------------------------------------------------------------------------------------------------
message: 1
date: Thu, 10 Mar 2022 15:31:13 +0000
from: Rob Berendt <rob@xxxxxxxxx>
subject: RE: Product ID for PTFs
On a closely related note see also:
https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=88260
Basically you will never get the ability to check individual ptf currency with IBM the way you can check group PTF currency because they will never put the listing of PTF's available at IBM in a xml document consumable by a individual ptf currency service. Reasoning being: "Our platform strategy is for clients to manage IBM i by PTF Groups, not individual PTFs."
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com
------------------------------
------
________________________________
Please note: Florida has very broad public records laws. Many written communications to or from The Florida Bar regarding Bar business may be considered public records, which must be made available to anyone upon request. Your e-mail communications may therefore be subject to public disclosure.
midrange.com
