Archives of the TeradataForum
Message Posted: Thu, 22 Aug 2002 @ 09:25:24 GMT
(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?
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|