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

from: Gad Miron <gadmiron@xxxxxxxxx>
subject: Check PTFs currency (up-to-date-ness)

Hello guys

For some years I use the following SQLs to check if my Group PTFs are
current

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


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



but recently I get a confusing (to me) error:

Query cannot be run. See lower level messages
Message ID . . . . . . : CPF503E Severity . . . . . . . : 30
Message type . . . . . : Diagnostic Date sent . . . . . . : 01/11/23
Time sent . . . . . . : 07:51:19 Message . . . . : User-defined
function error on member GRPPTFCUR. Cause . . . . . : An error occurred
while invoking user-defined function HTTPGETBLOB in library SYSTOOLS. The
error occurred while invoking the associated external program or service
program B2RESTUDF: in library SYSTOOLS.D, program entry point or external
name com.ibm.db2.rest.DB2UDFWrapper.httpGetBlob, specific name
HTTPG00001. The error occurred on member GRPPTFCUR file GRPPTFCUR in
library SYSTOOLS. The error code is 1. The error codes and their meanings
follow: 1 -- The external program or service program returned SQLSTATE
38000. The text message returned from the program is:
SYSTOOLS.HTTPGETBLOB HTTPG00001 kjava.io.IOException:Server returned HTTP
response code: 403 for URL:


Any help will be gratefully received

Gad