Re: Clean Up/400

In a message dated 11/4/99 2:07:48 PM Central 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?
>  
>  Is there some IBM tool that will
>  1) sort names of all objects irrespective of library excluding Q-IBM
>  2) ignore any truely unique
>  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.
>  

Sure. just run a QRY over the system file QSYS.QADBFDEP and select records 
where DBFLIB <> DBFLDP

add any other filters you want and your done. Recommend you run the QRY 
regularly
+---
| 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
+---