Tag: IBM

Community

db2top Skew Screen

(Keith McDonald) In a DB2 for LUW database that makes use of the data partitioning feature available in the Infosphere Warehouse product, one of the new concerns a database administrator is faced with is skew among the partitions. Adding or removing partitions from a database introduces skew and req

Community

db2top Bottlenecks Screen (Part 2)

(Keith McDonald) The db2top Bottlenecks screen lets us see who the biggest consumers of each resource are and how much of the resource they are consuming. These top consumers can often cause such resources to become bottlenecked, so the Bottlenecks screen gives you an easy way to find the cause of s