Re: Command to show file relations

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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.

Anyway, here's a description from the help for ANZDBF:

The Analyze Database File (ANZDBF) command produces two reports that show 
the physical and logical files in a set of libraries and the relationships 
between the files.  It saves the information in a database file for further 
analysis by the Analyze Database File Keys (ANZDBFKEY) command.  Both 
reports (physical to logical file relationships and logical to physical 
file relationships) are written to the printer file QPPTANZD.  Two printer 
files with the same name are produced.  The data is saved in member 
QAPTAZDR of the database file QPFRDATA/QAPTAZDR.

And for ANZDBFKEY:

The Analyze Database File Keys (ANZDBFKEY) command produces, from the data 
generated by the Analyze Database File (ANZDBF) command, two reports 
showing the key structure of the database files.

One report is written to the printer file QPPTANKM.  The other report is 
written to the printer file QPPTANZK.


At 08:28 AM 9/30/2003 -0500, you wrote:

> Vern,
>
> I'd never heard of these commands before, so I tried to run them and i'm
> told i'm not authorized.
>
> what do these commands do that would not allow authority to group qpgmr?
>
> thanks,
>
> rick
>
>
> -----------original message---------------
> You might also consider ANZDBF and ANZDBFKY - check out their help text.
> They use somethign like DSPDBR and DSBFD to generate some useful reports.
>
> HTH
>
> Vern
>
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.