× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. May 2015

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-1210temporaltablesdb2/
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/ima
ge59.png


http://i1.wp.com/blog.engineer-memo.com/wp-content/uploads/2015/05/ima
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.