A Datacom SQL query is not being stored in the SQL Source cache.
The Optimization Report does not give any clue why the query was marked ineligible for the cache.
SQL traces show the following messages:
S001E STMTPREP: Statment not eligible for source cache
S001E STMTEXE: NOT SAVING IN SOURCE CACHE
but they do not help in identifying the component that is causing it to be marked ineligible.
The query doesn't use any of the items that per SQL Source Cache page of the Datacom online documentation, here are the conditions that prevent caching of a query:
Queries not cached
Queries with the following syntax are not cached:
Release : 15.1
The query was executed via DBSQLPR with MSG=SS. The SQL Optimization Report requires the bind process which implies the source cache cannot be used because it avoids the bind process.
Use MSG=NN or MSG=ND