Archives of the TeradataForum
Message Posted: Mon, 26 Jul 2004 @ 14:21:16 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|