×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.