tune - connect_cdc_sqdata

The tune command is intended advanced performance tuning and diagnostic performance testing only. It should only be used under the direct guidance of Precisely Support or Professional Services.

Syntax

sqdmon tune [--enable-trxmeta|--disable-trxmeta] engine_url [agent_url ...]
sqdmon tune [--enable-latency-report|--disable-latency-report] engine_url [agent_url ...]

Parameters and Descriptions

Parameter	Description
[--enable-trxmeta \|--disable-trxmeta]	Turn ON/OFF writing transaction metadata fields to a text file provided in OPTIONS Statement for Apply and Replicator Engine.
[--enable-latency-report \|--disable-latency-report]	Turn ON/OFF latency report generation for Apply and Replicator Engine.

Note:

--enable-trxmeta command line option will be effective only when TRXMETA file is provided in OPTIONS Statement for Replicator and Apply Engine. For more information, see Keywords used for command line execution in Replicator Engine or Keywords used for command line execution in Apply Engine.
Latency report enabled using --enable-latency-report will be visible to SQDMON display command output for Replicator or Apply Engine.
Latency report will be written to Engine Runtime Report file (<engine>.rpt) also when Replicator or Apply Engine stops.

Sample TRXMETA file data for Db2z Source for Apply Engine

{"trx_id":"000000000058647E148B000000000000","trx_begin":"E01949A8B56
             5914C","trx_commit":"E01949A8B59D9822","trx_capture":"E01949A90967D710",
             "trx_pub_read":"E01949A90967D710","trx_pub_push":"E01949A90971856C",
             "trx_beginur_recv":"E01949D5C21EE260","trx_ack_recv":"E01949D5C22DB260",
             "trx_msg_write":"E01949D5C22C9260","trx_ack_write":"E01949D6B6A1C264",
             "trx_bytes":"202","trx_records":"1"}

Sample Latency Report Data for Apply Engine

Low Transaction Latency.................: 239 ms 
              TrxId.................................: 000000000058647E148B000000000000 
              TrxBytes..............................: 202 
              TrxRcds...............................: 1 
              TrxCommit.............................: 2024-12-05 17:07:13.560537 +05:30 (e01949a8b59d9822) 
              High Transaction Latency................: 365 ms 
              TrxId.................................: 000000000058647CBBAA000000000000 
              TrxBytes..............................: 202 
              TrxRcds...............................: 1 
              TrxCommit.............................: 2024-12-05 17:05:15.240467 +05:30 (e0194937dee13b1a) 
              Avg Transaction Latency.................: 328 ms

tune - connect_cdc_sqdata - Latest

Connect CDC (SQData) Utilities