Additional steps for enabling the DSNAEXP EXPLAIN stored procedure

The DSNAEXP stored procedure can be used to issue EXPLAIN on SQL statements without needing the authority to issue the SQL statements.

Before you begin

Before you complete these steps, either install the DB2®-supplied routines during migration or install the DB2-supplied routines during installation. Although DSNAEXP can run in an address space with other stored procedures, DSNAEXP performs better if it runs in its own address space. Therefore, you should set up a WLM application environment and startup procedure specifically for running DSNAEXP.

To enable the DSNAEXP EXPLAIN stored procedure: