Archives of the TeradataForum

Message Posted: Tue, 19 Aug 2003 @ 15:37:03 GMT

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

I'm sure that this request seems redundant, but when your problem session is logged-on and holding a lock, would you run the following query for the user in question?

sel sessionno
  , options

  from dbc.sessions

  where username = 

  order by 1;

The point of this is that character 1 of OPTIONS indicates the current session mode (call me paranoid, but what it's supposed to be may not match the actual setting):

'A' = ANSI
'T' = Teradata

FWIW: character 2 of OPTIONS indicates the current 2PC mode:

'2' = 2 phase commit
'N' = Non-2 phase commit

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