Tag: IBM

Community

STMM Part 4 – STMM and DPF

(Chris Eaton) In the past 3 postings I wrote about how to set up STMM and how it works to share memory between databases and within databases. Now for a bit of a more advanced topic which is how does STMM work when you are using Database Partitioning Feature (DPF). DPF allows you to distribute data

Community

The DB2 business game

(Pat Moffatt and Jessica Cao) If you’re a beginner with IBM DB2 and SQL, you may wonder how the technical skills you’re learning are used in the “real world.” Here is a chance for you to put your DB2 SQL skills into play in this interactive game! Jump into a “run your own business” scenario, where y

Community

The Optimizer Takes Its Own Advice

(Rob Downer and Shantan Kethireddy) Having a good indexing strategy is imperative to achieving high query performance on any database platform. A comprehensive and efficient indexing strategy can mean the difference between queries that complete in seconds rather than minutes or hours. Implementing