v3r2: PF/LF/field usages -Reply

>>> Dan Swartz  07/29/97 09:56am >>>
>Is there any place in DB2/400 that would contain
>information about where (ie, what program) a PF or LF is
>used?  Also, is there any place in DB2/400 where there
>is maintained a list of where (ie, what program) fields are
>used?

>We'd like to track this information but we're not sure if
>the system did this automatically for us now with
>DB2/400.

>Any information would be GREATLY appreciated.

                              ------------------

A quick & dirty OS tool is DSPPGMREF to an outfile - this
will tell you what files are used in which pgms.  It'll even
tell you the record level ID expected by the pgm, so I use
this technique all the time when installing new releases
(particularly file changes) to root out the dreaded level
check msg!

As for field usage, I don't know of anything within
DB2/400 itself that says "PGM X uses FIELD Y from FILE Z",
but there are some vendor tools that provide field where
used analysis - we use (but are not affiliated in any way
with, except as a customer) Hawkeye.

HTH

Scott Cornell
Mercy Information Systems


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *