onstat -u, B-flag

Hello All ! 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 ? example: ... 21d39090 Y--P--- 327 root - 21ec36a0 0 1 5 0 21d394c8 ---PR-- 362 root - 0 0 1 7654025 3210928 21d39900 Y--P--- 363 root - 22498498 0 1 1838 1184 21d39d38 B--PR-- 388 root - 2023ce34 0 2 2909837 74403 21d3a5a8 B--PR-- 384 root - 201e5fb4 0 2 3214060 9120 21d3a9e0 Y--P--- 510 root - 22b58228 0 1 56 0 21d3b250 --BPX-- 387 root - 0 0 2 532577 388370 21d3b688 B-BPR-- 386 root - 20316d00 0 2 3329603 12160 ... 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 ? We are using INFORMIX 7.21 UD1 on SINIX RM's Thanks, Alexander -- ------------------------------------------------------------------- Alexander Selg | e-mail: alexander.selg@siemens.at Siemens AG Austria | Tel.: +43 1 1707-45960 A-1101 Wien, Gudrunstr. 11 | Fax.: +43 1 1707-55832 -------------------------------------------------------------------