Table 2-2 describes the new database connection 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. |