Tag Archives: tuning

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

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

DB2 UDB V8.x memory module

I know its kinda late since most of us would have migrated to DB2 V9.5 where the memory model is different. But still, I think its worth putting it here :  DB2 UDB Memory Model

Posted in Misc | Tagged , , | Leave a comment