RE: onstat -u, B-flag
Alexander,
Your session id 386 is waiting on a buffer, has issued a begin work,
is the primary thread for the session and was executing an rsam call.
You can find what kind of buffer it is waiting by running the following
sql statement.
SELECT is_wbuff , is_wlogbuff FROM syssessions
WHERE sid = 386;
1 means on , 0 means off
The is_wbuff will indicate "waiting ona buffer" ,
The is_wlogbuff will indicate "waiting on a log buffer"
Regards,
Mario Estrada
----------
From: Alexander Selg[SMTP:alexander.selg@siemens.at]
Sent: Tuesday, August 26, 1997 4:28 AM
To: informix-list@rmy.emory.edu
Subject: 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
-------------------------------------------------------------------