Tag Archives: performance

DB2 V10 Adaptive Compression

Last February, I wrote about DB2’s compression.  If that was McLaren, with DB2 V9.7’s compression, IBM upgraded to Lamborghini Aventador. Apparently IBM’s thirst didn’t stop there, they went one more step ahead and got the Bugatti Veyron with DB2 V10’s … Continue reading

Posted in db2, how to | Tagged , , , , , , , , , , , , , , , , , , | Leave a comment

Optimization profiles in DB2 UDB

How many times have we spend hours trying to figure why DB2 is not choosing a particular index and access path ? Probably many !    DB2 is one of the best cost based optimizer out there , but yet … Continue reading

Posted in database, db2, how to | Tagged , , , , , , , , , , , , , , , , , , , , | Leave a comment

DB2 Compression

Sales Pitch Deep compression as IBM likes to call it, is a nice little feature available in DB2 UDB since V9.1.  It has grown better and better as each versions goes by.  In DB2 v9.7, the index and the temporary … Continue reading

Posted in database, db2, how to | Tagged , , , , , , , , , , , , , | Leave a comment

I know stage 1 and stage 2 predicate…whats stage 3 and 4 ??

When tuning a SQL, one of the things a DBA looks at is to see whether the predicate in the SQL is stage 1 or stage 2. So what is stage 1 and stage 2. Basically when DB2 optimizer evaluates … Continue reading

Posted in db2 | Tagged , , , , , , , , , , , , | Leave a comment