Category Archives: DB2

DB2 index design articles

    Here are a collections of article I found useful talking about DB2 index design.   http://www.quest-pipelines.com/newsletter-v5/0804_D.htm http://www-128.ibm.com/developerworks/db2/library/techarticle/0303kuznetsov/0303kuznetsov.html http://www-128.ibm.com/developerworks/db2/library/techarticle/0302kuznetsov/0302kuznetsov.html   To make the best of it, you need to think like the DB2 optimizer. grin:-).  

Posted in DB2 | 1 Comment

diff solved it

I was given a small task to compare the DB2 configuration (dbm,db cfg) on a AIX box to our DB2 tuning guide (as described in the doc). My initial thought is by knowing this will be a repetitive task, I will … Continue reading

Posted in DB2 | Leave a comment

solved a DB2 deadlock (due to EJB)

I spent almost the whole last month trying to figure out root causes of some DB2 deadlocks. Finally I nailed them. At first, it is hard to reproduce. So I used a tool called Silk Peformer to make it reproducable … Continue reading

Posted in DB2 | Leave a comment