“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.
This fifth part of the DB2 11 for z/OS Developer certification test requires the knowledge of processing options you use when preparing and running your programs.
The DB2 landscape is changing quickly, and sometimes things can quietly sneak in before you even realize it. Maybe you have heard IBMers talking about JSON support in DB2, but have you heard about the mobile DB2 access and DB2 RESTful API that is now available for DB2 for z/OS?
This week we continue our theme of improving application performance by reducing the number of calls to DB2. In addition to using DB2 techniques, we look at programs that retrieve more data than they really need, retrieve data sooner than it is needed, and retrieve the same data multiple times.