Technical Blog Post
EXPLAIN PLAN returns SQL0220N with wrong schema on EXPLAIN_INSTANCE
2> CALL SYSPROC.SYSINSTALLOBJECTS('EXP
Then explain plan was run on desired SQL statement :
EXPLAIN PLAN FOR <SQL statement>
This returned following error, but note that it was for a different SCHEMA SYSTOOLS and not for B :
DB21034E The command was processed as and SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0220N The Explain table ”SYSTOOLS.EXPLAIN_INSTANCE”, column “25” does not have the proper definition or is missing. SQLSTATE=55002
The following call :
..creates the explain tables under the SYSTOOLS schema by default.
To create explain tables under a different schema (like B in this case), specify a schema name as the last parameter in the call.
More explanation can be found in below technote :