Archives of the TeradataForum
Message Posted: Wed, 17 Sep 2003 @ 05:12:32 GMT
Has anyone successfully killed "internal session" from PMON/Session Information/TD Manager or any other tool.
We had a bed experience with "internal session". Internal session usually happens when MLOAD failed/aborted.
Such a session can not be see through any of the monitoring tools as TD Manager/Pmon etc.
Only appears when other query tried to access the table that was multiloaded prior to the abend. The same session blocks other query. I can see in PMON "internal session" blocking other User id's session.
I tried to kill "internal session" using the following options:
-TD Manager Remote Console
I couldn't kill the session.
Finally I contacted NCR engineers and they had to restart Teradata RDBMS. I was advise by NCR that internal session can only be remove from the system by restarting RDBMS.
We are running Teradata V2R4.01.03.44
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|