Running select while mload

Tools

Running select while mload

Hi Guys

Sorry for this question but I'm newbie in Teradata and did not find the answer to this in the FAQ / formal articles.

The issue is about the ability to run "select ....order by" on a table that is being loaded in parallel by mload.

(1) if - while running a select stmt which is in the process of returning records - we start mload (to the same table), what will happen?
(2) if - while running mload - we start running a select on the same table, what will happen?

Thanks

Raz

2 REPLIES
Enthusiast

Re: Running select while mload

Assuming the select statement is with default (read) locking...

(1) Mload will wait until the select statement finishes.
(2) The select statement will wait until Mload finishes.

Re: Running select while mload

If you declare a read access lock before doing your select you can read all commited data before the lock is released by mload. Other than that you have to wait until lock is released.