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
About this task
Procedure
To enable the DSNAEXP EXPLAIN stored procedure:
Define a PLAN_TABLE for each user. See member
DSNTESC in prefix.SDSNSAMP for sample SQL statements.