Archives of the TeradataForum
Message Posted: Thu, 22 Aug 2002 @ 09:25:24 GMT
Subj: | | Re: Question on Deadlock.. |
|
From: | | David Wellman |
Hi,
(1) there is no automatic processing which purges this data. Most sites have their own housekeeping routines which will archive/purge
various system tables. I'm guessing that your site has one of these.
(2) You may find that the deadlock is not on the tables explicitly named in the Mload script but is actually on one of the dictionary
tables. What release of Mload and Teradata are you running?
Dave
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|