It has always been very important to understand when any changes in your database's configuration are made – some changes can have huge consequences. This article presents a methodology for monitoring your databases' configuration and detecting when changes have been made.
IDUG DB2 2016 SQL Challenge Week 2
A RANDOM PARTICIPANT IN THIS MONTH’S CHALLENGE WILL RECEIVE A $200USD COUPON TO USE TOWARDS TAKING IBM CERTIFICATION EXAMS! POST YOUR ANSWERS IN THE COMMENTS OF THIS ARTICLE FOR A CHANCE. A winner will be chosen at random from the participants at the end of the mon
“As time goes by…..” DB2 for z/OS continues to enhance support for temporal data. The functionality has been extended several times. The subject of this article is one of the temporal extensions, the temporal special registers, introduced in DB2 11 for z/OS.
I like to joke that time travel in SQL is fraught with peril. So, we need to be careful when time traveling but more importantly we need to have an understanding of how time travel applies to our business. This is critical in getting the query to match the data as well as match the business need.
In previous articles we have dealt with the basics of temporal storage and some performance considerations. Now we will move on to look at some additional topics, some of them of an advanced nature.