Re: Check PTFs currency (up-to-date-ness) -- MIDRANGE-L

I'm at V7R4 with fairly current PTF's and both of these work (also on my blog site front page)

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 #"
----------------------------------------------------
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

Respectfully,
Michael Mayer
IBM i on Power System Admin
ERMCO-ECI
2225 Industrial Rd
Dyersburg, Tennessee 38024
Office and OnCall: 731.676.4318
Cell: 518.641.8906
Email: michael.mayer@xxxxxxxxxxxxx
https://www.ermco-eci.com/
IBM i Personal Blog: https://ibmireference.blogspot.com/
"Success is not final. Failure is not fatal. It is the courage to continue that counts".

----------------------------------------------------------------------

message: 1
date: Wed, 1 Nov 2023 09:35:59 -0400
from: Rob Berendt <robertowenberendt@xxxxxxxxx>
subject: Re: Check PTFs currency (up-to-date-ness)

Joe,
Which one are you using from that example? There are two. You pasted both. The first one is the one having issues. The second one is working.

------------------------------

message: 2
date: Wed, 1 Nov 2023 15:44:17 +0200
from: Gad Miron <gadmiron@xxxxxxxxx>
subject: Re: Check PTFs currency (up-to-date-ness)

Thanks Rob

You must carry some weight with IBM to get such a prompt reply. (-:

Gad

BTW
is it PTF currency or PTF currentness?

date: Wed, 1 Nov 2023 09:05:13 -0400
from: Rob Berendt <robertowenberendt@xxxxxxxxx>
subject: Re: Check PTFs currency (up-to-date-ness)

<IBM>
This is a known issue on the backend were the view goes to retrieve data.
We will let you know when IBM develop;ment lets us known the issue is
resolved.
</IBM>

------------------------------

message: 3
date: Wed, 1 Nov 2023 08:54:36 -0500
from: DEnglander--- via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
subject: Re: ACS Printing

Thank you Buck. Turns out the issue was that the PC needed to have a Restart. Once that was done, everything worked fine.

Doug

"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments accompanying it) contain confidential information belonging to the sender. The information is intended only for the use of the intended recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of the information is strictly prohibited. Any unauthorized interception of this transmission is illegal under the law. If you have received this transmission in error, please promptly notify the sender by reply e-mail, and then destroy all copies of the transmission."

------------------------------

message: 4
date: Wed, 1 Nov 2023 13:58:59 +0000
from: "Sizer, Joseph via MIDRANGE-L" <midrange-l@xxxxxxxxxxxxxxxxxx>
subject: RE: Check PTFs currency (up-to-date-ness)

I used each one independently and both worked for me.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Wednesday, November 1, 2023 9:36 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Check PTFs currency (up-to-date-ness)

________________________________
CAUTION: This email originated from outside of the PENCOR network. Do not click on any links or open attachments unless the sender is known, and the content is verified as safe.
________________________________

Joe,
Which one are you using from that example? There are two. You pasted both. The first one is the one having issues. The second one is working.

Joe,
Which one are you using from that example? There are two. You pasted
both. The first one is the one having issues. The second one is working.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:
https://list/
s.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=05%7C01%7Cmichae
l.mayer%40ermco-eci.com%7Cb85f1f32b31e42c01f2d08dbdae5adbe%7Cd2deeaf27
0e4425c91d7d99d784e89d6%7C0%7C0%7C638344452245130883%7CUnknown%7CTWFpb
GZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0
%3D%7C3000%7C%7C%7C&sdata=mYRH5FWXqu19Tp0InpZs1a3ILshHEwiBQCQjOwKOObg%
3D&reserved=0 or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

------------------------------

message: 6
date: Wed, 1 Nov 2023 14:00:33 +0000
from: "Sizer, Joseph via MIDRANGE-L" <midrange-l@xxxxxxxxxxxxxxxxxx>
subject: RE: Check PTFs currency (up-to-date-ness)

I am currently at ACS 1.1.8.7

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jim Oberholtzer
Sent: Wednesday, November 1, 2023 9:59 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Check PTFs currency (up-to-date-ness)

________________________________
CAUTION: This email originated from outside of the PENCOR network. Do not click on any links or open attachments unless the sender is known, and the content is verified as safe.
________________________________

I just ran the ACS Run SQL Scripts (1.1.9.0) V7R3 version with DB2 group
32 and it works fine.
Errors introduced in later updates?

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects

On Wed, Nov 1, 2023 at 8:36?AM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

Joe,
Which one are you using from that example? There are two. You pasted
both. The first one is the one having issues. The second one is working.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:
https://list/
s.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=05%7C01%7Cmichae
l.mayer%40ermco-eci.com%7Cb85f1f32b31e42c01f2d08dbdae5adbe%7Cd2deeaf27
0e4425c91d7d99d784e89d6%7C0%7C0%7C638344452245130883%7CUnknown%7CTWFpb
GZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0
%3D%7C3000%7C%7C%7C&sdata=mYRH5FWXqu19Tp0InpZs1a3ILshHEwiBQCQjOwKOObg%
3D&reserved=0 or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

------------------------------

message: 7
date: Wed, 1 Nov 2023 10:19:55 -0400
from: Rob Berendt <robertowenberendt@xxxxxxxxx>
subject: Re: Check PTFs currency (up-to-date-ness)

IBM is positive that the issue is on the back end site it's going out to.
I understand what you are saying - how can that be when it works for your versions.
However, maybe IBM added new columns or something in the examples and someone refreshed the back end site and dropped the new columns. IDK.
Maybe because I am using 7.5 and something is malformed in the XML at that site for a 7.5 entry. Again, IDK.

My example looks like:
(just the failing one, not the STRSQL example) 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;

On Wed, Nov 1, 2023 at 9:59?AM Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
wrote:

I just ran the ACS Run SQL Scripts (1.1.9.0) V7R3 version with DB2
group
32 and it works fine.
Errors introduced in later updates?

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects

On Wed, Nov 1, 2023 at 8:36?AM Rob Berendt
<robertowenberendt@xxxxxxxxx>
wrote:

Joe,
Which one are you using from that example? There are two. You
pasted both. The first one is the one having issues. The second
one is

working.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://li/
sts.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=05%7C01%7Cmi
chael.mayer%40ermco-eci.com%7Cb85f1f32b31e42c01f2d08dbdae5adbe%7Cd2d
eeaf270e4425c91d7d99d784e89d6%7C0%7C0%7C638344452245130883%7CUnknown
%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiL
CJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mYRH5FWXqu19Tp0InpZs1a3ILshHEwiB
QCQjOwKOObg%3D&reserved=0 or email:
MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:
https://list/
s.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=05%7C01%7Cmichae
l.mayer%40ermco-eci.com%7Cb85f1f32b31e42c01f2d08dbdae5adbe%7Cd2deeaf27
0e4425c91d7d99d784e89d6%7C0%7C0%7C638344452245130883%7CUnknown%7CTWFpb
GZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0
%3D%7C3000%7C%7C%7C&sdata=mYRH5FWXqu19Tp0InpZs1a3ILshHEwiBQCQjOwKOObg%
3D&reserved=0 or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

------------------------------

Subject: Digest Footer

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

------------------------------

End of MIDRANGE-L Digest, Vol 22, Issue 971
*******************************************