Locking Problem
This seems to me very mysterious:
There is 1 Table "tab1" with no indexes on it, but LOCK MODE ROW.
After the following statements
begin work;
update tab1 set lname = "kkkk" where nr = 10
update tab1 set lname = "kkkk" where nr = 9
onstat -k produced this output:
INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 00:06:20 -- 11312
Kbytes
Locks
address wtlist owner l klist type tblsnum
rowid key#/bsiz
1. 1008bd8c 0 104410e4 0 HDR+S 100002 206
0
2. 1008bdbc 0 104410e4 1008bd8c HDR+IX 200044 0 0
3. 1008bdec 0 104410e4 1008bdbc HDR+X 200044 10f 0
4. 1008be1c 0 104410e4 1008bdec HDR+X 200044 100 0
5. 1008be4c 0 104410e4 1008be1c HDR+X 200044 10e 0
6. 1008be7c 0 104410e4 1008be4c HDR+X 200044 201 0
7. 1008beac 0 104410e4 1008be7c HDR+X 200044 200 0
7 active, 8000 total, 8192 hash buckets
But why did OnLine lock the PAGES 1 and 2 (see 4. and 7.)? The table has
definitely
lock mode row, so i cannot imagine, why online did so. Any ideas?
Christian
-------------------==== Posted via Deja News ====-----------------------
http://www.dejanews.com/ Search, Read, Post to Usenet