说的好DB2 就是这样“chaotic”, 东榔西棒:)就tuning这块:”人家“Oracle从很多年前的BSTAT/ESTAT开始, STATSPACK, 到现在的AWR, etc, 一个方向一步一步“咱们”DB2从snapshot开始, snapshot view, db2pd, table functions,
[i=s] 本帖最后由 drdb2 于 2013-9-25 20:49 编辑 Understand.If it were better than Oracle, it would be the No.1 in market. By the way, IBM do have tons of manuals plus some redbooks and developerwork
total_exec_time is not always a reliable measure.Please read this page "Note: Due to the differences in granularity with which the DB2 system collects statistics, the value of the total_exec_tim
ROS (Read Only Standby) supported since 9.7 fixpack 1 and up, if I remember correctly
There is no way to estimate theoretically.You will need to make adjustment depending upon your system practical situation.
For index creation, DB2 use sortheap for sorting index keys.If an index is too large to be sorted in memory, sort spill/overflow will occur in temp tablespace.
my test system is 10.5.I did a test on employee table's workdept column, and the col-stats looks good to me. WORKDEPT 5 'A00' FWORKDEPT 11 'D11' FWORKDE
It's better to target the SQL first.I will still refer the general document by IBM
That are IBM recommended values (also default values since AIX 6.1), especially for database servers. They are good settings. Note:Prior to AIX 6.1, people do need to tune VMM settings, since IBM de
what is your db2 version?
关于TWT使用指南社区专家合作厂商入驻社区企业招聘投诉建议版权与免责声明联系我们 © 2024 talkwithtrend — talk with trend,talk with technologist京ICP备09031017号-30