关于解除锁表时的二个问题

xlife 发表于 2007-06-12 11:12

１、在解决锁表时在systables中找出表对应的partnum时，发现值是0，然后我看了一下systables，竟然有多个表的partnum都是０，请教，partnum倒底代表什么？不应该是唯一的吗？如果是0，我怎么对此表解锁？
２、是否锁定的表都会出现在sysmaster库的syslocks表中？请大家指教，谢谢。

xlife 发表于 2007-06-14 09:08

没有兄弟解答吗，大家给些相关知识的资料或链接也好的

白云发表于 2007-06-14 10:23

select
   dbsname,
   b.tabname,
   rowidr,
   keynum,
   e.txt       type,
   d.sid       owner,
   g.username    ownername,
   f.sid       waiter,
   h.username    waitname
from
   syslcktab    a,
   systabnames b,
   systxptab    c,
   sysrstcb    d,
   sysscblst    g,
   flags_text    e,
   outer ( sysrstcb f , sysscblst h)
where
            b.dbsname <> "sysmaster"
   and a.partnum = b.partnum
   and a.owner = c.address
   and c.owner = d.address
   and a.wtlist= f.address
and d.sid = g.sid
and e.tabname = 'syslcktab'
and e.flags = a.type
and f.sid = h.sid
   and b.tabname='xxxxx'

heijieweb 发表于 2007-06-15 22:00

是零的说明该表可能是hal虚表

gzhu 发表于 2007-06-26 04:45

sometimes the value of partnum is 0

for example, the table has been fragged.

czw1413_cn 发表于 2007-06-27 13:22

页: [1]

Chinaunix's Archiver

关于解除锁表时的二个问题

sometimes the value of partnum is 0