How do I turn off CA Datacom SQL Source Cache?

Products

• Datacom
• DATACOM - AD

Issue/Introduction

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

 

Environment

Release:
Component: SQL