All Forums Tools
kiranparsha 16 posts Joined 04/09
11 Aug 2009
Mload Issue

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?Thankskiran

Raja_KT 1246 posts Joined 07/09
12 Aug 2009

Hi Kiran, I m not pretty sure. However if the setting "NOSTOP" is given then it restricts mload from stopping if there is an errorcondition 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

Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

ANIMESH.DUTTA 35 posts Joined 05/09
21 Aug 2009

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.

Animesh Dutta
Teradata Certified Master

You must sign in to leave a comment.