Lock types

Posted in 1993

Clay Irving — 6 Jul 1993 16:01:25 -0400 — source: Informix-list mailing list archive (1991-1998)

I tried to to select the count of the number of rows in a table this afternoon and I received a message from ISQL that the table was locked. I ran 'tbstat -k' and received the following: RSAM Version 5.00.UC2 -- On-Line -- Up 7 days 05:12:00 -- 6208 Kbytes Locks address wtlist owner lklist type tblsnum rowid size 3002c4dc 0 30002040 0 HDR+S 1000002 202 0 3002c83c 0 300020ac 0 S 1000002 203 0 3002c87c 0 30001efc 3002cd1c HDR+IX 10002a1 0 0 ^^^^^^^^^^^^^^^^^^^^^^^^ 3002c8bc 0 30001efc 3002cd3c HDR+IX 100029a 0 0 ^^^^^^^^^^^^^^^^^^^^^^^^ 3002cb5c 0 30001e24 0 HDR+S 1000002 203 0 3002ccdc 0 30002184 0 S 1000002 203 0 3002cd1c 0 30001efc 0 S 1000002 203 0 3002cd3c 0 30001efc 3002c87c HDR+U 10002a1 109 0 3002cdbc 0 30001ce0 0 S 1000002 203 0 3002ce7c 0 30001efc 3002c8bc HDR+U 100029a 10a 0 10 active, 100000 total, 8192 hash buckets The underlined locks are giving me a problem -- Can someone explain what a 'header intent exclusive' lock is? The documentation doesn't explain... Thanks! -- Clay Irving New York, NY "Everything should be made as simple as possible, but not simpler." Einstein