Help - Performance problem when opening a CURSOR!

I am running INFORMIX 5.10 on a HP-K220 server with UNIX 10.20. My application(ESQLC) prepares,declares and opens a cursor into a table. The select statement looks like this: SELECT field_1,field_2,....,field_x FROM table WHERE field_2 = ? AND field_n = 'xyz' AND field_o = '123' ORDER BY field_p The OPEN statement looks like this: OPEN cursor_name using $FIELD_2; This works fine most of the time, but sometimes the application is held up waiting on the OPEN CURSOR for as long as 5 minutes. Monitoring it through glance, the sqlturbo spawned by the process is waiting for IO, even though this is the only user process running on the system. I can also see that the disk utilization of the chunk that this table resides on stays about 95% to 100%(which does not happen normally). I have used 'tbcheck -pe' to see if the table had too many extents and found that it always has only 2 extents. The number of rows in the table is not very different when this happens compared to when the system functions normally. I have also found out that dropping the table after unloading the data and doing a dbload to load back the data corrects the problem. Can anybody help me in figuring out what could be causing this hangup. -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own