Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 08 Mar 2002 @ 14:07:12 GMT


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


Subj:   Blocking problems
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, March 08, 2002 08:25 -->

Hello all,

How have folks enforced batch windows where you are loading with Multiload. We are having issues of user sessions blocking the '.END MLOAD' statement, even though they are using access locks. MLOAD needs an exclusive lock for this step.

I have given some thought to setting up a shell script in cron that uses bteq to build the necessary abort session commands and passing them in on the command line to csnrun. The draw back of this it that it's a hard window instead of event driven off the MVS Mload jobs. Is anyone doing something like this? It would be nice to abort sessions from MVS because then it could be event driven off of the load jobs since they vary a little bit in time that they actually run each day. All ideas appreciated........!



     
  <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: 27 Dec 2016