db2exmig — Don’t forget to migrate your explain tables, New Way in DB2 10.5 FP4 Cancun Release

After upgrading your release of DB2, don’t forget to migrate your explain tables or your explains or use of Design Advisor may fail. Although still supported in DB2 10.5 FP4, there is a new stored proc to use……

9.7

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0023722.html?cp=SSEPGG_9.7.0%2F3-6-2-6-46

10.5

CALL SYSPROC.SYSINSTALLOBJECTS (‘EXPLAIN’, ‘M’, CAST

(NULL AS VARCHAR(128)), CAST (NULL AS VARCHAR(128)))

For more info refer to the Knowledge Center at

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0011876.html?cp=SSEPGG_10.5.0%2F3-6-1-3-19-14