 |
 |
Archives of the TeradataForum
Message Posted: Thu, 21 Dec 2006 @ 19:54:14 GMT
| Subj: | | Re: Mload and BTEQ update script contention |
| |
| From: | | Dieter Noeth |
Mark Jahnke wrote:
| | What will happen if an BTEQ script is updating a table, and then an Mload comes in to the same table and tries to update it? | |
MLoad applies special locks to the table header, which prevents DDL. And it requests an access lock, which is upgraded to a write lock at the
beginning of Application Phase.
So it's probably running until begin of the application phase and then it's blocked until BTEQ finishes.
| | Alternatively, what will happen if the Mload is updating a table and a BTEQ script tries to update the table. | |
BTEQ is blocked until MLOAD finishes, if MLOAD is already in the Application Phase.
Dieter
| |
