SQT Memory Consumption Control for RTL

Control the maximum memory consumed by unpacked commands in the DSI SQT cache during transaction profiling in RTL .

The SQT thread monitors the memory consumed by commands unpacked by the RTL transaction profiling processes and referenced by the DSI SQT cache.

When Replication Server is replicating using RTL, the maximum amount of memory consumed by the DSI thead is the sum of dsi_sqt_max_cache_size, sqt_max_prs_size , and dsi_cdb_max_size. Setting dsi_sqt_max_cache_size, sqt_max_prs_size , and dsi_cdb_max_size smaller would reduce memory consumption but reduce replication performance. Tune your replication environment for optimum memory consumption and performance. See the Replication Server Reference Manual > Replication Server Commands to configure the parameters.