DB2ADVIS returning error -220

之前执行db2advis 的时候报了错：

• The db2advis tool needs the explain tables and the advise tables to exist. Please create them
  using the EXPLAIN.DDL script in the misc subdirectory of the sqllib directory.

解决方式：http://www-01.ibm.com/support/docview.wss?uid=swg21607022

1) Drop the explain and advise tables:

• db2 connect to <dbname>; 
  
  db2 drop table EXPLAIN_INSTANCE; 
  db2 drop table EXPLAIN_STATEMENT; 
  db2 drop table EXPLAIN_ARGUMENT; 
  db2 drop table EXPLAIN_OBJECT; 
  db2 drop table EXPLAIN_OPERATOR; 
  db2 drop table EXPLAIN_PREDICATE; 
  db2 drop table EXPLAIN_STREAM; 
  db2 drop table EXPLAIN_DIAGNOSTIC; 
  db2 drop table EXPLAIN_DIAGNOSTIC_DATA; 
  db2 drop table ADVISE_INSTANCE; 
  db2 drop table ADVISE_INDEX; 
  db2 drop table ADVISE_WORKLOAD; 
  db2 drop table ADVISE_MQT; 
  db2 drop table ADVISE_PARTITION; 
  db2 drop table ADVISE_TABLE; 
  db2 drop table EXPLAIN_ACTUALS;

Note: On DB2 v10.1 the table OBJECT_METRICS was also included as part of the set of tables created by the EXPLAIN.DDL script and should be dropped as below.

• 
  db2 drop table OBJECT_METRICS; 
  
  

2) Recreate them using the EXPLAIN.DDL script located in the directory $HOME/sqllib/misc:

• db2 -tvf EXPLAIN.DDL

3) Bind the db2advis packages below:

• db2advcatalog.bnd 
  db2advindex.bnd 
  db2advio.bnd 
  db2advis.bnd 
  db2advmdc.bnd 
  db2advmisc.bnd 
  db2advmqt.bnd 
  db2advsimulation.bnd 
  db2advworkload.bnd

These bind files are located under the Instance owner's home directory $HOME/sqllib/bnd. 
To bind the files you can run the following command: 

• db2 bind <filename.bnd> 
   

4) Rerun the db2advis

最后执行：db2advis -d dbname -i 1.sql -n schema -1 schema