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

Agreed...

The only Multisystem aspect I contemplate using would be the proposed local
current data + cloud history data.

But that's still pretty far fetched at this point.

Charles

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

What is a "reasonable cost" varies by your intent.
People like you and me who just want local partitions have a lower
threshold level than those who would take full advantage of the product.
And simply having the full set is probably not going to inspire us to say
"hey let's get our plant in Mexico their own Power 8, fire up IBM i and
start partitioning all of our DB2 data by warehouse location". But I can
see some people contemplating that.
We tend to look at remote systems as redundant systems. If our Indiana
machine(s) were down we'd expect full service from a machine in Mexico and
vice versa. DB2 Multisystem isn't within that philosophy.


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





From: Charles Wilt <charles.wilt@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 04/13/2016 10:45 AM
Subject: Re: Request for local partitioning unbundled from DB2
Multisystem Was: IBM i 7.3!!!!!
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



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

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.


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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.