索引设计工具 db2advis使用

试下在数据库服务器上直接运行     db2advis -d sino -s "SELECT cckdnm , qj  , zzlx  , CASE WHEN wlnm IN (SELECT xt_wlxx_wlnm   FROM xt_wlxx    WHERE xt_wlxx_wllbnm = '3000001' AND xt_wlxx_wlnm NOT IN ('200001', '200002', '200003', '200004')) THEN '210000' ELSE wlnm END AS wlnm , CASE WHEN wlnm IN (SELECT xt_wlxx_wlnm FROM xt_wlxx WHERE xt_wlxx_wllbnm = '3000001' AND xt_wlxx_wlnm NOT IN ('200001', '200002', '200003', '200004')) THEN '...' ELSE wlmc END AS wlmc  , CASE WHEN wlnm IN (SELECT xt_wlxx_wlnm FROM xt_wlxx  WHERE xt_wlxx_wllbnm = '3000001' AND xt_wlxx_wlnm NOT IN ('200001', '200002', '200003', '200004')) THEN wlnm ELSE xpznm END AS xpznm  , CASE WHEN wlnm IN (SELECT xt_wlxx_wlnm  FROM xt_wlxx  WHERE xt_wlxx_wllbnm = '3000001' AND xt_wlxx_wlnm NOT IN ('200001', '200002', '200003', '200004')) THEN wlmc ELSE xpzmc END AS xpzmc  , nx  , sum (qmye) AS zycblkc , 0.0 AS jkzckc  , 0.0 AS splkc FROM db2inst1.ZF_TJ_SJKC JOIN (SELECT JHKDNM AS AJHKDNM  , MAX (ND || QJ) AS NDQJ  FROM ZF_TJ_SJKC  WHERE ND || QJ >= '201503' AND ND || QJ <= '201505'  GROUP BY JHKDNM) Y ON ND || QJ = NDQJ AND JHKDNM = AJHKDNM WHERE KCXZNM LIKE '0170102%' AND ND || QJ >= '201503' AND ND || QJ <= '201505' GROUP BY cckdnm, zzlx, wlnm, wlmc, xpznm, xpzmc, nx, nd, qj "