Parameter
dbs/db4/da_cache_size
Short text
Database driver cache size
Parameter Description
dbs/db4/da_cache_size denotes the DB2 for IBM i SQL DA cache size (number of statements kept in the driver’s client cache).
If dbs/db4/driver_type == XDN, the SQL DA Cache size is set to 100, if dbs/db4/da_cache_size is set to ‘100’ or to ‘0’, and it is disabled if being set to ‘-1’.
If dbs/db4/driver_type == XDA, the SQL DA Cache size is also disabled, if dbs/db4/da_cache_size is set to ‘0’.
For more information, see also SAP note 1257635.
Application Area
Database
Default Value
100
Who is permitted to make changes?
DB administrator
Database System Restrictions
The parameter is only evaluated on DB2 for IBM i.
Are other parameters affected or dependent?
No.
Values allowed
Integer value
