To restart MULTILOAD if it fails in Teradata

MULTILOAD will create 2 error tables, 1 work table if it fails.

To unlock the main table in case of acquisition phase :
RELEASE MLOAD DBNAME.Tablename;

To release lock in application phase failure :
RELEASE MLOAD DBNAME.Tablename IN APPLY;

You should be very cautious using the RELEASE command. It could potentially leave your table half updated. Therefore, it is handy for a test environment, but please don’t get too reliant on it for production runs. They should be allowed to finish to guarantee data integrity.