Troubleshooting with DB2 snapshots
Multiple db2 snapshots can reveal performance issue, but its going to difficult to execute multiple snapshots while troubleshooting, so here...
Most important discovery in 47 million years !
They say its the most important discovery in 47 million years !!…no its not my long lost Dell Axim X51V...
Event monitor in DB2
Event monitors are used to collect information about the database and any connected applications when specified events occur. Â An Event...
first and last day of the month
Here is a quick way to find the first and last day of the month : with temp1 (first_day_of_month,last_day_of_month) as...
Did you backup the database ?? – Part 1
How often does we find out we haven’t backed up a database ? Â I had an occasion where I went...
SQL805N on NULLID.SYS* package – Part 2
Earlier I had written about getting SQL805 on NULLID.SYS* package and how you can resolve it by adding more SYS*...