Generate foreign keys
The other day I had to drop a parent table, which would also remove all its child relationships. I created...
Dropping Columns !
DB2 V9.x introduced one of the long awaited feature that other RDBMS could easily do…the DROP COLUMN . Since DB2...
Reverse engineer indexes in DB2 – Take 2
Last week, I posted my first version of the sql. I am expanding on that this week. The one last...
Don’t get caught in check pending
If your database is like mine and you might get have load request that does not come in the right...
Interesting bug in DB2 Z/os V8
A freind of mine encountered this bug in his shop and forwarded it to me to watch out for. I...
Terminate Lock chain applications
At my work, I used to get paged saying the reorg is on a lock wait, because some rouge application(s)...