Archives of the TeradataForum

Message Posted: Mon, 26 Jul 2004 @ 14:21:16 GMT

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

Hi,

I have a session started 3 days ago, which actually does nothing but its state in displayed as AMP State = IDLE and PE State = ABORTING in Performance Monitor. This session is blocking any possible operations on some table and it is not possible to abort the session. Only SELECT statement runs on the table. Also it is not possible to drop the table.

Is there any way to close the session? I restarted the computer that was a logon source for this session but this also didn't help. Any ideas?

TIA,

Marek

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