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

Read syntax diagramSkip visual syntax diagramdb2exmig-ddbname-eexplain_schema-tntenantname-uuserIDpassword

Command parameters

-d dbname
Specifies the database name.
-e explain_schema
Specifies the schema name of the explain tables to be migrated.
-tn tenantname
The name of the tenant in the database that contains the tables to be migrated. If not specified, the default SYSTEM tenant is assumed.
-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.