hi,

The below output shows the number of long spins occured on a resource. how is it possible to reduce these spins.


Informix Dynamic Server Version 9.30.FC2W8 -- On-Line -- Up 1 days 05:14:48 -- 11053768 Kbytes

Spin locks with waits:
Num Waits Num Loops Avg Loop/Wait Name
50 594714338 11894286.76 mtcb vproc_sync_lock
25 5338037 213521.48 mtcb tcb_queue_lock
16 489833 30614.56 mtcb vproc_list_lock
82 4901068 59769.12 mtcb notify_lock
2 21715 10857.50 cond lock, name = netnorm
1 12032 12032.00 tcb lock, tid = 70
3 150022 50007.33 tcb lock, tid = 2935
103049 1295334176 12570.08 shmcb sh_lock
58 904733 15598.84 pool po_lock, name = aio


bye.

Hi Pathri

What is the problem ??

Hi,
The Avg wait/loop column in the output shows that the value is exceeded more than 10000(10000 loops make 1 long spin). This means on the particular resource (in Name column) the system has to wait to acquire it. I want to know what does the names like "mtcb vproc_sync_lock","mtcb tcb_queue_lock","mutex lock, name = tx" mean so that i can increase the values for this parameters to reduce the waits on them.


bye.