Re: Temporal tables: Follow up questions

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Rob,



Temporal tables are a feature that I find very interesting. Do you
have/know any particular link (beyond the SQL reference manual) that could
help me start in the right direction?


Thanks in advance,

Luis


P.S.: The reference to the S/36 guy would be a lot funnier if, sadly, were
not so commonly true…

On Mon, May 15, 2017 at 10:18 AM Rob Berendt <rob@xxxxxxxxx> wrote:

> I recently gave a presentation to our local user group on Temporal Tables.
>  Basically I took an existing Infor table, added columns necessary for
> temporal tables, and did it all without recompiling any of their
> applications.
>
> Some of the follow up questions they asked were really good.  Such as:
>
> - What indexing strategies should be used on the history tables?
> - Can you specify that the history table be in a different ASP?
>
> Of course, the guy who still codes in S/36 RPG was wondering if an RPG
> CHAIN would work.
> And I did have to explain that you had to use temporal clauses like AS OF
> and that just doing it in your where clause would not work.
>
> I showed them how to query syspartitionstat to estimate I/O's that might
> be hitting history.
> And how to query syslimits to find the number of rows a single
> partition(member) can hold.
> A discussion of DB2 Multisystem ensued.
>
>
> 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.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD