DB2 10.5 for Linux, UNIX, and Windows

db2exmig - Migrate explain tables command

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.

Authorization

If the db2exmig application package is bound then the required authorization is one of the following authorities:

DBADM authority
EXECUTE authority on the db2exmig application package and SELECT privilege or CONTROL privilege on the following system catalogs:
- SYSCAT.COLUMNS
- SYSCAT.TABLES
- SYSCAT.REFERENCES
- SYSCAT.ROUTINES
- SYSCAT.ROUTINEAUTH
- SYSCAT.TABAUTH
- SYSCAT.COLAUTH

If the db2exmig application package is not bound then the required authorization is DBADM authority.

Required Connection

None

Command Syntax


>>-db2exmig-- -d--dbname-- -e--explain_schema------------------->

>--+-----------------------+-----------------------------------><
   '- -u--userID--password-'

Command parameters

-d dbname: Specifies the database name.
-e explain_schema: Specifies the schema name of the explain tables to be migrated.
-u userID password: Specifies the current user's ID and password.

Usage notes

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.