Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 05 Aug 2015 @ 22:00:58 GMT


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


Subj:   Re: Checktable error 2741: Table header not found
 
From:   Clark, Dave

Roopalini-

The 2741 error is indicating that a table header is missing on one or more AMPs. The "pending lock" message is indicting that you have an outstanding Host Utility (HUT) lock on the tables. My guess is that these messages are associated and someone has attempted a load job that was either terminated or failed. The log files (/var/log/messages) may shed some light on this. The simplest resolution is to release the lock(s) and drop the table(s) but you should check with your users to determine what happened and why. Another option is to restart the load jobs if you can identify the responsible user and locate the load job. The GSC can help here if you need guidance.


-dave.clark



     
  <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