Archives of the TeradataForum

Message Posted: Thu, 14 Aug 2003 @ 14:13:43 GMT

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

I think the answer would be 'it depends'.

Using Gtwglobal you can only kill sessions that are on that specific gateway.

Using PMON you are issuing a command to the DBS itself - this command can come from any host and kill a session that comes from that, or any other, host. (Including mainframe, channel connected sessions.)

In order to use PMON your LAN host must be up, and there must be available MONITOR sessions. (There are 5 per PE) It is also possible that PMON could be blocked if someone applies a write lock to the DBase or TVM dictionary tables. (Not often ... but it can happen.)

Finally, PMON offers you more insight into what the session is doing. You can see what it is executing and how far through the process it is (using the Display SQL/Explain option). It is generally a good idea to check this before aborting a session - it may be about to complete a massive update operation that would cause a long rollback, etc.

Personally I would always use PMON ... but I may be a little biased since I wrote it.

Mike Dempsey
Teradata Client Tools

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