Extracting Siebel ETL timings
For a long time, I relied on my siebel admins to get Siebel ETL timings and often struggled to get...
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...
DB2 on Ubuntu
Have you heard about Ubuntu ? Â Its one of the most popular open source linux distribution available. Lot of people...
DB2 Cook book
Have y’all used Graeme’s DB2 Cook book.  It has a wealth of SQL examples . I always find the sql...
Checking reorg status
Often we schedule our reorgs during off peak hours when nobody is watching . If you are paranoid like me,...
Simple Offline DB2 Reorg Script – Take 2
A few weeks back, I had published a script that will dynamically create a reorg script and execute it.  Now...