RE: TAATOOL Pricing and PRTLIBANL

Rob,

I use a very similar SQL for my list of files to Reorg, but I also
add the following

MBNDTR GT 0 and
MBFILE NLIKE 'QADB%'

This way I don't get any of the QADB* files and only members which
have deleted records.

Pete

Pete Massiello
iTech Solutions
www.itechsol.com

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, August 26, 2008 2:13 PM
To: Midrange Systems Technical Discussion
Subject: Re: TAATOOL Pricing and PRTLIBANL

When analyzing the system the first thing you should start with is the
RTVDSKINF and PRTDSKINF *SYS combo. If you read the online help on those
commands it will tell you the name of the files created so that you can
query the snot out of them. Those commands do not capture the record
information mentioned in PRTLIBANL. Which may be useful for

DSPFD FILE(ROB/*ALL) TYPE(*MBR) OUTPUT(*OUTFILE) OUTFILE(QTEMP/MBRINFO)
select mbfile, mblib, mbndtr as DeletedCount, mbmxrl as MaxRcdLen,
mbndtr*mbmxrl as DeletedSpace, mbaccp
from qtemp/mbrinfo
where mbfila='*PHY'
order by mbndtr*mbmxrl desc

to see which files to reorg.

Rob Berendt