Re: ZendServer install fails, upgrade 5733SC1 from V7R1 to V7R21

On 11-Jan-2016 12:17 -0700, rob wrote:

DSPSFWRSC
F11=Display libraries/releases
Resource Feature
ID Option Feature Type Library Release
5733SC1 *BASE 5050 *CODE QUTL V7R2M0
5733SC1 *BASE 2924 *LNG QUTL V7R2M0
5733SC1 1 5050 *CODE QUTL V7R2M0

DSPOBJD OBJ(QUTL/*ALL) OBJTYPE(*ALL) DETAIL(*SERVICE)
OUTPUT(*OUTFILE) OUTFILE(QTEMP/QUTL)

strsql
SELECT ODLBNM, ODOBNM, ODOBTP, ODOBAT, ODPCNR
FROM qtemp.qutl
ORDER BY odpcnr desc

Library Object Object Object PTF
Type Attribute Number
QUTL QSC101LNK *PGM CPPLE 58330
QUTL QSC101SRVR *PGM CPPLE 58330
QUTL QSC101MRM *PGM CLP 54468
QUTL QSC1MSG *MSGF
QUTL QSC10050 *PRDDFN
QUTL QSC10029 *PRDLOD
QUTL QSC10050 *PRDLOD
QUTL QSC10150 *PRDLOD

More appropriate might be the choice of ODPTFN [PTF Id] over ODPCNR [PTF Number]; the latter does not include the prefix; the below Display PTF request would then require an assumption [though quite knowable] of the 'SI' as the prefix.

DSPPTF LICPGM(5733SC1) SELECT(SI58330)

See how you can tie in a particular PTF to a particular object(s)?

But only for /QSYS.LIB objects. If there is no permanent /QSYS.LIB object provided with the PTF, then the above scripted actions\output may not be helpful [except possibly immediately, vs long-term, given a /temporary PTF object/ was included as part of /QSYS.LIB].

SQL gurus: PTF # is not yet in OBJECT_STATISTICS.

Anyone: One could create their own UDTF to provide whatever OIR or other object-specific details they prefer. Clearly that particular /SQL services/ OBJECT_STATISTICS table function feature [under the Librarian Services topic] does not intend to give _everything_ that the Display Object Description (DSPOBJD) [or that the similar Librarian APIs additionally] might give.