not able to release MLOAD

Database
Enthusiast

not able to release MLOAD

Hi All,

I am not able to release MLOAD.
I have tried forcefull release as well.

release mload mload_name in apply

It's thrwoing error message: 2571 : Mload is still active on target table.

Any idea.

3 REPLIES
Enthusiast

Re: not able to release MLOAD

Try
Release mload DBNAME.Tablename in apply;
Enthusiast

Re: not able to release MLOAD

Tried as well.....
But it's not working.....
Enthusiast

Re: not able to release MLOAD

From remote console try to see the staus of this MLOAD

TeradataManage > Administer > Database Console > Utilities > QurySess

Check the status of the working table and seee if it is still running and is inwhich phase. Also see if any write lock has been placed on this tables or not. If yes then From arcmain

release the lock on the working table or UV table if any.

You can also display the locks using the ShowLock from DatabaseConsol > Utilities > Show Locks

Then try to fire release mload in apply phase