The onstat -g dss command prints detailed statistical information about the activity of individual data sync threads in an Enterprise Replication environment. The data sync thread applies the transaction on the target server. Statistics include the number of applied transactions and failures and when the last transaction from a source was applied.
The onstat -g dss command has the following formats:
onstat -g dss onstat -g dss modifier
The following table describes the values for modifier.
| Modifier | Action |
|---|---|
| UDR | Prints summary information about any UDR invocations by the data sync threads. |
| UDRx | Prints expanded information (including a summary of error information) about any UDR invocations by the data sync threads. The Procid column lists the UDR procedure ID. |
In the following example, only one data sync thread is currently processing the replicated data. It has applied a total of one replicated transaction and the transaction was applied at 2004/09/13 18:13:10. The Processed Time field shows the time when the last transaction was processed by this data sync thread.
IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 00:00:28 -- 28672 Kbytes
DS thread statistic
cmtTime Tx Tx Tx Last Tx
Name < local Committed Aborted Processed Processed Time
------------ ------- --------- ------- --------- -----------------
CDRD_1 0 1 0 1 (1095117190) 2004/09/13 18:13:10
Tables (0.0%):
Databases: test
CDR_DSLOCKWAIT = 1
CDR_DSCLOSEINTERVAL = 60