Dynamic turning on and off of SQL Explain

Problem(Abstract)

To turn on or off the SQL Explain in the IDS engine while SQL is running, use the onmode -Y command.

The syntax:

onmode -Y <session id> 2
onmode -Y <session id> 1
onmode -Y <session id> 0

The option with 2 turns SET EXPLAIN on for sessionid and displays the query plan only
The option with 1 turns SET EXPLAIN on for sessionid
The option with 0 turns SET EXPLAIN off for sessionid

http://www-01.ibm.com/support/docview.wss?uid=swg21661115&myns=swgimgmt&mynp=OCSSGU8G&mync=E