As we've discussed, yes, the "ilevel" SQL came from ACS examples. I just added a bit to it to give a row # and as I said previously, there are 2 versions of it
on my blog page. I thought the row # added a bit to it. I'm into aesthetics, what can I say ... lol.
https://
https://ibmireference.blogspot.com/
SQL that displays the PTF Groups Installed vs PTF Groups Available.
Note: This 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.
Note2: This was run on a V7R2 partition but will also run on V7R3, V7R4.
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
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
651 E. Jefferson St
Tallahassee, Florida 32399-2300
mmayer@xxxxxxxxxxxxxx
https://www.floridabar.org
Office: 850.561.5761
Cell: 518.641.8906
IBM i peroansl blog page:
1. Re: Product ID for PTFs (Gad Miron)
2. RE: Product ID for PTFs (Rob Berendt)
3. RE: Product ID for PTFs (Rob Berendt)
----------------------------------------------------------------------
message: 1
date: Mon, 14 Mar 2022 11:50:04 +0200
from: Gad Miron <gadmiron@xxxxxxxxx>
subject: Re: Product ID for PTFs
Reading the emails exchanged here
I had a vague memory of a way to check if you're current on your Group PTFs using SQL,
Found it.
With iLevel(iVersion, iRelease) AS (select OS_VERSION, OS_RELEASE from
sysibmadm.env_sys_info ) SELECT P.* FROM iLevel,
systools.group_ptf_currency P WHERE ptf_group_release = 'R'
CONCAT iVersion CONCAT iRelease concat 0 ORDER BY ptf_group_level_available , ptf_group_level_installed DESC
This is taken from here:
https://powerwire.eu/how-to-get-the-new-navigator-for-i
It should make managing PTFs a bit easier.
Gad
------------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------------
message: 2
date: Mon, 14 Mar 2022 11:17:44 +0000
from: Rob Berendt <rob@xxxxxxxxx>
subject: RE: Product ID for PTFs
Try this also
IBM i Access Client Solutions
Run SQL Scripts
Symbol with SQL and two green arrows but no yellow
- or -
Edit, Examples, Insert from Examples
- or -
Ctrl-I
IBM i Services
PTF - Group PTF Currency
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
-----------------------------------------------------------------------------------
message: 3
date: Mon, 14 Mar 2022 11:27:45 +0000
from: Rob Berendt <rob@xxxxxxxxx>
subject: RE: Product ID for PTFs
See also:
select *
from QSYS2.SERVICES_INFO
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
