Question:
How do I turn off CA Datacom SQL Source Cache?
For example, CA Datacom Version 15.0 SQL apar TR90499 circumvention says:
"...
2. Turn the Source Cache off by setting either limit to zero:
SQL_SOURCE_CACHE_SIZE 0
SQL_SOURCE_CACHE_STMTS 0
..."
My Datacom Multi-User (MUF) does not specify either of these startup options.
Answer:
The size of the Source Cache is controlled by these two MUF parameters and their defaults:
SQL_SOURCE_CACHE_STMTS nnnnnn (0 – 100,000) <--- default 1,000
SQL_SOURCE_CACHE_SIZE nnnnnn (0- 100M) <--- default 10M
A value of zero (0) for SQL_SOURCE_CACHE_STMTS or SQL_SOURCE_CACHE_SIZE indicates the SQL Source Cache is not used.
These limits can be dynamically set to zero (0) without forcing a recycle of the Datacom MUF using console command or batch DBUTLTY.
Console commands to the MUF:
/f mufstc,COMM SQL_SOURCE_CACHE_STMTS 0
/f mufstc,COMM SQL_SOURCE_CACHE_SIZE 0
DBUTLTY console command to the MUF:
//SYSIN DD *
COMM OPTION=CONSOLE,OPTION2='SQL_SOURCE_CACHE_STMTS 0'
COMM OPTION=CONSOLE,OPTION2='SQL_SOURCE_CACHE_SIZE 0'
/*
Additional information:
See the CA Datacom Core - 15.0 documentation enhanced feature "SQL Source Cache".
https://docops.ca.com/ca-datacom/15-0/en/product-information/ca-datacom-new-features/enhanced-features#EnhancedFeatures-SQLSourceCache