Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 20 Mar 2008 @ 16:48:48 GMT

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

Subj:   Re: Error Code 2971- The AMP Lock Table has Overflowed
From:   DWellman

Hi Bill,

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)

  <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: 23 Jun 2019