- 博客(7)
- 收藏
- 关注
原创 DB2 hot page contention caused by NLJ
Scenario:many concurrent SQLs are running slowly. The SQL statements are similar and the only difference is on predicate “type = ?”. Most of the run time are spent on TOTAL_EXTENDED_LATCH_WAIT_TIME. ...
2019-04-15 14:47:22 260
原创 DB2 performance issue due to the high disk write into temp table space
Write later
2019-04-01 14:03:30 458
原创 About DB2 access plan
Sometimes, if nested loop join is chosen, the large table that does not have index on the join column may be chosen as the outer table, whereas the small table that have index on the join column would...
2019-03-26 18:38:14 183
原创 Optimization profiles and guidelines
DB2 selectivity qualifier makes the optimizer underestimated the sort heap size so that the sort overflow occurred欢迎使用Markdown编辑器新的改变功能快捷键合理的创建标题,有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定...
2019-03-26 16:09:25 196
原创 DB2 各种ID 以及其它标识符
activity_idCounter which uniquely identifies an activity for an application within a given unit of work.uow_idThe unit of work identifier. The unit of work ID is unique within an application handle...
2019-03-26 12:03:59 1416
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人