Re: DB2 Multisystem -- holy $%&# -- MIDRANGE-L

Well I know what journal scraping is, I just was't aware of how you might
be using it.

I also know how partitioning works, so that's not a mystery to me either.

I am still struggling to see how DB2 Multisystem partitioning would help
you with your journaling receiver issue unless you are scraping data from
journals and transforming it into some kind of home-brew table partition.

But I figure there are probably some details being lost in translation.

On Wed, Nov 4, 2015 at 10:41 AM, <rob@xxxxxxxxx> wrote:

We keep like 77 days of journal entries. More or less, depending on the
application group, etc.

Perhaps you've never heard the term "journal scraping" before. Basically
this means you scrape data from the journal into database files. Sort of
like transaction history files.

When you do partitioning you can do things like
CREATE TABLE FOO
(A DATE)
PARTITION BY RANGE(A)
(STARTING('2001-01-01') ENDING('2010-01-01') EVERY(3 MONTHS))
This is straight from Knowledgecenter.

Each partition is in a separate 'member'.

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

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.

--

Regards
Evan Harris
--
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.