Archives of the TeradataForum

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

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

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.

Cheers,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

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