”. Overthinking and trying to predict Db2 performance is a slippery slope, and so rather than “thinking” about Db2 performance why not have the database tell you how it will perform. The key to this is the Db2 accounting trace, and subsequent Db2 accounting reports. The accounting reports are useful
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.