If you must maintain explain table information that you gathered in your DB2® copies from previous releases, upgrade your explain tables to DB2 Version 10.5.
Ensure that you have DBADM authority. For additional authorization details, see Command Reference.
db2exmig -d dbname -e explain_schema -u userid password
where:The explain tables are upgraded. The db2exmig command renames the original explain tables, creates a new set of tables by using the EXPLAIN.DDL file, and copies the contents of the original explain tables to the new tables. Finally, the tool drops the original explain tables. The db2exmig command preserves any user-added columns in the explain tables.