DB2 OLAP Functions
Just thought I will share this link from Chris Eaton I found this to be very useful on DB2’s OLAP...
Over and Partition by on SQL for aggregation
The other day  I had a requirement to create a report with total occurrence of an event by year month...
Finding Lock waits in DB2
DB2 is  a little tough on its locking mechanism.  IBM says  DB2 V9.7 has improved a lot on this area,...
DB2 LUW V9.7 Express C on Ubuntu 9.04
A few months back, I had posted how to install DB V9.5 Express-C on Ubuntu 9.04. Â Today I installed...
How much transaction log is left ?
What if a rouge transaction gets on your system and start using my all your transaction logs, don’t you want...