Re: onstat -u, B-flag

Alexander Selg (alexander.selg@siemens.at) wrote: : The command "onstat -u" gives some information about the userthreads. In : the 2.column you can see the flags to each thread. The 1.position : indicates the resource a thread is waiting for. : My question is: if there is a "B" on the 1.position, which means the : thread is waiting for a buffer, which buffer is meant - physical log : buffer, logical log buffer, regular buffers ? Regular buffers. : Background: : I have threads, which make deletes of about 3000 rows in a tables of : 3.000.000 rows. Therefor they need 3 - 10 minutes. There are 2 indexes : on each of these tables and no constraints. With onstat -u i see, that : they are sometimes waiting on buffers; so my idea is that waiting for : buffers makes the threads using so much time - any other ideas ? What do you mean by "you have threads"? How do you delete the 3000 rows -- all in one transaction, or different "threads"? What is the WHERE clause on your DELETE? What fields are indexed? Have you turned on SET EXPLAIN? June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.