"Statement failed because of a non-severe system error" when trying to run explain plan. Visual Explain worked fine in DB2 Control Center but not in Toad. This is an issue on all instances even with "Select * from syscat.packages".
Resetting Toad options did not make a difference.
May be related to an IBM issue. Toad explain plan code contains "QUERYTAG" adn it may be raising the error. Please refer to IBM problem discription and local fix.
http://www-01.ibm.com/support/docview.wss?uid=swg1IC75034
Local fix
Turn the statement concentrator off, i.e.,
db2 "update db cfg for <dbname> using STMT_CONC OFF"
replacing <dbname> with the database name.
