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...
An sql to find out how full your db2 tablespace is on UDB
You need to have the IBM stored procedure SNAP_GET_TBSP_PART select tbsp_name, ((tbsp_used_pages * 100)/tbsp_usable_pages) as percent_full from table(SNAP_GET_TBSP_PART (‘ ‘,-1))...
Installing Bootcamp on a mac
A freind of mine the other day asked me how I installed boot camp on my mac. Although you can...
blocking a website on a mac
I found an easy way to block a website : 1. open spotlight and search for Terminal 2. Open terminal...
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...