Resetting DB2 file permissions
Today something interesting happened at work. My windows system admin seems to have installed a patch on the OS without...
Investigating locks on db2
Saw this article while I was searching : http://www.ibm.com/developerworks/data/library/techarticle/dm-0707fechner/index.html
SQL805N on NULLID.SYS* package
All applications are not perfect. There might be instances where applications do not close their cursors after they are done...
Dynamically generate reorg script
Creating appropriate reorg script for UDB can be challenging. A little research made me right this sql that will generate...
Shell script to automate runstats in db2
had some free time today, so wrote a small script that will automatically create a runstats script for all the...