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 theMAP
parameter. - Average Coordination Time
-
The average time (in seconds) spent in coordination among all threads.
Syntax
STATS REPLICAT group_name
[, statistic]
[, DDLSONLY]
[, 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.
- DDLSONLY
-
Displays the statistics for DDL statements including number of DDL statements in a readable format.
-
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.
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
Parent topic: Admin Client Command Line Interface Commands