Re: Clean Up/400

We use ANZDBF this produces output files and writes to an output file at the 
same
time!
Thanks to Clare Holtham at SSA.


                  Analyze Database Files (ANZDBF)
.....................................................................
                  Analyze Database Files - Help

 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.


DAsmussen@aol.com wrote:

> Al,
>
> In a message dated 11/4/99 3:07:18 PM Eastern Standard Time,
> MacWheel99@aol.com writes:
>
> > I forgot some stuff through lack of practice & my brain needs a refill ...
> I
> >  stumbled over what looks like duplicate programs & files (possibly
> "on-line"
> >  backups or untested mods) from prior programming efforts ... thanks Bruce
> >  Barker for letting me know about PDM-54 ... big help with the SSA bug
> fixes.
> >
> >  Is there a DSPDBR variant that will list for me ONLY the logicals that
> exist
> >  in one library pointing at physicals in another, so I not need to wade
> thru
> >  page after page correct to catch the overlooked gotta fix?  How do we find
> >  tools like DSPDBR in the first place since it isn"t on any GO CMDLF type
> > menu?
>
> No, but you can DSPDBR against the base library to an outfile, and query
> against the outfile for dependent files in other libraries.  Just did this
> last week in order to write a program that automatically migrated logical
> files to a new release level.  You can GO CMDF and the like.  Your best bet
> is to just keep exploring -- hit F4 and search commands by both subject and
> verb.  Once you've got the syntax down, a GO CMDF cannot be far behind.  It
> never ceases to amaze me the number of people that have never found commands
> like WRKF, WRKHDWRSC, DSPDBR, DSPPGMREF, and things like them that I must use
> _daily_ because I work with packaged software on systems with which I'm not
> familiar.  Customers are constantly amazed that I CRTJRN, CRTJRNRCV, and
> STRJRNPF in order to DSPJRN to an outfile in order to discover what
> program(s) is updating a specific file.  STRSRVJOB and STRDBG will allow you
> to debug a batch program, even in (correctly compiled) ILE.  In the
> vernacular of my region, "this ain't rocket science, folks."  But it _IS_
> basic education that IBM, your business partner, and SSA won't give you.
>
> The simplest ways to stay current on AS/400 commands?  Read the "New Release
> Planning Guides" for new OS/400 releases, if available to you.  If not
> available, ask why.  When a new release is installed, turn down your
> assistance level for the first couple of weeks and make frequent use of F23,
> more options and F24, more keys on all commands you use -- if you don't
> understand a new option or key on a command, use help until you do.
>
> >  Is there some IBM tool that will
> >  1) sort names of all objects irrespective of library excluding Q-IBM
> No "Q" exclusions but: DSPOBJD to an outfile and RTV/PRTDSKINF are nice.
> Both should be run when nobody is using the system due to performance
> concerns.
>
> >  2) ignore any truely unique
> Not really, unless you want to get fancy with a program using DSPDBR.  This
> is what products like HawkEye use.
>
> >  3) when same name more than 1 library list DSPFD type statistics showing
> >  size, when created, used etc. to help me see what old copies we have that
> >  might no longer need.
> RTVDSKINF will do this.  DSPFD size information is not necessarily accurate.
>
> Feel free to ask me offline if you have a specific task that you're
> attempting to accomplish...
>
> Regards!
>
> Dean Asmussen
> Enterprise Systems Consulting, Inc.
> Fuquay-Varina, NC  USA
> E-mail:  DAsmussen@aol.com
>
> "Man is more concerned with the meaning of dreams than of things seen when
> awake." -- Diogenes
> +---
> | This is the BPCS Users Mailing List!
> | To submit a new message, send your mail to BPCS-L@midrange.com.
> | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: dasmussen@aol.com
> +---

--
Alison Quinton
Xyratex
D965 IT Central Services
01705 486363 x4439 26/20
Alison_Quinton@uk.xyratex.com
http://www.xyratex.com/


+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---