Re: Clean Up/400

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
+---