STATS REPLICAT

Use STATS REPLICAT to display statistics for one or more Replicat groups. Thread statistics for a coordinated Replicat group are provided as follows.

Thread Lag Gap: The difference between the maximum lag and the minimum lag among all threads.
Coordinated Total DDLs: The total number of coordinated DDL transactions.
Coordinated Total PK-Update Transactions: The total number of coordinated transactions that involved an update to a primary key.
Coordinated Total EMI Transactions: The total number of coordinated EVENTACTIONS events.
Total Transactions with User-Requested Coordination: The total number of coordination’s that were explicitly requested in the configuration by means of the COORDINATED option of the MAP parameter.
Average Coordination Time: The average time (in seconds) spent in coordination among all threads.

Syntax

STATS REPLICAT group_name
[, statistic]
[, TABLE [container. | catalog.]schema.table]
[, TOTALSONLY [container. | catalog.]schema.table]
[, REPORTCDR]
[, REPORTCHARCONV]
[, REPORTDETAIL | NOREPORTDETAIL]
[, REPORTRATE {HR | MIN | SEC}]

group_name

The name of a Replicat group or a wildcard (*) to specify multiple groups. For example, T* shows statistics for all Replicat groups whose names begin with T.

statistic

The statistic to be displayed. More than one statistic can be specified by separating each with a comma, for exampleSTATS REPLICAT finance, TOTAL, DAILY.

TOTAL: Displays totals since process startup.
DAILY: Displays totals since the start of the current day.
HOURLY: Displays totals since the start of the current hour.
LATEST: Displays totals since the last RESET command.
RESET: Resets the counters in the LATEST statistical field.

TABLE [container. |catalog.]schema.table_name]

Displays statistics only for the specified table or a group of tables specified with a wildcard (*). The table name or wildcard specification must be fully qualified with the two-part or three-part name, for example hr.emp or *.*.*.

TOTALSONLY [container. |catalog.]schema.table_name]

Summarizes the statistics for the specified table or a group of tables specified with a wildcard (*). The table name or wildcard specification must be fully qualified with the two-part or three-part name, for example hr.emp or *.*.*.

REPORTCDR

Shows statistics for Conflict Detection and Resolution. Statistics include:

Total CDR conflicts
CDR resolutions succeeded
CDR resolutions failed
CDR INSERTROWEXISTS conflicts
CDR UPDATEROWEXISTS conflicts
CDR UPDATEROWMISSING conflicts
CDR DELETEROWEXISTS conflicts
CDR DELETEROWMISSING conflicts

REPORTCHARCONV

Reports statistics for character validation when character-set conversion is performed. The following statistics are added to the STATS output:

Total column character set conversion failure: the number of validation or conversion failures in the current Replicat run.

Total column data truncation: the number of times that column data was truncated in the current Replicat run as the result of character set conversion

REPORTDETAIL | NOREPORTDETAIL

Controls whether or not the output includes operations that were not replicated as the result of collision errors. These operations are reported in the regular statistics (inserts, updates, and deletes performed) plus as statistics in the detail display, if enabled. For example, if 10 records were insert operations and they were all ignored due to duplicate keys, the report would indicate that there were 10 inserts and also 10 discards due to collisions. The default is REPORTDETAIL.

REPORTRATE {HR | MIN | SEC}

Displays statistics in terms of processing rate rather than absolute values.

HR: Sets the processing rate in terms of hours.
MIN: Sets the processing rate in terms of minutes.
SEC: Sets the processing rate in terms of seconds.

Examples

The following example displays total and hourly statistics per minute for a specific table, and it also resets the latest statistics. Statistics for discarded operations are not reported.

STATS REPLICAT finance, TOTAL, HOURLY, TABLE sales.acct, REPORTRATE MIN, RESET, NOREPORTDETAIL

The following example displays the same statistics as the previous example, but for thread 3 of a coordinated Replicat group.

STATS REPLICAT fin003, TOTAL, HOURLY, TABLE sales.acct, REPORTRATE MIN, RESET, NOREPORTDETAIL