|
|
|
Junior Member
 
Group: Forum Members
Last Login: 11/1/2009 1:22:16 PM
Posts: 15,
Visits: 77
|
|
Hi All,
Is there any way to stop mload while it is running.Suppose i am loading millions of records,
but unfortunately i dont want to load that records.I want to stop mload.Is it posssible?
Thanks
kiran
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/22/2009 1:29:06 AM
Posts: 36,
Visits: 182
|
|
Hi Kiran,
I m not pretty sure. However if the setting "NOSTOP" is given then it restricts mload from stopping if there is an error
condition for variable-text length record. Check this setting. Secondly, we can use PAUSE ACQUISITION also. It will pause during the acquisition phase. You can kill the PID too if you know.
Rgds,
Raja
Teradata_cert_Oracle_cert
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/30/2009 6:28:19 AM
Posts: 34,
Visits: 117
|
|
Just abort those sessions from Teradata Performance Monitor - if you've access OR ask your DBA to abort.
Also you can grab the PID from UNIX box (from where you've run) and just kill the process.
Don't forget to release mload on tables.
|
|
|
|