Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Friday 24 July 2015

RELEASE MLOAD in Teradata

When your mload goes not get complete and stops abruptly then there might be changes that mload will lock the base table and you would need to release it manually.

Syntax to release the mload is:-

RELEASE MLOAD databasename.tablename;
 
If our job fails at our application phase, we have to release the lock on the mloaded table.

RELEASE MLOAD databasename.tablename IN APPLY;
 
This statement obtains the Exclusive lock over target tables and frees the target table from any kind of locks.
 
Once you release mload you have to drop all worktables, 
logtables and error tables and start from the beginning.  

No comments:

Post a Comment

Please provide your feedback in the comments section above. Please don't forget to follow.