版本9.7,做tsm备份
获取不到执行计划,我的步骤
1、创建执行计划表
db2 -tvf EXPLAIN.DDL
2、$ db2 set current explain mode explain
3、$ db2 -tvf test.sql
4、$ db2 set current explain mode no
5、$ db2exfmt -d ** -g TIC -w -l -s % -n % -o db2exmt.out
在db2exmt.out里的输出是
DB2 Universal Database Version 9.7, 5622-044 (c) Copyright IBM Corp. 1991, 2009
Licensed Material - Program Property of IBM
IBM DATABASE 2 Explain Table Format Tool
No Explain instances (plans) were found for database , source pattern: %.% for explain table schema "".
不知道是什么原因