Start of change

-20248    ATTEMPTED TO EXPLAIN ALL CACHED STATEMENTS OR A CACHED STATEMENT WITH STMTID OR STMTTOKEN ID-token BUT THE REQUIRED EXPLAIN INFORMATION IS NOT ACCESSIBLE. REASON reason-code

Explanation

The EXPLAIN statement cannot be executed because the required EXPLAIN information is not accessible for reason identified by the reason-code value.

ID-token
The identifier or token of the SQL statement.
reason-code
One of the following values:
01
The current user is not authorized to capture to invoke EXPLAIN for the qualified statement in the dynamic statement cache.
02
The dynamic statement cache contains no qualified statements.

System action

The statement cannot be processed.

Programmer response

If the reason-code value indicates an authorization problem, complete the following steps:

  1. Correct the authorization problem and reissue the EXPLAIN statement.
  2. Re-prepare the statement that is to be explained.

SQLSTATE

26501

End of change