Use STATS REPLICAT
to display statistics for one or more Replicat groups. Thread statistics for a coordinated Replicat group are provided as follows.
The difference between the maximum lag and the minimum lag among all threads.
The total number of coordinated DDL transactions.
The total number of coordinated transactions that involved an update to a primary key.
The total number of coordinated EVENTACTIONS
events.
The total number of coordinations that were explicitly requested in the configuration by means of the COORDINATED
option of the MAP
parameter.
The average time (in seconds) spent in coordination among all threads.
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 example STATS REPLICAT finance, TOTAL, DAILY.
Valid values are:
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
]
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
]
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 DELROWEXISTS
conflicts
CDR DELROWMISSING
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
. See also "STATOPTIONS".
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.
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