实验一中关键步骤:
1. 查看监视开关是否打开:
db2 get monitor switches
2. 打开sql语句的监视开关:
db2 update monitor switches using statement on
3. 抓取动态SQL
db2 get snapshot for dynamic sql on sample>d:\m.txt
实验二中的关键步骤:
1. 创建MQT表
create table jhk.fic99a_sqt as (select substr(char(aab301),1,2)||'0000' as aab301, aac004,sum(aic031) as aic031 from jhk.fic99a_att group by substr(char(aab301),1,2)||'0000', aac004 )
data initially deferred refresh DEFERRED;
set integrity for jhk.fic99a_sqt immediate checked ;
--必须要手动刷新表才可以刷新数据
db2 refresh table jhk.fic99a_sqt;
ps:只有 REFRESH DEFERRED 物化查询表可以定义为MAINTAINED BY USER。不能对用户维护的 MQT 发出 REFRESH TABLE 语句(用于系统维护 的 MQT)。但是,用户维护的 MQT 却允许对它们执行 insert、update 或 delete 操作。
2. 写SQL查看执行计划
● Db2 set current explain mode explain
● SQL execute(select substr(char(aab301),1,2)||'0000' as aab301, aac004,sum(aic031) as aic031 from jhk.fic99a_att group by substr(char(aab301),1,2)||'0000', aac004)
● Db2 set current explain mode no
● Db2exfmt -d DBNAME -g TIC -w -1 -u db2001 db2001-n % -s % -# 0 -o c:\ZXT1.TXT
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11795524/viewspace-434665/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11795524/viewspace-434665/