Archives of the TeradataForum

Message Posted: Fri, 14 Jul 2006 @ 09:43:14 GMT

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

Hi Anomy.Anom

Please refer this mail.

Do you mean how to find out whether the particular session is blocked or not? if that is the case then you can check it from your PMON (Teradata Performance monitor). And below are the steps how to check your blocked / un blocked sessions.

1. Logon to the PMON.

2. Click in the "Session" button from the window.

3. Now you can find out all the Users which has been logged presently in the "Users:1" list box.

4.Once you click on any of the sessions from the "Users:1" list box, its status will be shown in the "Blocked" and "Blocking" list boxes

And also the blocked and blocking sessions in two different list boxes just right side of "User:1" list box.

I hope this can help you a lot.

Bye

With Regards ,

Girish Chandra Nayak,
Software Engineer

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