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

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

In Run SQL Scripts, check out "PTF - Group PTF Currency" under Edit =>
Examples => Insert From Examples...

HTH


date: Wed, 1 Nov 2023 07:57:05 +0200
> 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