How to Stop Copy/Append Processes.
A job id is created for each "copy / Append" cmd run on the sp_ctrl prompt and canceling that job will abort the copy process.
Here is an example for the copy process and the canceled job.
sp_ctrl (irvsupu16:8496)> copy splex.demo_src to splex.demo_src
copy started; job id 17
sp_ctrl (irvsupu16:8496)> copy status
Job ID : 17
Host : irvsupu16
Started : 25-SEP-08 06:18:22
Job Type : Copy
Status : Handshake
ID Tablename Total Rows %Comp Status Status Time Total Time
------ ------------------------------------ ---------- ----- ---------- ----------- ----------
1 "splex"."DEMO_SRC" 100000 Init 0:05 0:05
--Copy cmd running. Canceling the copy job 17.
sp_ctrl (irvsupu16:8496)> cancel 17
Canceled job 17
sp_ctrl (irvsupu16:8496)> copy status
Job ID : 17
Host : irvsupu16
Started : 25-SEP-08 06:18:22
Job Type : Copy
Status : Job canceled by user
ID Tablename Total Rows %Comp Status Status Time Total Time
------ ------------------------------------ ---------- ----- ---------- ----------- ----------
1 "splex"."DEMO_SRC" 100000 Locked 0:05 0:18
-- Status above displays "job canceled by user"
sp_ctrl (irvsupu16:8496)> copy status
Job ID : 16
Host : irvsupu16
Started : 25-SEP-08 06:14:15
Job Type : Copy
Status : Job canceled by user
ID Tablename Total Rows %Comp Status Status Time Total Time
------ ------------------------------------ ---------- ----- ---------- ----------- ----------
1 "splex"."DEMO_SRC" 100000 Aborted N/A 0:24
-- In some cases, it also shows the status as aborted. Even in that case, job gets canceled
