This is the scenario....
I have three sessions.
Session1: Locked a table TEST in exclusive mode ( Got the lock and
being locked )
Session2: Trying to lock table TEST in exclusive mode with lock
mode wait to ???? ) in wait state
Session3: Trying to lock table TEST in exclusive mode with lock
wait to ???? ) in wait state.
I got entry in syslocks for session1 and session2 with
owner=sid_of_session1 and waitor=sid_of_session2
but there are no entries in syslocks with waitor name as sid_of_session3.
onstat -k shows only wait by session2 not by session3 BUT
onstat -u gives the right information on both session 2 and session 3
with a lock_wait_flag (L).
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at