×
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.
On 13-Sep-2016 14:45 -0600, Rob Berendt wrote:
Put on some group PTF's on numerous lpars on one of my Power 8's.
So far I'm batting 1,000 on them getting the following
CHKPRDOPT PRDID(*OPSYS)
…
*SQLPKG QSQLPKG2 in QSYS not found for product 5770SS1 option *BASE
release V7R3M0. CPD3DC8
Exit program processing found error in product.
Exit program processing failed.
Product 5770SS1 release V7R3M0 option *BASE load 5050 not correctly
installed.
…
Errors found by CHKPRDOPT. CPF0C20
The object DOES exist. […]
FWiW: For just about any release somebody might still have running, with
the conspicuous *exception* of the IBM i 7.3 [i.e. v4r4 to v7r2, there
are backups available of the SQL Package objects QSQLPKG2 and QSQXDPKG
in a save file, stored on an IBM FTP server:
[
http://www.ibm.com/support/docview.wss?uid=nas8N1017381](TechNote
Reference #: N1017381 Historical Number 23250242SQL7973 SQL Create
Package Failed)
"…
ftp://public.dhe.ibm.com/services/us/igsc/cs2/ApiSamples/Rxxxsqlpkg.savf
Substitute xxx with the release <sic; ed: Version, Release,
Modification> level of OS …"
Perhaps somebody with IBM support, might nudge someone to do get the
save file for v7r3 placed there as well.
p.s. Any word on preventive for the improper Service OIR information
when the package(s) are created on the server rather than restored from
a backup or restored for an install? For example, a PTF like was made
for the past similar issue for the SQLPKG being re-created, but for n
issue of incorrect public authority and object owner, from IBM i 6.1:
APAR SE52297 "OSP-DB-MSGSQL0551 QSQLPKG2 PACKAGE PUBLIC *EXCLUDE
AUTHORITY and WRONG OWNER"
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.