 |
 |
Archives of the TeradataForum
Message Posted: Fri, 09 Jul 2004 @ 15:27:52 GMT
| Subj: | | Re: How to release locks from a table. |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Friday, July 09, 2004 11:11 -->
| | In Queryman (or BTEQ) -- RELEASE MLOAD MYDATABASE.MYTABLE; If you get an error such as "unable to release multiload..." try RELEASE MLOAD
MYDATABASE.MYTABLE IN APPLY; | |
Releasing a multiload job IN APPLY can be a dangerous thing - you would have no way of knowing how many rows were applied, and mload is
not using the transient journal (no rollback). Indices are also not kept in synch w/ the base table during the apply phase. It is a far better
option to restart the mload if it has failed and let it clean itself up. If you cancel IN APPLY be prepared to restore the table from backup.
| |
