Something About DB2
Friday, October 17, 2014
db2pd and Lock Wait
›
db2pd has got to be one of my all time favourite tool. It is like the swiss knife of troubleshooting :) But recently I found out that ther...
Tuesday, September 23, 2014
Mother of all fixpacks: DB2 10.5 LUW FP4
›
About a year ago, I wrote that DB2 BLU features are not compatible with 'DB2_COMPATIBILITY_VECTOR=ORA', ie, it does not allow the s...
Tuesday, July 29, 2014
When Lock Escalation meets CUR_COMMIT
›
If your database is configured to use currently committed ( ie, setting cur_commit = on), you will enjoy many of the benefits those Oracle ...
Thursday, November 14, 2013
Explain Tables, Data Studio, And Column Organize
›
There is a bit of nasty surprise when a database is created with default table organization as 'COLUMN'. If the EXPLAIN.DDL are exe...
Hierarchical Query Processing and Access Method
›
In its simplest form, DB2 performs hierarchical query using a recursive CTE. The way to spot it is look for the UNION operator in the exec...
Tuesday, November 12, 2013
db2caem And Optimization Guidelines Are Not Friends
›
Any attempt to run db2caem on a query with optimization guideline will be greeted with this message: DBT7028E "db2caem": The d...
Saturday, November 9, 2013
db2top 'explain plan' - useful but unreliable
›
db2top is a handy tool to monitor the current database activity. One of my favourite features is the ability to 'explain' the state...
›
Home
View web version
