Archives of the TeradataForum
Message Posted: Wed, 05 Aug 2015 @ 22:02:17 GMT
| 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.