Archives of the TeradataForum
Message Posted: Thu, 20 Feb 2003 @ 14:19:33 GMT
Unfortunately, even if you have your users use views with the 'LOCKING FOR ACCESS' statement in them, Multiload will still wait until their query completes before beginning the load.
The best option I've found so far is to abort user queries during the batch window. You could also set their spool space to 0 temporarily so that they couldn't re-submit their queries. After the loads have completed, you could return their spool space to normal.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|