Return
-
Title
How to view SharePlex Compare/Repair and Copy/Append Jobs status, details and progress -
Description
How to view SharePlex Compare/Repair and Copy/Append Jobs status and progress -
Resolution
Each time compare, repair, copy, and append job is issued, it is assigned unique job ID. The job IDs reflected in the compare, repair, copy, or append status command output.
- To view compare/repair job, issue:
- sp_ctrl> compare status
- sp_ctrl> repair status
- To view copy/append job, issue:
- sp_ctrl> copy status
- sp_ctrl> append status
- To view detail status of jobs, issue:
- sp_ctrl> <compare | repair | copy | append> status detail
- To view specific job and its details, issue:
- sp_ctrl> <compare | repair | copy | append> status <job_id>
Example:
sp_ctrl (l14:8624)> repair status 6Job ID : 6PID : 18090Host : 114Started : 18-JAN-16 08:22:26Job Type : RepairStatus : Done - 1 object completedID Tablename Status Time Total Rows %Comp Total Time------ ------------------------------------ ---------- ---------- ---------- ----- ----------1 "SP"."DEMO_SRC" Repaired N/A 0 100 0:15- sp_ctrl> <compare | repair | copy | append> status detail <job_id>
Example:
sp_ctrl (l14:8624)> repair status detail 6Job ID : 6PID : 18090Host : l14Started : 18-JAN-16 08:22:26Job Type : RepairStatus : Done - 1 object completedTable ID : 6.1Table : "SP"."DEMO_SRC"From : l14@o.ORA11GR2To : "SP"."DEMO_DEST862" l15@o.ORA11GR2Started : 18-JAN-16 08:22:29Percent complete : 100%Total Rows : 0Rows processed : 0Rows out-of-sync : 0Status : RepairedStatus Elapsed : N/ATotal Elapsed : 0:15 - To view compare/repair job, issue: