Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 05 Aug 2015 @ 22:02:17 GMT

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

Subj:   Re: Checktable error 2741: Table header not found
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, August 05, 2015 17:26 -->

The 2741 can indicate that a DROP TABLE was in process at the exact instant checktable processed it. It can also occur if you did a restore of DBC but have not done a subsequent COPY/RESTORE for this object. Or it could be a problem. You should determine whether the table is supposed to exist and if so, recover it; if not, be sure the dictionary entry is dropped.

Pending Lock means FastLoad / TPT LOAD or MultiLoad / TPT UPDATE in progress. If retry is enabled, checktable will keep trying in case the utility job has finished in the meantime.

  <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