Migrates explain tables. The explain tables migration tool renames the existing explain tables, creates a new set of tables using the EXPLAIN.DDL, and copies the contents of the existing explain tables to the new tables. Finally, it drops the existing explain tables.
The explain tables belonging to the user ID that is issuing the db2exmig command, or that is used to connect to the database, are migrated.
The db2exmig command will preserve any user added columns on the explain tables.
If the db2exmig application package is not bound then the required authorization is DBADM authority.
None
>>-db2exmig-- -d--dbname-- -e--explain_schema-------------------> >--+-----------------------+----------------------------------->< '- -u--userID--password-'
You can determine the db2exmig application package name by using the command: db2bfd -b db2exmig.bnd. The db2exmig.bnd files are located in the sqllib/bnd folder.