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

I am getting a bad message using the stock example from IBM in Run SQL
Scripts. IDK if it is a URL change, security change, etc.

SQL4302 Java stored procedure or user-defined function
SYSTOOLS.HTTPGETBLOB, specific name HTTPG00001 aborted with an exception
"java.io.IOException:Server returned HTTP response code: 403 for URL:
https://www.ibm.com/support/pages/sites/default/files/inline-files/xmldoc.xml";.
2023-11-01 07:40:33.598582 30 DIAGNOSTIC
Cause . . . . . : The Java stored procedure or user-defined function
aborted with a Java exception. If SQJAVA component trace is on, then the
component trace for the job contains a Java stack traceback for the aborted
method.
Recovery . . . : Debug the Java method to eliminate the exception. ROB
QSYS QSQROUTS QSQCLNUP SQROUTE_CLEANUP 8417 QSYS QSQROUTS QSQCLNUP
SQROUTE_CLEANUP 8417

I will open a case.

On Wed, Nov 1, 2023 at 1:57 AM Gad Miron <gadmiron@xxxxxxxxx> wrote:

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
--
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.