Playing with cardinality and selectivity on predicates is not a common trick, though Joe Geller, David Simpson and Tony Andrews demystify it so that you can start playing with its intricacies and give a boost to the Optimizer.
Automated application testing for web services with a Db2 repository is not an easy task, and it invites for creative solution. On this post, David Morris shows how this can be accomplished with the aid of tools like Jenkins and H2 as a means of providing a test scenario that mirrors a Db2 database.
Anomaly Detection is a hot topic these days, but you don't need to do coding to start with this. In this article, we'll do Anomaly Detection using only SQL statements new to Db2.
We're always working hard to keep up with new features and trends, but we've got you covered. For the months of November and December, we'll provide you with essential content on new features you can't afford to ignore.
