DB2 SQL-Error: -20248
SQLState: 26501
Short Description: ATTEMPTED TO EXPLAIN ALL CACHED STATEMENTS OR A CACHED STATEMENT WITH STMTID OR STMTTOKEN ID BUT THE REQUIRED EXPLAIN INFORMATION IS NOT ACCESSIBLE
The EXPLAIN statement cannot be executed because the required explain information is not accessible due to one of the following reasons: 1. If the EXPLAIN statement specifies an ID or token (STMTCACHE STMID or STMTCACHE STMTOKEN): 2. The SQL statement with specified ID or token has never been cached because dynamic statement caching was not on when the statement was executed. 3. The statement with specified ID or token was cached before but is not in cache anymore (it was either invalidated or removed from cache by LRU algorithm). 4. The current user is not authorized to explain the statement with specified ID or token. 5. If the EXPLAIN statement specifies all cached statements (STMTCACHE ALL): 6. No statements are cached because dynamic statement caching has not been turned on. 7. The current user is not authorized to explain any of the statements that are in the dynamic statement cache.System action: The statement cannot be executed. Programmer response: Perform the following steps: 1. If the EXPLAIN statement specifies an ID or token (STMTCACHE STMID or STMTCACHE STMTOKEN): 2. Check if dynamic statement caching is on and if the statement ID or token is correct. The EXPLAIN statement cannot be executed if dynamic statement caching has never been turned on. 3. Re-execute (or re-prepare) the statement to be explained, find the updated statement ID or token, and explain it again. 4. Correct the authorization problem and re-execute the EXPLAIN statement. 5. If the EXPLAIN statement specifies all cached statements (STMTCACHE ALL): 6. Check that dynamic statement caching is on. 7. Re-execute (or re-prepare) the statements to be explained 8. Correct any authorization problems, and re-execute the EXPLAIN statement. 9.