RE: TAATOOL Pricing and PRTLIBANL

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

Cool.

I've been playing around with stuff like this. Coworker showed me a
little SQL he whipped up to make QCMDEXC a UDF. So, once I like the
results I see with:
select mbfile, mblib, mbndtr as DeletedCount, mbmxrl as MaxRcdLen,
mbndtr*mbmxrl as DeletedSpace, mbaccp
from qtemp/mbrinfo
where mbfila='*PHY' AND MBNDTR>0 AND MBFILE NLIKE 'QADB%'
order by mbndtr*mbmxrl desc

I can do something like
select QCMDEXC('SBMJOB JOB(' CONCAT MBFILE CONCAT ') CMD(RGZPFM FILE('
CONCAT MBLIB CONCAT '/' CONCAT MBFILE CONCAT ') MBR(' CONCAT MBNAME
CONCAT
')'),
mbfile, mblib, mbndtr as DeletedCount, mbmxrl as MaxRcdLen,
mbndtr*mbmxrl as DeletedSpace, mbaccp
from qtemp/mbrinfo
where mbfila='*PHY' AND MBNDTR>0 AND MBFILE NLIKE 'QADB%'
order by mbndtr*mbmxrl desc

If you want to use mbaccp to decide whether to add KEYFILE(*FILE) is up
to
you.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Pete Massiello" <pmassiello-ml@xxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
08/26/2008 03:01 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Subject
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
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Bruce Collins <Bruce.Collins@xxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
08/26/2008 12:23 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
TAATOOL Pricing and PRTLIBANL






Well I just got off the phone with TAATOOL and I am so confused.





We have a 570-7474 (P40) with 6 partitions. 4 are V5R4 and 2 are V5R3.



Direct from their web site I Quote "LPAR systems are considered a
single
system, (no extra charge per partition). No DSLO offering exists." And
this statement is somewhat correct.



http://www.taatool.com/newprices.html



Here is their new license table.




New Licenses

Tier

V6R1M0

V5R4M0

V5R3M0

V5R2M0

P05

$ 1900

$ 1600

$ 1350

$ 1200

P10

2650

2200

1750

1350

P20

4550

3800

3250

2750

P30

6700

5600

4950

4200

P40

9250

7700

6900

5850

P50

12100

10100

9100

7600

P60

15200

12700

11700

9500








If I go with the V5R4 and P40 it should cost me 7700.00 USD but it will
not work with the two partions running V5R3. The sales person said I
should by the V5R3 version for 6900.00 USD for the V5R3 version and
then
pay 2100.00 USD to upgrade the other partitions to V5R4 of TAATOOL
which
the price is now 9000.00 USD. I explain that this is a new license and
since I was going to purchase the V5R4 version why should I pay the
2100.00 USD for the down version when the new license difference is
only
800.00 USD between V5R4 and V5R3.



His answer was that the way it is.



Are their other tools that would give me similar information ast the
PRTLIBANL of TAATOOL.



Thanks



Bruce "Hoss" Collins

Project Leader/System i Administration

AAA Cooper Transportation

(334) 671-3106 Direct

(334) 796-0447 Mobile

bruce.collins@xxxxxxxxxxxxx



IBM i on Power Systems - For when you can't afford to be out of
business






--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.