STMT_CACHE_QUERY_PLAN configuration parameter

Use the STMT_CACHE_QUERY_PLAN configuration parameter to produce a query plan from any query that exists in the Statement Cache.

onconfig.std value
STMT_CACHE_QUERY_PLAN
values
0 = Disabled.

1 = Enabled

takes effect
After you edit your onconfig file and restart the database server.
When you reset the value dynamically in your onconfig file by running the onmode -wf command.
When you reset the value in memory by running the onmode -wm command.

Usage

You can use STMT_CACHE_QUERY_PLAN to enable SQL statement cache to hold query plan for each cached statement.