If you know which catalog VIEW has the information for SQL objects,
then review DSPFD ThatVIEW; a VIEW in either SYSIBM or QSYS2. That will
expose the relationship and the join & selection required to present
those details [the VIEW may contain selection which limits the results
to only SQL objects]. For example using the CREATE VIEW shown by the
request to DSPFD SYSKEYS, removing the DBIATR='IX' enables seeing DDS
created keyed files [even if some results might be confusing; e.g. MFLF
multi-format logical files]. SYSVIEWDEP is one VIEW which expresses PF
to LF relationships; again, where the existing selection eliminates DDS
created files.
The following link describes the catalog VIEW fields:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/db2/rbafzmstcatalogtbls.htm
Note: creating the VIEW or running the SELECT used to create the VIEW
will require *SECOFR privilege [specifically, only the *ALLOBJ special
authority], but like the catalog VIEWs, after they are created, the
authority to the VIEW controls the user access.
Note: Caveat Emptor for created VIEWs: cpf32D1
Regards, Chuck
This mailing list archive is Copyright 1997-2026 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.
midrange.com
