#394 explain fails

[Anonymous]

Hi,

I ran OLAP zizag join tutorial, and trying to explain the statement, I get this:
[IBM][CLI Driver][DB2/LINUXX8664] SQL0440N No authorized routine named "EXPLAINEXPANDNODE" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884 SQLCODE=-440 statement: select "s#db2mc".explainExpandNode(cast('DB2INST1' as VARCHAR(128)),EXPLAIN_REQUESTER,EXPLAIN_TIME,SOURCE_NAME,SOURCE_SCHEMA,SOURCE_VERSION,cast('P' as CHAR(1) ),STMTNO,SECTNO,cast('O' as CHAR(1) ),cast(1 as INTEGER),cast(null as VARCHAR(128)),cast(null as VARCHAR(128))) from "DB2INST1".explain_statement as o where o.EXPLAIN_LEVEL='O' and o.queryno = 1 and o.querytag= 'db2mc#DefaultStage_3' and EXPLAIN_TIME=(select max(EXPLAIN_TIME) from "DB2INST1".explain_statement as m where m.EXPLAIN_REQUESTER=o.EXPLAIN_REQUESTER and m.SOURCE_NAME=o.SOURCE_NAME and m.SOURCE_SCHEMA=o.SOURCE_SCHEMA and m.SOURCE_VERSION=o.SOURCE_VERSION and m.EXPLAIN_LEVEL='O' and m.STMTNO=o.STMTNO and m.SECTNO=o.SECTNO)

If I do a SET CURRENT EXPLAIN MODE .... and db2exfmt, I get the explain correclty. I have modified the sql to add schema, don't get it.

Regards, JMB

[Nobody/Anonymous]

It has failed as it requires a function that hasn't been installed.

If you go to tools->installd components and install "DB2TE added functions" it should work. I will fix the message