Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 19 Oct 2006 @ 19:12:40 GMT


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


Subj:   Re: Failure 2641 was restructured.
 
From:   Diehl, Robert

This means your request was blocked by a query with an exclusive lock on the table because it is restructuring the table. The blocking query is usually an alter table, create index or Create join index which all restructure a table.

You need to find the query that is restructuring the table and schedule your query around that maintenance or eliminate the restructure.


Thanks,

Bob Diehl



     
  <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