Database connection parameters

Table 2-2 describes the new database connection parameters.

Table 2-2: New configuration parameters

Parameter

Description

dynamic_sql

Turns dynamic SQL feature on or off for a connection.

On – dynamic SQL is enabled for a connection. Off (default) – dynamic SQL is disabled for a connection.

dynamic_sql_cache_size

Tells the Replication Server how many database obhects may use the dynamic SQL statement for a connection. Minimum: 1 Maximum: 65536 Deafault: 20

dynamic_sql_cache_management

Manages the dynamic SQL cache for a Data Server Interface executor thread. Values: mru (default) – keeps most recently used statements and deallocates the rest to allocate new dynamic statements when dynamic_sql_cache_size is reached. fixed – Replication Server stops allocating the new dynamic statements once dynamic_sql_cache_size is reached.