Thursday, 25 October 2012

My table got locked during MLOAD due to a failed job. What do I do to perform other operations on it?

Using RELEASE MLOAD. It removes access locks from the target tables in Teradata. It must be entered from BTEQ and not from MultiLoad.
To proceed, you can do RELEASE MLOAD <table name>

No comments: