Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 20 Feb 2003 @ 14:19:33 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: User Queries holding out Batch
From:   Tobi Zappe


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.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020