R
Rob Fitzpatrick
Guest
DLC: 11.6.0 64-bit OS: AIX 7.1 I'm querying _trans and _lock at a client site and seeing data I don't understand. In an active transaction, I see multiple locks (so far no mystery). But in addition to record locks, I see partition and table locks; all of the partition and table locks have flags intent exclusive and limbo. The data looks like this: Type RECID Flags Table -------- --------------------- ---------- ------ REC 73465669 X L 437 TAB 0 IX L 437 PART 0 IX L 452 REC 73995436 X L 477 REC 74900888 X L 433 TAB 0 IX L 433 TAB 0 IX L 452 TAB 0 IX L 480 TAB 0 IX L 477 REC 74446879 X L 445 TAB 0 IX L 445 REC 74900883 X L 433 REC 74809996 X 198 PART 0 IX L 445 PART 0 IX L 477 REC 74900887 X L 433 PART 0 IX L 461 PART 0 IX L 433 REC 74900886 X L 433 TAB 0 IX L 421 REC 74900880 X L 433 TAB 0 IX L 461 REC 74282016 X L 452 PART 0 IX L 480 PART 0 IX L 421 PART 0 IX L 458 REC 74900885 X L 433 REC 74907916 X L 461 REC 74900889 X L 433 REC 73497252 X L 421 REC 74900881 X L 433 TAB 0 IX L 458 REC 74900882 X L 433 PART 0 IX L 437 REC 74108513 X L 480 REC 74900884 X L 433 REC 5515976 X 49 REC 74900890 X L 433 REC 74671320 X L 458 So my questions: Why am I seeing table locks? It is my understanding that you can't take table locks from ABL. Why am I seeing partition locks? This is not a partitioned or MT database. Thanks.
Continue reading...
Continue reading...