今天对一个很大的sql文件执行db2advis:
db2advis -d asbdm -i JMS6531.ddl -m IM > advis_result.txt 报错:
No catalog node table space name has been specified on the command line. Using default
Using user id as default schema name. Use -n option to specify schema
打开输出文件advis_result.tx :
execution started at timestamp 2015-12-17-20.50.18.724761
found [1] SQL statements from the input file
Could not drop the local catalog tables
Could not create the local catalog tables
0 solutions were evaluated by the advisor
exiting with error code [-159]
请问这是什么原因?该怎么处理呢? 谢谢!
db2advis -d sample -n db2inst3 -i test.sql
SQL语句末尾记得加\";\"
-n schema-name
Specifies the qualifying name of simulation catalog tables, and the qualifier for the new indexes and MQTs. The default schema name is the caller\'s user ID, except for catalog simulation tables where the default schema name is SYSTOOLS. The default is for new indexes to inherit the schema name of the index\'s base.
收起