RE: Temporal database feature on IBM i?

While I agree with your sentiment that will wind up slowing down Rochester's
development cycle since now all the features would have to be tested in
parallel across all the platforms.  Not all the platforms are as responsive
as Rochester is with IBM i.   

I'd rather see a request for the temporal feature itself, and since it's a
specific request, it has more chance of getting approved by the CAAC and
funded by IBM. 

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Matt
Olson
Sent: Monday, May 11, 2015 10:11 AM
To: Midrange Systems Technical Discussion
Subject: RE: Temporal database feature on IBM i?

Speaking of which. I am now entering a common feature request to make DB2
for I and DB2 for LUW to have feature parity and always be in sync with each
other in regards to new features.

-----Original Message-----
From: Matt Olson [mailto:Matt.Olson@xxxxxxxx]
Sent: Monday, May 11, 2015 10:02 AM
To: Midrange Systems Technical Discussion
Subject: RE: Temporal database feature on IBM i?

Very cool. Why does LUW always get all the neato features first! GRR.



-----Original Message-----
From: Vernon Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxx]
Sent: Sunday, May 10, 2015 1:33 PM
To: Midrange Systems Technical Discussion
Subject: Re: Temporal database feature on IBM i?

Matt

A Google of "db2 temporal" got lots of hits - this one looks like a good
start for LUW - others specifically said for Z, which is mainframe -

http://www.ibm.com/developerworks/data/library/techarticle/dm-1210temporalta
blesdb2/

There are links there to free community editions of DB2 for LUW, and several
other items.

You didn't say why you're interested, so I'll ass-u-me some things.

The IBM i DB2 team is not the LUW team - IBM do try to cross-pollinate some,
there are documents about the similarity. But no guarantees that syntax in
one flavor of DB2 will be the same in another flavor.

If Scott and Mark ever do have their teams work on this, you just can't
trust documentation for LUW or Z flavors to be exactly the same as you'll
end up using on i. That is the case with several things - folks have posted
questions in these lists about some feature they saw in DB2 documentation
and it just isn't supported on i or not in exactly the same syntax.

One thing I am pretty confident about - they will make things line up with
the latest ANSI spec for SQL. I don't know if temporal operations were even
part of that spec.

Besides, some things just aren't needed on i that ARE needed on the other
systems. There are settings and knobs in LUW DB2 for managing disk space
that we never have to deal with.

I know, since I was on the team testing it, that when the new query engine
was being done, that the developers looked at some algorithms from the Z
flavor - maybe from LUW, as well. But we can't make any assumptions about
what the DB team will do on the i side of things.

That's a lot of words to say, looking at other flavors may be a matter of
going down the yellow brick road - and do NOT pay attention to the man
behind the green curtain!!

Regards
Vern

On 5/9/2015 4:19 PM, Matt Olson wrote:
> Can you provide the reference for the LUW version of DB2 that has this
functionality?
>
>
>
> -----Original Message-----
> From: Alan Campin [mailto:alan0307d@xxxxxxxxx]
> Sent: Friday, May 08, 2015 1:17 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: Temporal database feature on IBM i?
>
> As far as I know the i Series is not getting this capability. It is being
made available for Windows and Unix but not for the iSeries. Bummer.
>
> On Fri, May 8, 2015 at 9:34 AM, Matt Olson <Matt.Olson@xxxxxxxx> wrote:
>
>> Midrange users,
>>
>> SQL 2016 will be introducing a temporal database feature which 
>> appears to be journaling on steroids.
>>
>> Apparently oracle already has this feature.
>>
>> Just wondering what is the feature equivalent on DB2 for the i?
>>
>> Here are screenshots of the feature:
>>
>>
>> http://i0.wp.com/blog.engineer-memo.com/wp-content/uploads/2015/05/im
>> a
>> ge59.png
>>
>>
>> http://i1.wp.com/blog.engineer-memo.com/wp-content/uploads/2015/05/im
>> a
>> ge61.png
>>
>> You basically add a clause to your SQL that says "FOR SYSTEM_TIME AS 
>> OF 'date/time value'" at the end of your SQL and voila, you get a 
>> picture of your table(s) as of a particular point in time. No reading 
>> cryptic squished together fields in journals, just natural queryable
data!
>>
>> Not only that you can "stretch" your database to the cloud, so all 
>> historical data is housed off site in presumably cheaper 
>> compute/storage infrastructure rather than your expensive on-premise 
>> database. Which makes sense for historical data since you are likely not
looking at it very often.
>> --
>> 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.
>
>

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


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