show reconcile

Syntax

show reconcile job_name history_id comparison_name target_index script_type

show reconcile is applicable only to row comparison jobs; it does not work with schema comparison jobs.

Parameters

job_name – the name of the job for which to show the reconciliation script.
history_id – the job history sequence ID of the reconcile script to be shown.
comparison_name – the name of the job comparison.
target_index – the index of the target. Use zero (0) for the first target.
script_type – the type of script to return: insert, update, or delete.

Examples

Example 1 – shows the reconciliation scripts for “job6” with history ID 29:

show reconcile job6 29
go

The returned result is:

COMPARISON TARGET              START TIME          FINISH TIME         R TYPE   SCRIPT
---------- ------------------- ------------------- ------------------- - ------ --------------------------------------------------------------------------------------
cmp6       pluto:5000/dbo.cust 2012-11-06 11:53:02 2012-11-06 11:53:02 9 INSERT /Sybase/DA-15_5/server/myserver/data/job6/2012-11-06/11.52.56.458/cmp6_T_recon_ins.sql

The Type column shows the type of SQL statement (insert, update, or delete) and the script file name contains an ins, upd, or del indicator.

If the reconcilation type is automatic, the output is shown as:

COMPARISON TARGET START TIME          FINISH TIME         R TYPE SCRIPT
---------- ------ ------------------- ------------------- - ---- -------
cmp6       0      2012-08-31 12:39:31 2012-08-31 12:39:34 8 AUTO N/A

Example 2 – shows the insert reconciliation script for the cmp1 comparison in the job6 with history ID 29:
```
show reconcile job6 29 cmp1 0 insert
go
```
This command returns multiple rows of content columns, such as:
```
CONTENT
------------------------------------------------------------------------
Replication Server Data Assurance Option - DA Server/15.7.1 /SP100/B/generic...
Reconciliation Script (Auto-generated); reconciles 9 missing row(s). 
```