Archives of the TeradataForum
Message Posted: Thu, 20 Mar 2008 @ 16:48:48 GMT
This lock table is for transaction locks, so there shouldn't (that famous word !) be any locks left over. They're not like Multiload or ARC etc locks that get placed into the table header.
Is this error always happening on the same AMP, or is it spread around ? You should be able to tell this by looking in dbc.software_event_log - I seem to remember that this message is recorded there.
It looks like you've got a single transaction which is doing LOTS of insert/update/delete requests. Have you installed a new version of an application recently ? i.e. what has changed.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|