The rs_ticket_history report describes the time that the ticket data took to pass through each Replication Server module from the time stamp reported by the ticket at each module. The report is generated by the rs_ticket stored procedure. See “rs_ticket,” in Chapter 6, “RSSD Stored Procedures” in the Replication Server Reference Manual.
You can calculate the total replication duration from the times reported by a ticket at the primary and replicate databases. In the report, the columns are:
cnt – the ticket sequence number
pdb_t – the time the rs_ticket stored procedure was executed at the primary database
rdb_t – the time the ticket arrived at the replicate database.
ticket – information about the ticket, including the time that it passed through each module.
cnt pdb_t rdb_t --- ------------------- ------------------- 1 Jan 19 2010 2:17AM Jan 19 2010 2:17AM ticket ----------------------------------------------------------- V=2;H1=profile1;H2=start;PDB(pdb)=01/19/10 02:17:19.406; EXEC(40)=01/19/10 02:17:19.423;B(40)=1332; DIST(26)=01/19/10 02:17:19.669; DSI(35)=01/19/10 02:17:19.916; DSI_T=1;DSI_C=3;RRS=SAMPLE_RS_XIEL cnt pdb_t rdb_t --- ------------------- ------------------- 2 Jan 19 2010 2:20AM Jan 19 2010 2:20AM ticket ------------------------------------------------------------- V=2;H1=profile1;H2=end;PDB(pdb)=01/19/10 02:20:32.206; EXEC(40)=01/19/10 02:20:32.211;B(40)=5044893; DIST(26)=01/19/10 02:20:32.249;DSI(35)=01/19/10 02:20:32.524; DSI_T=5410;DSI_C=18297;RRS=SAMPLE_RS_XIEL
