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-trxmetacommand 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-reportwill 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