Re: DB2 Multisystem -- holy $%&#

Hey Rob,

Well technically, I guess you mean your receivers or receiver libraries are
huge.. ;)
But wouldn't that primarily be a function of how many you retain ?

And what advantage or implication is there for journaling that DB2
Multisystem brings to the table?

On Wed, Nov 4, 2015 at 9:17 AM, <rob@xxxxxxxxx> wrote:

Larry,

IBM is giving more and more examples of using partitioned tables. Even
for locally stored data. So, we may not yet "have" to do it; we "want" to
do it. We may not yet be in the area of the partition (aka member) is too
big and we "have" to have partitioning. However we do some serious
journal scraping. Our journals are jaw dropping huge compared to our data
libraries.

PRTDSKINF *LIB
% of Size in
Library Owner Disk 1000 bytes
#MXJRN MIMIXOWN 41.24 2260022186.0
ERPLXF SSA 8.00 438505435.1
...

So if I want to partition pricing history (for example) by month and year
that's my business.


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: DrFranken <midrange@xxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 11/03/2015 02:59 PM
Subject: Re: DB2 Multisystem -- holy $%&#
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



How big are these tables!?


- Larry "DrFranken" Bolhuis

www.Frankeni.com
www.iDevCloud.com - Personal Development IBM i timeshare service.
www.iInTheCloud.com - Commercial IBM i Cloud Hosting.

On 11/3/2015 2:41 PM, Charles Wilt wrote:

Working with our BP to configure a new POWER8 box...

Just a small S814 (8286-41A), P05 tier, using 1 core for IBM i

One addition I'd asked for was DB2 Multisystem (5770-ss1 option 27).
Simply because I'd like to be able to have locally partitioned tables;
particularly for historical data.

$25,000

Are you kidding me IBM? One LICPGM cost more than the rest of the OS?

That's just nuts.

Mainly just venting, as I don't expect this post do solve anything.

Charles

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