Openedge 10.1C SP3
HPUX
Using promon to view the record locking table, several lines appear with chain type "TAB". No rec-id is mentioned, locking is IX (Intent eXclusive lock).
Example:
The manual only says chain type should always be "REC".
Does anyone have an idea what this means? The table in question IS causing us some locking problems, so I'm worried about these lines...
Thanks for your reply,
Rob Jaeken
This happens is 2 possible places: When a DELETE statement is in the middle of a large transaction block or during a SQL92 transaction.. For more information have a read of KB article P37194 or if you search for 'IX in promon locks' you will find a range of articles about it.