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.