Re: Entity Relationship Diagramming Tools

[CRPence <crp@xxxxxxxxxxxxxxxxxxxx>]

  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