To find out how many rows are out of sync for a table in SharePlex replication, run following command in sp_ctrl after you have run a compare. This will generate a report showing the number of out of sync rows discovered by the compare process. The ID in the command is the ID given to the compare process when it starts :-
sp_ctrl (uksupu01:7000)> show compare id <PID> detail
Host: uksupu01
ID Tablename Since Repair
-------- ------------------------------------------ ------------------ ------
23595 "DAVE"."DEPARTMENTS" 08-Oct-06 21:10:55 Off
Source table : "DAVE"."DEPARTMENTS"
Target table : "DAVE"."DEPARTMENTS"
Target route : uksupu02@numbers
Where clause :
Select hint :
* Compare Results
*
* 256 row comparisons completed successfully
* 207 out-of-sync rows found in this table.
*
* Inserts : 104
* Updates : 103
* Deletes : 0
More details of the options available with the show compare command can be found in chapter one of the SharePlex reference manual.
