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.