-20248 ATTEMPTED TO EXPLAIN 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.
- 07
- The current user is not authorized to invoke EXPLAIN for the stabilized dynamic query.
- 08
- The SYSIBM.SYSDYNQRY catalog table contains no qualified statements.
- 09
- The identified statement is not an explainable statement.
System action
The statement cannot be processed.
Programmer response
If the reason-code value indicates an authorization problem, complete the following steps:
- Correct the authorization problem and reissue the EXPLAIN statement.
- Re-prepare the statement that is to be explained.
SQLSTATE
26501