Re: Request for local partitioning unbundled from DB2 Multisystem Was: IBM i 7.3!!!!!

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Rob,

As I see it there are a few reasons to partition local tables

1) Data management, as you indicate.  But note there are two sides, ATTACH
& DETACH/DROP
2) Query performance, full table/index scans may only need to scan a
partition
3) Benefits for SAVCHGOBJ, only 1 partition may need saved.

Since they've already shot down the idea of unbundling...perhaps we should
simply ask that it be made more accessible.

I for one can't justify $25,000 for a LICPGM for a new POWER8 box when the
hardware and the rest of the software only cost me $35,000.

I was hoping that the availability of partitioning in MS SQL Server and
Oracle would prove to be a nice stick to use.  However, from what I've been
able to find, table partitioning requires the Enterprise Edition of both MS
SQL Server and Oracle.

I suppose that one could argue that DB2 for i is only available as an
Enterprise Edition :)

I'd certainly be willing to pay a reasonable cost for DB2 multisystem...

Charles


On Wed, Apr 13, 2016 at 9:47 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

> Just checked my requirements submitted to COMMON:
> Summary:  Unbundle partitioning of local databases from DB2 Multisystem
> and put into OS.
> Status:  Rejected
>
> Per Scott Forstie @ IBM
> If unbundling equates to allowing local partitioning to be used without
> having to purchase DB2 Multisystem, we are not going to unbundle it. DB2
> Multisystem has unique value and with IBM i 7.3, the value is increased.
>
> My update:
> Now that 7.3 is announced we can talk about how that value is increased.
> However, we ain't shoveling out the money for DB2 Multisystem just for
> local partitioning.
> It just isn't worth someone's salary for a long duration just to be able
> to change
> delete from rco_hist where where year(system_end)=2014
> down to
> alter table rco_hist drop partition 2014
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com