RepAgent scan_verbose Parameter
In addition to the same output as the scan parameter of sp_help_rep_agent, the scan_verbose parameter displays the number of log pages to be processed by the Adaptive Server RepAgent from the current marker to the end of the log.
See the scan_verbose parameter of sp_help_rep_agent in the Replication Server Reference Manual.
Example
For
example, scan_verbose displays the scanning information for a
multithreaded RepAgent with two replication paths and the default path, and with
multiple scanners, and displays a count of the log pages to be processed from the
current marker to the end of the log—see the log pages
left
column.
sp_help_rep_agent pdb2, 'scan_verbose'
You
see:
Replication Agent Scan status dbname pathname scanner_spid start_marker end_marker ------ -------- ------------ ------------ ---------- pdb2 default 34 (1099,0) (1113,1) pdb2 path1 35 (1099,0) (1113,1) pdb2 path2 36 (1099,0) (1113,1) current_marker log_pages_left log_recs_scanned -------------- -------------- ---------------- (1113,1) 0 125 (1113,1) 0 125 (1113,1) 0 125 oldest_transaction ------------------ (0,0) (0,0) (0,0)