Managing EXPLAIN tables using Db2 Admin tool

You can use the Db2 Admin tool functionality to manage EXPLAIN tables and aliases.

Select option 2, Advanced Db2 SQL PA Processing, from the primary menu panel. The Advanced Processing Options panel is displayed.

SQLPA520 ------------ Advanced Processing Options ------------- 10:36
Option ===> 
                                                             Db2 system: DC1Q 
                                                           Db2 SQLID : TS6224 
Options using SQLPA functionality: 
 1 Modify statistics 
 2 Migrate statistics 
 3 Create or drop an index 

Options using Db2 Admin Tool functionality: 
 4 Modify statistics by Db2 Admin Tool 
 5 Migrate statistics by Db2 Admin Tool 
 6 Manage EXPLAIN tables & aliases 
 
F1=HELP F2=SPLIT F3=END F4=RETURN F5=RFIND F6=RCHANGE 
F7=UP F8=DOWN F9=SWAP F10=LEFT F11=RIGHT F12=RETRIEVE

Select option 6. The Manage EXPLAIN tables & aliases panel is displayed.
Use the MNT command to create, update, or drop EXPLAIN tables. This command uses the ADMIN_EXPLAIN_MAINT stored procedure.