My application uses set schema and unqualified tables and I get confusing numbers from snapdyn_sql
The more modern table function:

select EXECUTABLE_ID, STMT_TEXT, num_executions 
from TABLE(MON_GET_PKG_CACHE_STMT('D', NULL, NULL, -2)) as T 
where stmt_text like 'select *%'"


returns individual metrics for the different schemas.

It still takes some further examination to find out what executable_id that belongs to each schema, so I much prefer qualified table names in queries over the set schema pattern.

If tables are not qualified by schema, the schema can be detected by:

select EXECUTABLE_ID, VALUE as SCHEMA, STMT_TEXT, num_executions
from TABLE(MON_GET_PKG_CACHE_STMT('D', NULL, NULL, -2)) as T 
CROSS JOIN TABLE(COMPILATION_ENV(T.COMP_ENV_DESC)) S 
where stmt_text like 'select *%' 
  and name = 'SCHEMA'


More details on COMPILATION_ENV can be found in the answer provided by Mark Barinstein