Performance problems can be tough to solve, especially if you've not had to deal with them much before. In this session from IDUG NA 2016, Steve Rees goes through a step-by-step, decision tree-based approach for tackling performance problems.
Often times there can 4,5,6 different ways to write an SQL query and get the same results back. What makes one better than any of the others, and is there any ones that are always better, or always worse? Sometimes rewriting 1 predicate in an SQL statement can cause optimization to change. This pres
This week we are featuring a presentaiton given at the IDUG EMEA conference in Dublin. Jacek and Michal discuss the importance of paying attention to SQL code in a higly complex and active environment.
DB2 Analytics Accelerator V5.1 is available now.
Version 5.1 of DB2 Analytics Accelerator opens up a new dimension of analytical processing by introducing accelerator-only tables and in-database analytics.
“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.