Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 11 Feb 2011 @ 01:15:55 GMT


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


Subj:   Re: RELEASE MLOAD taking abnormally long
 
From:   Steve Hager

To provide the most hands off restart of abended MLOADs we implement a BTEQ step in advance to RELEASE MLOAD. Knowing that RELEASE MLOAD requires an EXCLUSIVE LOCK we first check for the presence of the (job-specific) MLOAD LOGTABLE. If the LOGTABLE is present, we then attempt the RELEASE MLOAD (with appropriate error checking for return codes 2571, 2572, and 2580). If not present, we skip the (unnecessary) RELEASE MLOAD thus eliminating the likelihood of contention between users holding the many access locks found in a 24x7 environment.


Steve Hager



     
  <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: 15 Jun 2023