Re: Command to show file relations

093003 11:42:21        Data Base Relation Cross Reference
P=Phy                          Depnd  Dependent   Dependent   Depncy
L=Lgl  File        Library     Count  File        Library     Type
-----  ----------  ----------  -----  ----------  ----------  ------
  P    DFTTEST                     1  DFTTESTV    VERN          D
       QAQQDBMN                   20  QQQ1000     VERN          D
                                  20  QQQ3000     VERN          D

 9/30/03 11:42:22             Logical File Listing
                                                        Type
Dependent   Dependent   Depncy                          P=Phy
File        Library     Type    File        Library     L=Lgl
----------  ----------  ------  ----------  ----------  -----
DFTTESTV    VERN          D     DFTTEST     VERN          P
QQQ1000     VERN          D     QAQQDBMN    VERN          P
QQQ3000     VERN          D

  9/30/03 11:47:09      Key Fields and Select/Omit Listing
    File       Library         Order  Path Type Unique Maintenance
LGL QQQ1000    VERN            FIFO   KEYED       N    *IMMED
        Based on          Format      Key Field  Seq   Sign  Zone  Alt
    QAQQDBMN   VERN       QQQ1000      QQJFLD
    **Record Selection**  Format      Field     S/O Comp Values
                          QQQ1000     QQRID      S   EQ   +1000
                                                 O   AL

Thanks Vern.  I'm looking to produce my own set of quickie analysis reports
and utilities, and these might be helpful.

rick

---original message---
Rick

They are part of Performance Tools - the output files they use are in
QPFRDATA. Both have *PUBLIC *EXCLUDE. QSYS is owner and has all authority.
Not sure why the restriction, except they might need to touch anything on
the system. But there is no real exposure that I can see. They are only
DSPDBR on steroids, IMO. And the second one is only a listing of keys (and
S/O information) for files in given libraries - same information is
available via DSPFD.